Use the Data Source configuration page to edit the business integration data source properties.
To view this administrative console page, click Resources > JDBC > Business Integration Data Sources > Data Source link.
New data sources cannot be created on this page. Data sources can only be created on a component specific configuration page. The component specific configuration page sets all the required fields.
The fields shown in the Data Source configuration page depend on the type of database provider used. This page shows what a typical DB2 configuration page would look like. If you choose a different database provider, some of the fields may be different or missing particularly in the Component Specific Properties section.
Links marked (online) require access to the Internet.
Check for updates to this topic (online)
Identifies the database provider or file store. The provider or file store cannot be changed after it has been configured.
Property | Value |
---|---|
Data type | String |
Default | None |
Specifies the implementation type of XA or Connection Pool (CP). For most database providers, use XA as the implementation type needed for two-phase commits.
Property | Value |
---|---|
Data type | String |
Default | None |
Shows the scope at which the data source is configured. The scope can be cell, cluster, node or server. For example, NodeA/TestServer is a fully qualified server scope. You cannot edit the scope once it is configured.
Property | Value |
---|---|
Data type | String |
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 all the rights needed to create schemas and tables.
Property | Value |
---|---|
Data type | String |
Identifies the user's password used to authenticate with the database.
Property | Value |
---|---|
Data type | String |
Identifies the name of the database.
Property | Value |
---|---|
Data type | String |
Identifies the schema name used to access this configured data source.
Property | Value |
---|---|
Data type | String |
Identifies the database's server.
Property | Value |
---|---|
Data type | String |
Specifies the database listener port used for all communications involving this data source.
Property | Value |
---|---|
Data type | Integer |
Specifies the driver type for the database provider. See "JDBC specifications" for more information on driver types.
Property | Value |
---|---|
Data type | Integer |
Displays the name of the component that requires the data source.
Property | Value |
---|---|
Data type | String |
Specifies the data source name used to uniquely identify a data source configuration. This name corresponds to WebSphere® Application Server JDBC data source name.
Property | Value |
---|---|
Data type | String |
Default | None |
Specifies the JNDI name used by the component to locate the data source. This field is configured by the component to ensure that the data source can be found. It is not editable.
Property | Value |
---|---|
Data type | String |
Default | None |
Provides a description of the Business Integration data source.
Property | Value |
---|---|
Data type | String |
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, clear the check box, locate the scripts in the message box and give these scripts to your database administrator to run.
Property | Value |
---|---|
Data type | Boolean |
Default | See "Table and schema creation matrices". |
Under Additional Properties are links to additional information.