In order for Connect to access database tables as sources or targets, the appropriate
database client software must be on the system and accessible via the appropriate shared
library or dynamic link library (dll) paths. The following environment variable must be set
to include the path to the database client libraries and exported on the corresponding
platform:
| Windows | PATH |
| AIX | LIBPATH |
| HP-UX | SHLIB_PATH |
| Linux | LD_LIBRARY_PATH |
| Solaris | LD_LIBRARY_PATH |
On UNIX systems, the variable needs to be set and exported prior to starting the Editor Runtime Service or running Connect tasks or jobs.
Additional client configuration might be required for a specific DBMS. The configuration steps needed to access a specific DBMS are described in the following sections.
The Connect install program assists you with configuring and/or verifying connections to databases.
On UNIX systems, if you wish to configure and/or verify database connections any time after
the installation procedure, run the databaseSetup program as
follows:
cd <connect_install>
./databaseSetup