Business Integration Data Sources

Use the Business Integration Data Sources page to review and edit the configured business integration data sources within your system.

To view this administrative console page, click Resources > JDBC > Business Integration Data Sources.

Required security role for this task: When security and role-based authorization are enabled, you must be logged in as an administrator or a configurator to perform this task.
The Business Integration Data Sources page lists the configured data sources needed by business integration applications in your system. For example, the page lists data sources for the following components: You have the choice to edit the data source details in the Data Source configuration page or the text fields in the business integration data source table. These edits are saved when you click OK. Apply saves everything in the table. Reset, Test Connection, and Edit provider work only on rows you select.

If the edits conflict with another data source, a warning message shows. You can still save the information, but the warning message will persist until the conflict is resolved.

Click the following buttons to perform the actions described:

Data source link
Opens the data source configuration page.
Reset
Resets the data source parameters of the selected rows to their currently configured values.
Test Connection
Tests if the configuration of the data source provided on each selected row can access the database. If the data source is used by a component, the test connection also verifies if the data source is reachable from the configured scope. Depending on the type of component and the database, the test connection also determines whether the schema is configured correctly.
Edit Provider
Opens the JDBC provider configuration page where you can make updates.

The table lists the key parameters for the data source configuration:

Select
Select the check box in this column to select the row that contains a data source. Table actions such as Reset or Test Connection occur only on selected rows unless otherwise stated. The select column does not show if there is only one row in the table.
Component
Shows the component name that needs the configured data source.
Data Source
Click the data source link to open the data source detail page.
JNDI Name
Identifies the data source's JNDI name.
Scope
Identifies if the scope for a data source is at cell, cluster, or server level. The server scope is fully qualified with its node name. For example, NodeA/TestServer is a fully qualified server scope.

Links marked (online) require access to the Internet. Each link launches a search for the topic in the online information center. When search results are listed, select the topic that corresponds best to your configuration.

Check for updates to this topic (online)

Database name

Identifies the name of the database.

Property Value
Data type String
Default
For iSeries:
  • DB2 i5/OS Native Driver: LOCAL
  • DB2 i5/OS Toolbox Driver: SYSBAS.
For all other platforms:
  • common database: WPRCSDB

Schema

Identifies the schema name of a database. The schema name is dependent on the database provider and on the component that uses the data source. For components and database providers that have dynamic schema support, a unique schema will be generated during configuration.

For DB2 on iSeries and z/OS:
  • All components support dynamic schemas. Edit the schema so that the tables needed by the components are uniquely identified by its schema.
For all other database provider types that have dynamic schema support:
  • Messaging engines for Service Integration Buses supports dynamic schemas. The schema name is saved in the messaging engine's message store configuration.
  • (WebSphere Process Server only) Business Process Choreographer container supports dynamic schemas. The schema name is stored in the Business Process Choreographer configuration.
  • (WebSphere Process Server only) Business Process Choreographer event collector supports dynamic schemas. The schema name is stored in the business process event collector's application deployment descriptors.
  • Common Event Infrastructure event database does not support dynamic schemas. The field is unavailable.
Property Value
Data type String
Default Component and database dependent
Create Tables
Select this check box to allow the component to create the tables the first time it accesses the data source. If your site policy restricts table creation to a database administrator, deselect the check box, and click on the data source link to locate the database script locations.
The Common Event Infrastructure (CEI) component creates the tables when you configure the CEI server. Once you configure the CEI component, the create table flag is unavailable and you cannot configure the table again.
Important: All tables must be created before any component attempts to access the database.

User name

Identifies a user name that can authenticate with the database. Ensure that the user has been granted all access rights for the intended operations. If you need the user to create schemas and tables, ensure that the user has the appropriate authorizations needed to create these schemas and tables.

Property Value
Data type String
Default None

Password

Identifies the user's password used to authenticate with the database.

Property Value
Data type String
Default None

Server

Identifies the database's server.

Property Value
Data type String
Default None
Provider
Identifies the database vendor or file store. If a component has not been configured, a drop down list allows the user to choose a database vendor. The file store option is only available when installing a stand-alone server. Once you configure the component, you cannot edit the provider field.
Description
Provides a description of the business integration data source.