Managing Models > Model List Overview > Creating a New Model |
Create a new data model using the model generation wizard.
To enter the connection string directly in the Connection String Editor dialog
Sample connection string for SQL server |
Copy Code
|
---|---|
Provider=SQLCLIENT;Data Source=HQ;Initial Catalog=PUBS;User Id=myUsername;Password=myPassword; |
Sample connection string for Oracle |
Copy Code
|
---|---|
Provider=ORACLE;Data Source=MyServiceName;User Id=myUsername;Password=myPassword; |
Tip: You can use any UserContext attribute in the connection string by putting the attribute name between percent signs. For example,
Provider=SQLOLEDB.1;Data Source=HQ;Initial Catalog=%TenantDatabase%; User Id=myUsername;Password=myPassword; |
Notes: If you have a lot of items, you can filter what is shown by entering a value in the Filter Items By Name box. If you do not select any items in this step, you can generate an empty model without any data, and later add data to the model manually. See Adding a New Entity, Adding a New Logical Column (Attribute) and Adding a New Logical Relation for details. |