WarehouseArchitect - User's Guide

Home

Chapter 22: Database Creation and Modification

WarehouseArchitect - User's Guide

Part 3 WarehouseArchitect Model

Chapter 22: Database Creation and Modification

Using the ODBC interface

The Open Database Connectivity (ODBC) interface allows PowerDesigner to access data in different database management systems (DBMS) using Structured Query Language (SQL) as a standard for accessing data.

An ODBC driver processes function calls and SQL requests coming from PowerDesigner and sends them to a data source. It also returns request results to PowerDesigner.

The data source provides all the target database information: its operating system, DBMS, and network platform. You can define more than one data source for the same driver.

Defining a data source

You define data sources using the program ODBC Administrator. PowerDesigner gives you direct access to this program.

To define a data source:
1. Select Database-->Configure Database.
  ODBC Administrator dialog box asks you to identify a data source.
2. Click the Add button.
  A list of available ODBC drivers appears.
3. Click a driver.
4. Click the Finish button.
  A dialog box displays driver-dependent options.
5. Type or select information required by the DBMS.
6. Click OK in each dialog box.

Configuring a data source

To configure a data source:
1. Select Database-->Configure Database.
  A dialog box asks you to identify a data source.
2. Select a data source from the dropdown listbox.
3. Click the Configure button.
  A dialog box displays driver-dependent options.
4. Type or select information required by the DBMS.
5. Click OK in each dialog box.

Connecting to a data source

By connecting to a data source, you can send direct requests to a DBMS.

To connect to a data source:
1. Select Database-->Connect.
  A dialog box asks you to identify a data source and connection parameters.
2. Select a data source from the dropdown listbox.
3. Type your user name and password.
4. Click Connect and, if prompted by your data source, enter additional connection parameters.

Displaying information about a connected database

The extent of information available about a database depends on the DBMS and the ODBC driver in use.

To display information about a connected database:
1. Connect to a data source.
2. Select Database-->Database Information.

Disconnecting from a data source

To disconnect from a data source:
- Select Database-->Disconnect.


	Expand Search