The Connection Profile Definition window lets you specify all the necessary properties for connecting to your database.
Property |
Description |
---|---|
Connection profile name |
Specifies the name of the connection profile. |
Directory |
Specifies the directory in which the .dcp connection file will be created. By default .dcp files are stored in the Connection Profiles directory directly beneath the PowerDesigner installation directory. |
Description |
Optional additional description of the connection profile. |
Connection type |
The choice of connection type will affect the remaining fields to be completed. |
DBMS type |
Specifies the DBMS to which the connection profile will connect. The list includes only those DBMSs supported for the specified connection type. |
Server name |
[Native only] Specifies the name of the database server to connect to. |
Database name |
[Native only] Specifies the name of the database to connect to. |
Service |
[Oracle Native only] Specifies the service name of the database to connect to. |
User name |
Specifies the username to use when connecting. |
Password |
Specifies the password to use when connecting. |
JDBC driver class |
[JDBC only] Specifies the driver class to use for the connection. |
JDBC connection URL |
[JDBC only] Specifies the connection URL to use for the connection. |
JDBC driver jar files |
[JDBC only] Specifies the driver jar file to use for the connection. |
Connection parameters |
Specifies advanced connection parameters. Click the parenthesis tool to the right of this field to access the Connection Parameters window. |