Table of Contents


  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Datatype Reference
  17. Configure the Web Browser

Importing a Microsoft Excel Source Definition

Importing a Microsoft Excel Source Definition

PowerCenter treats a Microsoft Excel source as a relational database, not a flat file. Like relational sources, the Designer uses ODBC to import a Microsoft Excel source. You do not need database permissions to import Microsoft Excel sources.
Complete the following tasks before you import an Excel source definition:
  1. Install the Microsoft Excel ODBC driver on the system.
  2. Create a Microsoft Excel ODBC data source for each source file in the ODBC Data Source Administrator.
  3. Prepare Microsoft Excel spreadsheets by defining ranges and formatting columns of numeric data.

Updated July 02, 2020