Chapter 3 Getting Started with the PowerDesigner Eclipse Plugin


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:

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 and DBMS client ADO.NET connection profile
OLE DB driver and DBMS client OLE DB connection profile
DirectConnect driver DirectConnect connection profile

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, ADO.NET, OLE DB, or DirectConnect driver, see Configuring connection profiles.

 


Copyright (C) 2007. Sybase Inc. All rights reserved.