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. |