Connecting to a Database

PowerDesigner allows you to define data connections to access information in different database management systems (DBMSs) using Structured Query Language (SQL).

A data connection processes function calls and SQL requests coming from PowerDesigner and sends them to a data source, and returns results to PowerDesigner.

The PowerDesigner physical data model (PDM) and information liquidity model (ILM) allow you to define data connections for target databases in order to generate your models and reverse engineer your data sources. The PowerDesigner repository requires a database to store your models and other design documents.

See the Physical Data Model and Information Liquidity Model users guides, and Working with the Repository.

PowerDesigner supports various forms of connection, and your choice will depend on the interface that you have already installed:

For information about connecting with an ODBC driver, see Configuring ODBC machine and file data sources.

For information about connecting with a DBMS client or JDBC driver, see Configuring connection profiles.

• Configuring ODBC Machine and File Data Sources
  There are three types of Open Database Connectivity (ODBC) data sources:
• Configuring Connection Profiles
  Before you can connect to a database through a DBMS client or JDBC driver, you must create an appropriate connection profile.
• Data Connection Tools
  The following tools are available in the Configure Data Connections window:
• Connecting to a Data Source
  When you connect to your database, PowerDesigner can communicate with it for reverse-engineering, generation or any other form of request.
• Running SQL Queries Against Your Database
  You can use the Execute SQL Query dialog to query your database. The following tools are available in the Edit/Run Script editor toolbar: