raaj
Follow / 18 May 2018 at 2:47pm / Toad Data Modeler
Latest post by on 21 May 2018 at 6:36am

How to maintain data models using version control system in TDM ?

Expand content
Hello, Does anyone knows how to use version control systems in TDM. I am trying to find out is there any option to control the data models using Version Control Systems. I followed some steps updated...

Hello,

Does anyone knows how to use version control systems in TDM. I am trying to find out is there any option to control the data models using Version Control Systems.

I followed some steps updated in "Help" menu under "Version Control Systems" topic but it didn't help.

1. Settings --> Options --> Version Control Systems --> I picked Type as "Subversion"  <---- Till here I am able to follow , later on in the "Help" menu they asked to fill the user name and password.

2. However I do not see an option to enter the username and pw in my TDM [ Even though If I have that option, how will I get my username and pw ? ]

For now I am saving my data models on my own name , by naming it as XXXXXX_PDM v1.000a , XXXXXX_PDM v1.000b etc..

I believe TDM has some feature on version control between different data models, it would be great if someone helps me on how to maintain the models with version control system in TDM.

Thanks !!

43 1 / Create an account to join the discussion.
anthony.vitale
Follow / 23 Jan 2018 at 3:58pm / Toad Data Modeler
Latest post by on 21 May 2018 at 6:22am

How Do I Make the Workspace I am working on Open when a Model Opens...

Expand content
Hi. I Use a Number of Workspaces in My Model So At Any one Time I am working On a Workspace defined for the Task At hand. Additionally I do not use the All Items Workspace At All, And Given that...

Hi.

I Use a Number of Workspaces in My Model

So At Any one Time I am working On a Workspace defined for the Task At hand.

Additionally I do not use the All Items Workspace At All, And Given that I have close to 1,000 Entities I Find Opening The All Items Workspace to be time Consuming and I immediately close it.

However, Everytime I open the Model within TDM, It always Only Opens the "All Items" Workspace, So I need to wait for the Designer to open and then I need to Open the Workspace I was working on Manually and Close the All Items.

I have to Assume that there is some way I can Control to Have TDM open a Workspace I want on Open of the Model. 

However I may be Wrong.

Please let me know.

1917 3 / Create an account to join the discussion.
raaj
Follow / 15 May 2018 at 4:11pm / Toad Data Modeler
Latest post by on 18 May 2018 at 2:50pm

Question - Export to Excel in TDM

Expand content
Hello, I want to export some entities to excel in TDM. After selecting the table names if I click on Export I am getting below error. Please advise Error : "Excel has not ben reopened"

Hello,

I want to export some entities to excel in TDM. After selecting the table names  if I click on Export I am getting below error. Please advise 

Error : "Excel has not ben reopened"

135 2 / Create an account to join the discussion.
raaj
Follow / 17 May 2018 at 5:21pm / Toad Data Modeler
Latest post by on 18 May 2018 at 1:42pm

How to Display "Default Values" for the attributes in Entity...

Expand content
Hello, By double clicking the entities --> If we go to attributes tab --> I could see Key , Caption, Name, Datatype, P1, P2 etc... along with this I am trying to display "Default Values"...

Hello,

By double clicking the entities --> If we go to attributes tab -->  I could see Key , Caption, Name, Datatype, P1, P2 etc... along with this I am trying to display "Default Values". Please advise is there any option in TDM to display "Default Values" for the attributes in the entity properties.

Thanks !!

Rajesh

84 2 / Create an account to join the discussion.
costabas
Follow / 15 May 2018 at 6:00pm / Toad Data Modeler
Latest post by on 16 May 2018 at 8:54am

You left debugging code in the application

Expand content
See the image. I tried to deselect items in the model update wizard dialog. version 6.3.2.22

See the image. I tried to deselect items in the model update wizard dialog.

version 6.3.2.22

142 2 / Create an account to join the discussion.
raaj
Follow / 15 May 2018 at 8:15pm / Toad Data Modeler
Latest post by on 15 May 2018 at 8:28pm

Trigger in TDM for MySQL

Expand content
Hello, Could you please help me to create Triggers in TDM for MySQL. 1. I tried creating After Update Trigger in TDM as below, but I am getting error if I execute this in MySQL. After Update Trigger...

Hello,

Could you please help me to create Triggers in TDM for MySQL.

1. I tried creating After Update Trigger in TDM  as below, but I am getting error if I execute this in MySQL.

After Update  Trigger:

BEGIN

UPDATE customer_wname SET whole_name=CONCAT(NEW.first_name,' ',NEW.last_name,' ',NEW.middle_name) WHERE id=NEW.id;

END;

2. It would be great if someone shares me the instructions on how to use the "Insert Template" and "Open Template Editor" which is available in Trigger properties-->Under SQL tab.

Thanks !!

134 1 / Create an account to join the discussion.
raaj
Follow / 14 May 2018 at 7:58pm / Toad Data Modeler
Latest post by on 15 May 2018 at 6:48am

Page setup in TDM

Expand content
Can anyone suggest me on the perfect font size in TDM [Or] is there any way to create a template with perfect page setup so that we can use the template for creating a different ER diagram. Please advise...

Can anyone suggest me on the perfect font size in TDM [Or] is there any way to create a template with perfect page setup so that we can use the template for creating a different ER diagram. Please advise

Rite now I am following below steps -

File --> Page setup --> Page A4 -->Landscape --> Margin 0.5 for all 4 sides

Thanks !!

Rajesh

137 1 / Create an account to join the discussion.
praladtoad
Follow / 14 May 2018 at 5:17pm / Toad Data Modeler
Latest post by on 15 May 2018 at 6:26am

How to get rid of gridlines from workspace in Toad Modeler 6.4.4?

Expand content
Trying to get rid of those blurry square lines and notations like (1,1) from the workspace

Trying to get rid of those blurry square lines and notations like (1,1) from the workspace  

Unanswered 138 2 / Create an account to join the discussion.
praladtoad
Follow / 14 May 2018 at 8:15pm / Toad Data Modeler
Latest post by on 15 May 2018 at 6:06am

What are the steps to reverse engineer data model from SQL Server...

Expand content
I keep getting this error 'Could not open a connection'

I keep getting this error

'Could not open a connection'

134 1 / Create an account to join the discussion.
Jolene.Jobe-Neuse
Follow / 14 May 2018 at 2:55pm / Toad Data Modeler
Latest post by on 14 May 2018 at 5:01pm

Toad Data Modeler 6.3 - Building a Trigger from the Triggers Tab

Expand content
Hello, All! Attempting to construct a new BEFORE UPDATE trigger for a table in order to maintain an easily searchable audit trail available from the UI. I've seen selectable trigger fire options...

Hello, All!

Attempting to construct a new BEFORE UPDATE trigger for a table in order to maintain an easily searchable audit trail available from the UI.  I've seen selectable trigger fire options BEFORE & AFTER while working with other modelling tools; here, I only see AFTER & INSTEAD OF.  Usually, I'd create a trigger to write to the audit table BEFORE an existing record was updated to preserve it.  Is that what the INSTEAD OF trigger fire option is for?

Or, because the UPDATE event inserts into BOTH Inserted & Deleted tables, the AFTER trigger fire option will read from the Deleted table & insert that 'old' record into the history table?

Thank you for your assistance!

Answered 165 2 / Create an account to join the discussion.
raaj
Follow / 11 May 2018 at 1:29pm / Toad Data Modeler
Latest post by on 11 May 2018 at 4:40pm

Option "Save model as" is missing in TDM 6.3.2

Expand content
Hello, I installed trial version of TDM 6.3.2 and started creating some DM. Initially I saw save model as lateron "Save Model as" option is missing, instead I could see "Export Model As"...

Hello,

I installed trial version of TDM 6.3.2 and started creating some DM. Initially I saw save model as lateron "Save Model as" option is missing, instead I could see "Export Model As". Could you please help me how to find "Save Model As" option.

I want this option to save my model whenever I modify/add the models to generate alter script.

Thanks !!

Rajesh

Answered 193 2 / Create an account to join the discussion.
jess.rabida@talavant.com
Follow / 10 May 2018 at 4:13pm / Toad Data Modeler
Latest post by on 11 May 2018 at 7:28am

Copying objects to models within projects

Expand content
Hello, I have several questions with working within projects. Currently, I have several models within my project, one for each subject area, I know I could have broken them out into workspaces, but it...

Hello, 

I have several questions with working within projects. Currently, I have several models within my project, one for each subject area, I know I could have broken them out into workspaces, but it would have made my model huge and I wasn't sure if there was performance impacts.

1) Is there project level objects we can create that can easily be duplicated in each model?

2) I have categories that I would like to export or copy to other models within my project.  I haven't been able to find a way to do this. I have to keep manually creating in each of my models when I add new category and I am afraid I am going to miss adding it to one of my models since I maintain 4 of them in my project. 

3) I have a worokspace for date dim with many role playing dimensions, I want this workspace linked in every model and have any changes to one reflected in all the other models. Is this possible?

My current layout is for a data warehouse, star schema, I chose to create model per subject area, we have a lot of common dims that cross fact tables, but we also have a lot of subject areas and fact tables that aren't related at all. 

Within each model I create a workspace for each fact table. Sometimes there are 6 or more facts.

But, there are similarities among each of the models within my models (below) and there are many differences too.

   1) They should all have the same categories

   2) They all should have the same common dimensions

   3) They should all have the same date dim role playing workspace I discussed above.

My question is, would you recommend creating a project that contains a separate model per subject area or just have everything in one model? but then I guess what is the point of projects?

Is there an easy way to link categories, common workspaces, etc. like at a project level so if i change anything there it propagates to all my other models? Right now I am currently maintaining this manually and it is becoming tedious.

211 1 / Create an account to join the discussion.
jess.rabida@talavant.com
Follow / 10 May 2018 at 3:52pm / Toad Data Modeler
Latest post by on 11 May 2018 at 7:06am

Repeatedly creating relationships in Workspace

Expand content
Hello, I am sorry if this has been asked already, I tried searching for this question, but just couldn't find anything. Is there a keyboard shortcut to create relationships? I find when I am working...

Hello, I am sorry if this has been asked already, I tried searching for this question, but just couldn't find anything.

Is there a keyboard shortcut to create relationships?  I find when I am working in a Workspace I want to create relationships for several tables, but soon as I do this for one relationship the focus changes back and I have to click the relationship icon again in order to create another relationship. I would like the focus to stay on the relationship I am working with so I can quickly move from one table to the next.

219 1 / Create an account to join the discussion.
bscollard
Follow / 4 May 2018 at 7:03pm / Toad Data Modeler
Latest post by on 9 May 2018 at 3:18pm

Right-Click on entity in model, then DELETE Object. Seems to remove...

Expand content
I have an entity named NODE with an attribute NODE_ID in it. This attribute NODE_ID is also found in several other tables. Th reason I want to delete the entity is that changes have been made in the...

I have an entity named NODE with an attribute NODE_ID in it. This attribute NODE_ID is also found in several other tables.

Th reason I want to delete the entity is that changes have been made in the source data base to that entity and I wanted to update the model with the new foreign keys that did not exist before. To do this I opened my data base connection wizard and got the list of entities; then select my NODE entity and dragged it to add into the model. It immediately showed error log entries indicating that connections could not be made to associated tables because the underlying attribute NODE_ID was missing. Those attributes were certainly there previously!

I have embarked on no other delete transactions. It appears that delete object NODE removes ATTRIBUTES containing the text 'NODE'  too in tables other than NODE???

How can this be? I admit to being a newer user of TDM, but this behaviour has me stumped.

Unanswered 280 2 / Create an account to join the discussion.
heros
Follow / 7 May 2018 at 9:53am / Toad Data Modeler
Latest post by on 9 May 2018 at 12:50pm

Can't Install TDM (toaddatamodeler_6.3.2.22_x64_en.msi) on Windows...

Expand content
Hi, Please help me out the installation issue. My server is Windows Server 2016 64-bit with .Net Framework 3.5 installed. However I cannot install TDM. If I double click in the MSI file for installing...

Hi,

Please help me out the installation issue.

My server is Windows Server 2016 64-bit with .Net Framework 3.5 installed.

However I cannot install TDM.

If I double click in the MSI file for installing, it's silent without any messages.

If I run MSI file on cmd with Administrator, it says "Access is denied".

How can I process this issue?

I want to try before bying TDM.

Best regards,

Hung

Unanswered 244 1 / Create an account to join the discussion.
Geraldo Peralta
Follow / 2 May 2018 at 5:47pm / Toad Data Modeler
Latest post by on 2 May 2018 at 10:03pm

Add TablespaceAssignment Package to Toad Data Modeler

Expand content
Hello, Community. I am building a ER Diagram to be deployed to an Oracle DB 12cR2 database. In TDM, I canot see where I can add a tablespace to be used for the different objects (tables, indexes and...

Hello, Community.

I am building a ER Diagram to be deployed to an Oracle DB 12cR2 database. In TDM, I canot see where I can add a tablespace to be used for the different objects (tables, indexes and so on). I tried to add TablespaceAssignment package bu I got an error: 

Extended package with Id ={3024A445-2DF4-4946-8F66-7E165D07D973} has not been found.

Thanks,

328 2 / Create an account to join the discussion.
manojmukkamala
Follow / 25 Apr 2018 at 4:56pm / Toad Data Modeler
Latest post by on 26 Apr 2018 at 3:57pm

Toad Data Modeler - Internal Error

Expand content
Hi, I was trying to connect MS SQL Server 2012 database to Toad Data Modeler but I am getting the following error: Could someone please help.

Hi, I was trying to connect MS SQL Server 2012 database to Toad Data Modeler but I am getting the following error:

Could someone please help.

510 2 / Create an account to join the discussion.
Jhonny Dante
Follow / 25 Apr 2018 at 2:22am / Toad Data Modeler
Latest post by on 25 Apr 2018 at 2:41pm

I CAN NOT OPEN THE REPORT

Expand content
Help please!, report rtf generates successfully, but I can not open the report. Use Toad Data Modeler 6.3.2.22 and office 2016. Thank you very much for the support.

Help please!, report rtf generates successfully, but I can not open the report. Use Toad Data Modeler 6.3.2.22 and office 2016. Thank you very much for the support.

Unanswered 592 5 / Create an account to join the discussion.
gregn
Follow / 17 Apr 2018 at 10:06am / Toad Data Modeler
Latest post by on 17 Apr 2018 at 3:15pm

Role playing dimension - views

Expand content
I want to model role playing dimensions, so have created a view object, selected the dimension table & columns and aliased as necessary in the view attributes tab. Now I can't see how to relate...

I want to model role playing dimensions, so have created a view object, selected the dimension table & columns and aliased as necessary in the view attributes tab. 

Now I can't see how to relate the view to the dimension though, as there isn't a related column dropdown in the "view relationship" dialog and a normal non-identifying relation won't stick to a view object?

How do I model a role playing dimension.

Toad Modeler Version 6.4.3.16

Physical model for PostgreSQL

Thanks

/g

752 3 / Create an account to join the discussion.
steven.smith
Follow / 12 Apr 2018 at 4:02pm / Toad Data Modeler
Latest post by on 13 Apr 2018 at 6:14am

How Do I Reverse Engineer a PostgreSQL 9.5 DDL file?

Expand content
We're a new Toad Data Modeler customer and was looking to import postgreSQL 9.5 DDLs but don't see it on the database list for DDL reverse engineering, just for database connections. Are there...

We're a new Toad Data Modeler customer and was looking to import postgreSQL 9.5 DDLs but don't see it on the database list for DDL reverse engineering, just for database connections. Are there plans to add that, or is there another way to import a postgreSQL DDL file?

Thank you,

Steven Smith

818 1 / Create an account to join the discussion.