During the data source creation process, you can create metadata elements from the physical elements in your data source. The metadata elements generally represent the tables and columns in your data source and are the basis to later create other metadata elements such as customized dimension elements and hierarchies.
See the following topics for information on creating metadata elements for a particular data types:
Relational data sources—Includes relational sources such as Oracle, IBM DB2, Microsoft SQL Server, MySQL, Netezza, Oracle BI EE (Presentation Layer only), and Teradata. See Creating Metadata Elements for Relational Sources.
For Oracle BI EE (Business Model only), see Creating Oracle BI EE Dimensions.
Dimension Server sources—Includes Performance Management Architect sources. See Creating Metadata Elements for Performance Management Architect Sources.
Flat or text file data sources—See Creating Metadata Elements from Text File Sources.
Note: | This activity is not applicable to Essbase data sources. |
After you create a connection, the connection information is always present in Essbase Studio; you need not reconnect to the data source on subsequent logins to the Essbase Studio Server and Console.