|
How to configure ODBC Connection for EXCEL
1. Create a worksheet.
1.1 Select the required rows to be read into PowerCenter.
1.2 Choose Insert | Name | Define and give the range a name then click OK.
1.3 Save the worksheet.
2. Create the ODBC connection.
2.1 System DSN | Microsoft Excel Driver (*.xls).
2.2 Configure and select workbook.
3. Import into Designer.
3.1 Sources | Import From Database.
3.2 ODBC data source must match (2.) above.
3.3 Leave username, password and ownername blank.
3.6 Click Connect
3.7 Expand the worksheet name and select the range created in (1.) above.
4. Create ODBC connection in Workflow Manager
4.1 In Workflow Manager go to Connections | Relational | New... | ODBC
4.2 Enter a name for the connection.
4.3 Username=pmnulluser
4.4 Password=pmnullpasswd
4.5 Connect string=
4.6 Use this connection in session mapping for source.
5. Please note that sheet names with spaces can be problematic.
source from INFORMATICA community
|
