To import a relational target definition, you must be able to connect to the database from the client machine using a properly configured ODBC data source or gateway. You may also require read permission on the database object.

When you create an ODBC data source, you must also specify the driver that the ODBC driver manager sends database calls to. The following table shows the recommended ODBC drivers to use with each database:

When you use a third-party ODBC data source to import a target definition, the Designer might display a message indicating that the third-party driver is not listed in powrmart.ini. The Designer attempts to import target definition metadata using a driver that is shipped with PowerCenter. If the third-party provides a driver to import metadata, configure powrmart.ini.

For example, if Vendor A provided a driver named

vendoraodbc.dll

, you can add an entry under the ODBCDLL heading based on the specified database:

Vendor A = pmodbc.dll

Vendor A = extodbc.dll

In the example, the Designer directly interacts with the system ODBC drivers to use the ODBC data source. The system ODBC drivers internally interacts with the third-party ODBC driver,

vendoraodbc.dll

.

The following table lists a sample database dependent entry to use with the PMODBC.ini system ODBC driver:

Database	Entry
MySQL	MYSQL = PMODBC.DLL
PowerExchange	PWX = PMODBC.DLL
dBase 4	dBASE IV = PMODBC.DLL
Visual FoxPro	Visual FoxPro = PMODBC.DLL
Sybase IQ	Adaptive Server IQ = PMODBC.DLL
Lotus Notes	Lotus Notes = PMODBC.DLL