Using SequeLink to Access Data

Using SequeLink to Access Data

Overview

Overview

PowerExchange provides access to most popular types of enterprise data sources and targets. If you need PowerCenter sessions to access data on sources or targets for which PowerExchange does not provide access, you might be able to use the DataDirect SequeLink Client and Server with the SequeLink ODBC drivers for data access.
SequeLink provides ODBC drivers for databases such as Microsoft Access, FileMaker, Progress, FoxPro, and dBase. For a list databases that SequeLink supports, see the DataDirect SequeLink Support Matrix.
Informatica does not support ODBC as a substitute for PowerExchange. PowerExchange provides better performance and has unique capabilities, such as change data capture (CDC) and pushdown optimization, that the ODBC drivers cannot exploit. Also, Informatica might not be able to certify all ODBC drivers prior to each release. For more information, see the support statement about ODBC drivers with Informatica products, which is available from the Informatica Network.
PowerCenter customers can download and use the SequeLink Client and SequeLink Server for ODBC Socket at no cost. The SequeLink ODBC drivers that Informatica provides can only be used with PowerCenter. With SequeLink, you can use a Windows ODBC driver to access data on a Windows 32-bit machine from a Linux, UNIX, or Windows 64-bit machine that runs PowerCenter services.
To use SequeLink, install the SequeLink Client on the machine where the PowerCenter Integration Service runs and install the SequeLink Server for ODBC socket on the machine where the data is stored. The SequeLink Server for ODBC Socket includes the SequeLink Service and SequeLink Management Console Snap-in. Use the SequeLink Management Console Snap-in to manage the SequeLink Service. The SequeLink Client includes the ODBC drivers, driver manager, and odbc.ini.