Introduction | Information Center
You can create, edit and delete data sources. When you click the Create or Edit buttons the following text boxes and drop lists appear:
The name by which the data source is known to IBM Alphablox, and appears in the list on the Data Sources page. Application assemblers use the Data Source Name as the value of the data source parameter on an application's DataBlox (see the DataBlox Reference section in the Developer's Reference for more information). 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.
The description that explains the content or purpose of the data source.
For example, for a data source named Finance1, the description might be
Financial Budgeting Data. The description appears on the console when using
the show
command. A description is not required when creating
a data source definition.
The adapter (or driver) that IBM Alphablox uses to connect to the data source. Each adapter can connect to one data source. Supported adapters and drivers are listed in the drop list.
If you are running WebSphere or WebLogic, you will also see an adapter
called Application Server Data Source. This adapter allows
you to use RDB connection pooling for relational data sources.
Note: In addition, IBM Alphablox supplies a sample 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.
The IP name or address of the host machine on which the data source resides.
If you are running teh WebSphere or WebLogic application server and you select Application Server Data Source as your data adapter, a text box for Application Server Data Source Name appears in place of the Host Name/Server Name. The value of this field should be the JNDI name of the data source defined in the application server.
The Port Number applies to relational databases only. You might need to ask your database administrator for this information.
The name of the catalog of the database that is being defined in IBM Alphablox. For example, Essbase provides a sample catalog named Demo.
The name of the database schema that the IBM Alphablox application uses. For example, Essbase provides a sample schema named Basic.
The user name for obtaining access to the data source. If this value is left blank, application users must obtain database access under their own user names.
The password for obtaining access the data source. If this value is left blank, application users must provide a value password before they can obtain database access.
This specifies whether to use the IBM Alphablox user name and password as the user name and password for database access. If this property is set to Yes, the user name and password used to log into IBM Alphablox will be used to log into the database. For more information, see Administration Security and Authentication in the Administrator's Guide in the IBM Alphablox I nformation Center.
Sets the maximum number of rows to be returned for each query. This value acts as a query governor, ensuring that result sets are a manageable size.
Warning: Do not set this value to less than 20. The default of 1000 should be sufficient for most applications. If a query would normally return many more rows, the browser displays a message to the user.
Set the maximum number of columns to be returned for each query. This value acts as a query governor, ensuring that result sets are a manageable size.
Warning: Do not set this value to less than 20. The default of 1000 should be sufficient for most applications. If a query would normally return many more columns, the browser displays a message to the user.
Available only for Microsoft Analysis Services data sources. This value acts as a query governor, ensuring that result sets returned from the query are a manageable size.