Connection Profile Properties

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

Specifies the type of connection profile. You can choose between:
  • Native

  • JDBC

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.