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 data movement model (DMM) allow you to define data connections for target databases in order to generate your models and reverse engineer your data sources (see Data Modeling and Data Movement Modeling), while the repository requires a database to store your models and other design documents (see 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 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: