Introduction | Information Center

Defining, editing, and deleting IBM Cubing Services data source definitions


Use the Data Sources page to define a new (or to edit an existing) data source that Alphablox applications can access. This page describes the entries for defining a data source connecting through the IBM Cubing Services Adapter. The IBM Cubing Services Adapter can be used to connect Alphablox applications to an IBM Cubing Services server that is available in the IBM DB2 Data Warehouse Edition.

To define a data source:

  1. Click the Create button.
  2. In the Data Source Name text box, type 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, type 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 IBM Cubing Services Adapter from the Adapter drop list.
  5. In the Cubing Services Server Name, type the TCP/IP address or name of the host machine on which the data source is located.
  6. In the Maximum Rows text box, type the maximum number of rows allowed in a result set from this data source. The default value is 1000.
  7. In the Maximum Columns text box, type the maximum number of columns allowed in a result set from this data source. The default value is 1000.
  8. In the Maximum DrillThrough Rows text box, type the maximum number of columns you want to be returned from the underlying relational data for the cube. The default value is 1000.

Related topics: