Creating or Editing a Database Activity Endpoint
Endpoints provide the database connection information that Studio and the Integration Appliance use to connect to a database.
Select or edit a database endpoint
- In the Create Endpoint or Edit Endpoint pane, configure the fields
as described in the following tables. Note: Changing the configuration properties of an endpoint affects all orchestrations that use that endpoint in the project. The edits are global, not local.
- Click Test Connection to confirm that you can connect to the database. Click OK.
Database options
Field | Description |
---|---|
Database Type | Specifies the database type. If you select the
Generic JDBC driver or MySQL, you must install the module providers
into Studio. To add JDBC drivers into Studio, you add them to the
Web Management console and then complete the following steps in the
WMC.
Note: For JDBC drivers to access database endpoints for Cast Iron® Generic JDBC support,
the JDBC driver must be:
For more
information about installing the JDBC libraries into the WMC, see
the WMC Online help.
|
Database Name | Specifies the name of the Database to which
you want to connect. If connecting to Oracle RAC, see For Oracle RAC:. Note: For AS/400 DB2® databases, this is the collection name defined
during installation.
|
Network Location: Server | Specifies the name or IP address of the machine where the database server resides. For Informix®, log into the Informix Server Administrator and select the | menu option to find the hostname. For Sequelink, enter the name or the IP address of the Sequelink server.
Network Location: Port | Specifies the port number of the database server listener. For Sequelink, enter the port number of the Sequelink server listener. |
User Name | Specifies the username that the Integration
Appliance uses to connect to the database. Note: For DB2, the user must have the permissions to create
a package.
|
Password | Specifies the password associated with the specified username. |
Additional Parameters | Specifies the database-specific information for an endpoint. See Working with Database Parameters for details. By default, the MaxPooledStatements parameter is automatically defined and set with a default value for all types of Database Endpoints. |

For Informix Databases
To find the port number for an Informix database:- In an editor, open the following file: $INFORMIXSERVER/etc/sqlhosts
- Note the servicename found in the SERVER column.
- In an editor, open the appropriate file for your system:
- UNIX - /etc/services
- Windows - \Winnt\system32\drivers\etc\services
- In the file, search for the servicename to find the associated port number.
For DB2 AS/400 Databases
For some EBCDIC-US columns on DB2 AS/400, Studio cannot determine the correct size and type.- In Studio, open the orchestration containing a Database Connector activity.
- Change CHAR type columns to VARBINARY type. The EBCDIC-encoded columns display as CHAR type columns in the data type of the outbound connector.
- Use a map before the Database Connector to pad an EBCDIC-encoded
parameter with spaces, so that the value of the parameter equals the
length of the column.
For example, if the column length is 10 and the value is "abc", pad the column with 7 spaces.
If the EBCDIC-encoded value is not padded with spaces, the Database Connector pads the value with NULL. This can create inconsistent data and errors can occur.
- In Studio, open the orchestration containing the Database Connector
Parameterized Query operation.
When you use a parameterized query to select an EBCDIC-encoded column from a database, the Database Connector returns values padded with spaces if the value is shorter than the column length.
For example, if the column length is 10 and the value is "abc", the Database Connector pads the column with 7 spaces.
- Create a map after the Parameterized Query operation to trim the padded spaces from the XML result set.
For Oracle RAC:
IBM Cast Iron supports additional properties in the connection string that enable Oracle RAC connectivity. Use the following additional properties to connect with Oracle RAC:AlternateServers=(servername1[:port1] [;property=value[;...]], servername2[:port2] [;property=value[;...]],...)
Where:
servername is the IP address of the server
port is the port number of the server
property=value enter the ServiceName which is used as the Database Name. Entering a SID is optional.
- LoadBalancing=true|false
Determines whether the driver will use client load balancing in its attempts to connect to a list of database servers, primary and alternate. The list of alternate servers is specified by the AlternateServers property. If set to true, client load balancing is used and the driver attempts to connect to the list of database servers, primary and alternate servers, in a random order. If set to false (the default), client load balancing is not used and the driver connects to each server based on their sequential order (primary server first, then, alternate servers in the order they are specified).
- Use the service name in the Database Name of the end-point.
Connection Pool, Encoding, TimeOut, and Security Options
Default values are provided for the connection pool options. Change them as needed.Field | Description |
---|---|
Connection Pool Options | |
Initial Pool Size | Specifies the initial number of database connections that the Integration Appliance opens and places in the connection pool. |
Minimum Connections | Specifies the number of database connections that the Integration Appliance always keeps open in the connection pool. Specifying 0 is supported. |
Maximum Connections | Specifies the maximum number of database connections that the Integration Appliance can have open in the connection pool. Specifying 0 means the number of connections is unbounded. |
Maximum Idle Time | Specifies the amount of time (in minutes) that a database connection can be open and idle before being closed by the Integration Appliance. Specifying 0 means that the connections are closed when they are returned to the pool - no idle time. |
Reclaim Connections | Specifies how often the Integration Appliance
checks the connection pool to determine if any connections should
be closed. For example, if the Reclaim Connections is
set to 6 minutes, the Integration Appliance checks the connection
pool every six minutes to determine if the total number of open connections
in the pool are greater than the minimum number of connections. If
the number of open connections are greater than the specified minimum
number, the Integration Appliance closes any excess connections (over
the number of Minimum Connections) for any connections
that have exceeded the Maximum Idle Time. For example, the Minimum Connections is set to 2, Maximum Connections is set to 6, the Reclaim Connections is 6 minutes, and the Maximum Idle Time set to 2 minutes. A total of five connections are currently open in the connection pool. When the Reclaim Connections of 6 minutes is reached, the Integration Appliance checks the connection pool and determines that one connection has been idle for 3 minutes, one connection has been idle for 4 minutes, and three connections are still active. The Integration Appliance closes the two idle connections. After another 6 minutes, the Integration Appliance checks the connection pool again. |
Default Encoding | |
Encoding | Specifies the default character Encoding to
use when connection to this database. To set the encoding type, choose
from one of the following options:
Note: Some double-byte characters are not converted using the
SHIFT-JIS encoding. For more information, see Using the Shift-JIS encoding.
|
Quoted Identifiers | |
Delimit the identifiers for tables, columns, and objects with quotes | Specifies if quotes are used around the identifiers for database tables, columns, and objects in the generated SQL statements that the Integration Appliance and Studio uses to communicate with the database. Quoting an identifier makes the identifier case-sensitive. For example, the identifier string: myTable could refer to table named mytable or MYTABLE but the identifier string with quotes: "myTable" only refers to a table named myTable. Quoting an identifier also allows characters not normally found in database names such as spaces. |
Security | |
Enable Encryption | Specifies that the connection should use SSL. |
Validate Server Certificate | Specifies that the client should validate the database server certificate. See Testing an SSL Database Connection. |
Require Client Authentication | Specifies that the client present a certificate to the database server. |
Connection Timeout | |
Time out after ___ second(s) when establishing a connection to the Endpoint. | Specifies the amount of time in seconds before
a timeout occurs between the Integration Appliance attempting to establish
a connection to the Endpoint and the time it takes for the Endpoint
to respond to the connection request. For a database activity, the
amount of time the Integration Appliance attempts to establish a connection
to the database before timing out. A connection timeout is different
from an activity timeout because an activity timeout occurs after
the connection to the Endpoint has already been established. An activity
timeout specifies the amount of time in seconds before a timeout occurs
between the activity invoking a request on an Endpoint and the time
it takes the Endpoint to respond. You set the activity timeout in Retry task
of any of the following database activities:
|