Chapter 13 Generating a Database from a PDM

Connecting to a Database

PowerDesigner provides various methods for connecting to your database.

Before connecting to your database for the first time, you will have to configure a PowerDesigner connection profile. Your choice will depend on the interface that you have installed:

You have	Configure a connection of type:
ODBC driver	ODBC machine or file data source
DBMS client	Native connection profile
JDBC driver	JDBC connection profile
ADO.NET driver	ADO.NET connection profile
OLE DB driver	OLE DB connection profile
DirectConnect driver	DirectConnect connection profile

For detailed information about creating, configuring, and using connection profiles, see "Connecting to a Database" in the Getting Started with PowerDesigner chapter of the General Features Guide .

To connect to a database:

Select Database→Connect to open the Connect to a Data Source window:

Select one of the following radio buttons, depending on your chosen method for connecting to your database:
- ODBC machine data source
- ODBC file data source
- Connection profile (for native, JDBC, ADO.NET, OLE DB or DirectConnect connections)
You can use the tools to the right of the data source field to browse to a new connection profile file or directory, and the Modify and Configure buttons to modify or configure your data source connection.

Enter your user ID and password, and then click Connect. If prompted by your database, you may need to enter additional connection parameters.

Connection time
You stay connected until you disconnect or terminate the shell session.