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:
- Click the Create button.
- 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.
- 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.
- Select the IBM Cubing Services Adapter from the Adapter drop
list.
- In the Cubing Services Server Name, type the TCP/IP address or name of the host machine on which the data source is located.
- 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.
- 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.
- 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: