Using Informatica Power Center we can read MS Access or MS
Excel files directly and below are the options to read from UNIX environment.
Excel files directly and below are the options to read from UNIX environment.
1. Informatica Power
Channel – Separate License is required for setup
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
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.
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
PowerCenter, and parse the file
References: