Tuesday, February 24, 2015

How to Read MS Access or Excel Files from Informatica PowerCenter


Using Informatica Power Center we can read MS Access or MS Excel files directly and below are the options to read from UNIX environment.

1. Informatica Power Channel - Separate License is required for setup

2. SequeLink -

Using SequeLink, you can use the data source residing on a Windows machine from PowerCenter that runs on a Linux/ UNIX. E.g. Accessing the Excel or MS Access database residing on a Windows box from a PowerCenter running on a Linux / UNIX Machine

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.

3. B2B: B2B DT in PowerCenter, and parse the file

References: