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: Oracle MSSQL DB2 Sybase PostgreSQL
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.
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.

The following table describes MSSQL database connection parameters.

Parameter	Description
SSL	Determines whether SSL is used to encrypt the connection to a MSSQL database. You must import the SSL certificate to be able to use SSL.
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
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. This field is only relevant for MSSQL. Windows Authentication: Authenticates the user to the database through Windows. This field is only relevant for MSSQL. NTLM2 Windows Authentication: Authenticates the user to the database through NTLM2 Windows. This field is only relevant for MSSQL.
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

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 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.