Introduction | Information Center

Defining, editing, and deleting Hyperion Essbase Deployment Services data source definitions


Use the Data Sources page to define an existing data source that IBM Alphablox applications can access. This page describes the entries for defining a data source connecting through the Essbase Enterprise Server adapter.

To define a data source:

  1. Click the Create button.
  2. In the Data Source Name text box, enter a unique data source name (required). Allowable characters are A-Z, a-z, 0-9, underscore, or special characters (for example, accented characters) when running in a language other than English. The display of the name is case sensitive but the actual username that is authenticated is case insensitive. The names Public, Private, and Properties are reserved and cannot be used for an object name.
  3. In the Description text box, enter a description. The description appears in the console when using the show command. A description is not required when creating a data source definition.
  4. Select the Essbase Enterprise Server adapter from the Adapter drop list.
  5. Provide the requested information. For more information, see: If necessary, ask your database administrator for this information.
  6. Optionally, you can enter a default username and password. If these text boxes are left blank, application users must obtain database access under their own user names and passwords.
  7. Click the Save button.

Note: The username and password specified should exist in both the Deployment Services and the OLAP/Analytic Server.

To edit a data source:

  1. Select a data source name from the Data Sources list box.
  2. Click the Edit button to delete the data source.
  3. Make your changes.
  4. Click the Save button.

To delete a data source:

  1. Select a data source name from the Data Sources list box.
  2. Click the Delete button to delete the data source.
    The data source information is immediately deleted and cannot be recovered.

Specifying the Deployment Services server name

Enter the TCP/IP address or name of the host machine on which the Essbase Deployment Services resides.

Specifying the Essbase server name

Enter the TCP/IP address or name of the Essbase Server where the data source resides.

Specifying the application

Enter the name of the Hyperion Essbase application or catalog of the database that is being defined to IBM Alphablox. For example, Essbase provides a sample application named Sample.

Specifying the database

Enter the name of the Hyperion Essbase database that the IBM Alphablox application uses. For example, Essbase provides a sample database named Basic.

Specifying the alias table

Enter the name of the Hyperion Essbase alias table that the data source uses. If this field is blank, the default alias table is used. The alias table is an object in the Hyperion Essbase database used to map member names in an outline to names that are displayed in user queries. There might be alias tables set up in the database for different countries or regions because the names of members might change from place to place. For example, a particular car model might be called "Milano" in the United States and called "75" in Europe.


Related topics: