Using SequeLink to Access Data

Using SequeLink to Access Data

How SequeLink Communicates with PowerCenter

How SequeLink Communicates with PowerCenter

The following figure provides an overview of how SequeLink communicates with PowerCenter:
In the example above, PowerCenter uses SequeLink software to read data from a Microsoft Access database. The SequeLink Client components on the UNIX machine connect to the SequeLink Server on the Windows machine to access the Microsoft Access database.
The data source names provide connectivity to the data that you want to access. You specify data source names when you configure the connection object, SequeLink server data source, odbc.ini, and the System DSN.
The following figure shows the relationship between the data source names:
You configure a data source name in the following places:
  • System DSN in the ODBC Data Source Administrator
    . When you create an ODBC data source, you specify an ODBC data source name. You specify this name in the DataSourceSOCODBCConnStr attribute of the SequeLink server data source. In the figure above, the data source name is CustData.
  • Data source in the SequeLink Management Console Snap-in
    . When you configure a SequeLink server data source, the DataSourceSOCODBCConnStr must contain the string with DSN=<data source name>. The DSN value must match the data source name of the System DSN. In the figure above, the SequeLink server data source is Access1 and the DataSourceSOCODBCConnStr attribute contains the string DSN=CustData.
  • ODBC data source in odbc.ini
    . When you configure odbc.ini, you specify a name for the ODBC Data Source. The data source name must match the connect string you provided in the connection object. If you have multiple SequeLink server data sources, the ServerDataSource value in odbc.ini must match the SequeLink server data source name in the SequeLink Management Console Snap-in. In the figure above, the ODBC Data Source is Test and the ServerDataSource is Access1.
  • Connect string in the connection object
    . When you create the ODBC Connection object in the Workflow Manager, you specify a connect string. The connect string should contain the ODBC data source name that you configure in odbc.ini. In the figure above, the connect string is Test.