Configuring Connection Profiles

Before you can connect to a database through a DBMS client or JDBC driver, you must create an appropriate connection profile.

1. Select Database > Configure Connections to open the Configure Data Connections Window, and click the Connection Profiles tab:
   
   
   
2. Click the Add Data Source tool (see Data connection tools) to open a Connection Profile Definition window:
   
   
   
3. Enter the properties (see Connection profile properties) appropriate to your method of connection.
4. Click the Test Connection button to open the Test Connection window, and click OK to test your connection.
   
   
   
5. Click OK to close the profile definition, and return to the Configure Data Connections window
6. Click Ok to return to your model

• Connection Profile Properties
  The following properties are available in the Connection Profile Definition window:
• Connection Parameters Window
  You access this window by clicking the parenthesis tool to the right of the Connection parameters field in the Connection Profile Definition window.
• Native Connection Profile Example
  In the example below, I have installed the Oracle DBMS client, and so create a Native connection to the "Delphes" service.
• JDBC Connection Profile Example
  In the example below, I have installed the Sybase ASE JDBC driver. I specify the appropriate driver class in the jar file, and assemble the connection URL to create a JDBC connection to my database, "Green", on my server "Rainbow".