To configure data sources on UNIX:
Open the $ARBORPATH/bin/.odbc.ini file and add a data source description.
If you add data sources or change driver products or data sources, you may need to edit the .odbc.ini file to update ODBC connection and configuration information, such as data source name and driver product name. Update instructions and requirements vary by platform.
Example: Updating .odbc.ini for DB2
Connecting to a DB2 database named “tbc_data” that is on an isaix7 server
Using an ODBC data source (named “db2data”) that invokes the DataDirect 6.1 Wire Protocol driver
To edit the .odbc.ini file, use the vi command and insert these example statements:
[ODBC Data Sources] db2data=DB2 Source Data on isaix7 ... [db2data] Driver=/vol1/Oracle/Middleware/EPMSystem11R1/common/ODBC/Merant/6.1/lib/ARdb225.so Database=tbc_data IpAddress=isaix7 TcpPort=50000