Databases Connection Profile Parameters

The following table describes Control-M for Databases connection profile parameters.

Parameter

Description

Database Type

Determines one of the following database types to use in the connection profile:

Database Version

Determines the version of the database.

Maximum Concurrent Connections

Determines the maximum number of connections between 1–512 that the database can process at the same time

Number of connection retries

Determines the number of connection attempts between 1–24 after a connection failure

Connection retry time out

Determines the time in seconds (1–300) between each connection attempt

Connection idle time

Determines one of the following:

  • Disconnect after: Determines the number of seconds that the database connection profile remains idle before disconnecting
  • Disconnect immediately if no pending request: Defines the database connection profile to disconnect when idle.

Oracle Database Connection Parameters

The following table describes Oracle database connection parameters.

Parameter

Description

Connection Type

Determines one of the following options as your connection type:

  • Service Name: Enables you to connect to an Oracle Database with a single service name. To connect to Oracle RAC, you can define the SCAN name in the Host/SCAN Name field to connect all hosts of the RAC to a single address

  • SID: Enables you to connect to an Oracle Database by the SID identifier.

  • Connection String: Enables you to enter a connection string containing text which exists in your tnsname.ora file that can include multiple host addresses and special attributes.

    If your Oracle database is configured with SSL, you must use the Connection String option and verify the connection string contains PROTOCOL=tcps.

    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=<DB hostname>)(PORT=<Port>))(CONNECT_DATA=(SERVICE_NAME=<Service Name>)))

Host/SCAN name

 Defines the name that connects all hosts of a Oracle RAC to a single address.

Port Number

Defines the port number of the web services server.

Default: 1521

User Name

Define the user name of the specified database.

Password

Defines the password of the specified database.

MSSQL Database Connection Parameters

The following table describes MSSQL database connection parameters.

Parameter

Description

SSL

Determines whether SSL is used to encrypt the connection to a MSSQL database.

The SSL option works differently depending on the driver you are using, as follows:

  • JTDS: If the SSL option is not selected, the connection is insecure. If the option is selected, the connection is secure as long as you have imported the SSL certificate.

  • JDBC: The connection is only secure if the database server is configured with SSL. If the SSL option is not selected, the client receives the certificate during configuration and the connection is secure. If the SSL option is selected, Control-M for Databases does not receive the certificate during the configuration and instead receives the certificate from the local trust store.

Host Name

Defines the hostname of the specified database.

Use Port

Defines the port number of the database..

Port Number

Defines the port number of the web services server.

Default: 1433

Use JDBC

Determines whether to use JDBC or JTDS for Control-M for Databases.

JDBC supports the following:

  • MSSQL 2022 and higher

  • TLS1.2 and TLS1.3 encryption

  • Windows Authentication from Windows and Linux hosts

You must stop and start the Agent after you save your changes to an existing connection profile.

Additional Parameters

Defines the JDBC driver additional parameters, such as TLS1.x encryption and Always On.

applicationIntent=ReadWrite;multiSubnetFailover=True;

  • applicationIntent is set to ReadWrite to indicate that the connection is intended for read-write access.

  • multiSubnetFailover is set to True to enable AlwaysOn functionality.

  • Each key and value are separated with the equal character (=).

  • Each property is separated by a semicolon (;).

For a full list of Microsoft SQL Server database connection properties are available in the official Microsoft SQL Server documentation.

You must stop and start the Agent after you save your changes to an existing connection profile.

Database Name

Defines the name of the specified database.

Authentication

Determines one of the following options as your authentication type:

  • SQL Server Authentication: Authenticates the user to the database through an SQL server.
  • Windows Authentication: Authenticates the user to the database through Windows.
  • NTLM2 Windows Authentication: Authenticates the user to the database through NTLM2 Windows.

User Name

Define the user name of the specified database.

Password

Defines the password of the specified database.

Skip SSIS Package validation

 Skips validation of all SSIS packages when testing a connection profile

Package password definition

 Determines the Package Source, Package Name, and Package Password

DB2, Sybase, SAP ASE, and PostgreSQL Database Connection Parameters

The following table describes DB2, Sybase, and PostgreSQL database connection parameters.

Parameter

Description

Host Name

Defines the hostname of the specified database.

Port Number

Defines the port number of the web services server.

Default: 

  • DB2: 50000

  • Sybase: 4100

  • SAP ASE: 5000

  • PostgreSQL: 5432

Database Name

Defines the name of the specified database.

User Name

Define the user name of the specified database.

Password

Defines the password of the specified database.