Introduction | Information Center

Understanding the Data Sources page


The Data Sources page is where an administrator manages each data source definition used by an application. As an administrator, you can create data source definitions, edit existing definitions, and delete definitions. The Data Sources page allows you to:

You can define two types of data sources, multidimensional and relational. IBM Alphablox uses data adapters to connect to multidimensional data sources and drivers to connect to relational data sources.

For help on creating a IBM Alphablox data source definition for your database, click the link corresponding to your database type below.

Supported multidimensional data sources

Click on the following links to see data definition configuration information for the following supported multidimensional databases:

Note: In addition, IBM Alphablox supplies a Canned Data Adapter for developing multidimensional application prototypes. However, because its data is randomly generated, the values may not be appropriate for testing application logic.

Supported relational data sources

IBM Alphablox includes support for the following databases: IBM DB2, Informix, Cloudscape, Apache Derby, Oracle, Microsoft SQL Server, and Sybase. See the Installation Guide for details about specific database requirements. Database definition adapters allow you to quickly configure these databases. If you are using an IBM WebSphere or BEA WebLogic application server, the recommended method for connecting to relational databases is to use the Application Server Data Source adapter.

The Application Server Data Source adapter is the preferred method for connecting to relational data sources when using WebSphere or WebLogic. This adapter also lets you use RDB connection pooling for relational data sources. Once you select this adapter, enter the JNDI name of the data source defined in the application server in the Application Server Data Source Name text field.

Understanding filtering

The filter text box allows you to type in an partial or complete data source names in order to search through and find particular data sources. The filter is useful if you have many data source names in your list.


Related topics: