Using SequeLink to Access Data

Using SequeLink to Access Data

Configuring odbc.ini

Configuring odbc.ini

PowerCenter uses odbc.ini to connect to the SequeLink data source.
To configure odbc.ini, you need the following information:
  • Data source name.
    The data source name that you provided when configuring the connect string for the ODBC connection object in the Workflow Manager.
  • Driver location.
    The driver is located in the lib folder of the SequeLink client installation location. The driver name is dwslk22.xx or ivslk22.xx. The file name extension can be different for each platform.
  • Host name and SequeLink Server port number.
    Host and port information is available on the Sequelink Socket Server Services folder in the General area of the Service Settings.
  • SequeLink server data source name.
    Optional. The name of the SequeLink server data source.
To update odbc.ini, create an entry for the date source under the ODBC Data Sources section and also create an entry for the date source that specifies the connection information.
For example, if the Data Source name is Test and you created a SequeLink data source setting named Access1, create an entry under the ODBC Data Sources section and also create an entry that includes the driver, description, port, host, and server data source name.
[ODBC Data Sources] Test = DataDirect SequeLink 6.0 [Test] Driver= <Informatica installed directory>/tools/Sequelink/lib64/DWslk22.so Description=DataDirect SequeLink 6.0 Host=<machine name that runs the SequeLink Service> Port=<port number of the SequeLink Server> UseLDAP=0 ServerDataSource=Access1
The ServerDataSource is an optional field. If you do not specify the SequeLink server data source name in the ServerDataSource field, the SequeLink Service uses the default SequeLink data source. Configure ServerDataSource when you have multiple SequeLink data sources.