Control-M for Databases connection profile parameters

The following table lists the database connection profile parameters that you can define, as described in Creating a connection profile.

Field

Description

use 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, as described in Importing an SSL certificate.

Host Name

Defines the hostname of the specified database.

Port Number

Defines the port number of the Database web services server.

use Port

Defines the port number of the database. This option is disabled by default (MSSQL only).

Database Name

Defines the name of the specified database.

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

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.

This field is only relevant for Oracle.

User Name

Define the user name of the specified database.

Password

Defines the password of the specified database.

Confirm Password

Confirms the password of the specified database.

Parent Topic

Connection profile management