Introduction | Information Center

Defining, editing, and deleting OLEDB for OLAP 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 OLEDB for OLAP Adapter. The OLEDB for OLAP Adapter can only be used on instances of IBM Alphablox that are running on Windows systems.

To define a data source:

  1. Click the Create button.
  2. In the Data Source field, 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 name 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 OLEDB for OLAP Adapter from the Adapter drop list. The screen refreshes to display the relevant fields for your data source.
  5. Provide the requested information. For more information, see: If necessary, ask your database administrator for this information.
  6. Click the Save button.

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 OLAP Server

Enter the TCP/IP address or name of the host machine on which the data source resides.

Specifying the Database (Catalog)

Microsoft Analysis Services: Enter the name of the Microsoft Analysis Services cube that is being defined in IBM Alphablox.

Specifying the Provider

Microsoft Analysis Services: Enter (or verify) the name of the database supplier. For Microsoft Analysis Services, the value is MSOLAP.

Specifying the Schema

Microsoft Analysis Services: Enter the name of the Microsoft Analysis Services schema that the IBM Alphablox application uses.

Specifying the Default User Name

Microsoft Analysis Services: Enter the default user name with which to access the Microsoft Analysis Services database. The name of the user must be the name of the Windows user in which IBM Alphablox is running, and that Windows user must have the "Act as part of the operating system" user right. For details on configuring this user right, see "Setting Up Microsoft Authentication for Analysis Services Data Sources" in the Administrator's Guide.

Specifying the Default Password

Microsoft Analysis Services: Enter the default password for the user entered in the Default User Name text box.

Specifying the Maximum Rows

Enter the maximum rows allowed to return from the query in the Maximum Rows text box.

Specifying the Maximum Columns

Enter the maximum columns allowed to return from the query in the Maximum Columns text box.

Specifying the Maximum Drillthrough Rows

Applies to Microsoft Analysis Services only : Enter the maximum rows to return when a drillthrough operation is performed in the Maximum Drillthrough Rows text box.

Related topics: