MS OLEDB stage

Use the MS OLEDB stage to retrieve information from any type of information repository, such as a relational source, an ISAM file, a personal database, or a spreadsheet. This stage uses the OLE DB SDK that is part of Microsoft Data Access SDK (MDAC).

This topic describes the following for the MS OLEDB stage:

• "Functionality of MS OLEDB Stages"
• "Defining the MS OLEDB Stage"
• "Connecting to an OLE DB Data Source"
• "Creating and Populating Cubes"
• "Defining Character Set Mapping"
• "Defining an Input Link"
• "Defining an Output Link"
• "OLE DB Server Data Type Support"
• "Stored Procedure Support"
• "CREATE CUBE Statement"
• "INSERT INTO Statement"