Informatica Source Qualifier not working from Windows ODBC data source (system DSN) from Excel xlsx file

excelimportinformaticaodbc

Reference:

https://community.informatica.com/message/62128

Windows ODBC Workflow:

Windows > Control Panel > Administrative Tools > Data Sources (ODBC) > click "System DSN" menu > click "Add" > choose "Microsoft Excel Driver (*.xlsx) >

Data Source Name: "aaaaaaaaa"

Version: Excel 12.0

click "Select Workbook" button > choose xlsx file

Informatica PowerCenter Designer Workflow:

Sources > Import from Database >

ODBC Data Source: "aaaaaaaaa"

click "Connect" button > the button's name changes to "Re-Connect"

Error:

.. it doesn't seem to find the data in the worksheet … I have 3 columns with 10 rows of data

"Nothing has been selected to import" error message

Best Answer

To use an Excel file as a source you need to define a named range containing the cells with data (that's Step 1 of the instruction you referenced in the question).

All the named ranges found in the file will be shown in the Select tables pane. After you select a table (i.e. a range) and click OK, a new source will be created.

You can also consider converting the Excel spreadsheet to the CSV format and using simple flat files as a source. If you're in a Windows environment and have have Excel installed, there's a VBS script that can help you automate this process.

Related Question