Use the Connection Wizard to create connections to many types of data sources, including relational and text. When you use the Connection Wizard, you accomplish several tasks:
Define the connection parameters for a data source.
Optionally, select which source tables or files to include in the connection.
Select whether to create a minischema for this data source.
See Selecting a Minischema Option.
If you choose to create a minischema, you will also populate it.
Create metadata elements from the data source elements.
These procedures provide the basis for creating customized metadata elements, such as dimension elements, and hierarchies, which you can use to create cube schemas and Essbase models, and perform cube deployments.
Note: | After defining the data source parameters in the first page of the Connection Wizard, completing the remaining wizard pages is optional. |