In Essbase Studio, you connect to various types of data sources using the Connection Wizard. Data sources can be relational databases, Oracle BI EE sources, Performance Management Architect applications, or text file data sources. The Connection Wizard enables you to define a data source for modeling and, optionally, to populate a minischema, and to create metadata elements in the catalog.
You can also use the Connection Wizard to set up connections to Essbase Server instances, which you can use later when you deploy cubes.
Setting up a data source in the Connection Wizard is the first task you perform after installing Essbase Studio. Before you begin creating metadata elements, hierarchies, cubes, and other application objects, you must define the source for their data. The first page of the Connection Wizard collects information from you about the data source (data source type, user name, password, server name, and other information), and then “scrapes” the data source to store the information about data source tables, columns and joins in the catalog. Subsequent steps in the wizard enable you to create and populate a minischema, create metadata elements in the catalog, and bind those metadata elements to the physical elements in the data source.
Once a data source connection is created, the connection is always present in Essbase Studio until you delete it; you need not reconnect to the data source upon subsequent logins to the Essbase Studio Server and Console.
Note: | When creating or editing data source connections, you are asked for a database user name and password for the data source. You must provide a user name that has at least read permission to the data sources (databases) to which you are connecting. |
To get started, see Creating Connections with Connection Wizard.