JDBC Database Server Target

JDBC Database Server Target

Java Database Connectivity (JDBC) is an API for connecting to remote databases. JDBC provides connectivity to a wide range of databases.

JDBC Database Server targets require JDBC Login Credentials account keys and are used with Database workflow activities.

Perform the following steps to create the target:

1. In the left navigation menu, click Automation > Targets.
2. Click New Target.
3. From the Target Type drop-down list, choose JDBC Database Server.
4. Enter a unique display name for the target in the Display Name field and a brief description in the Description field.
5. In the Account Keys area, choose an existing account key or choose Add New to add a new account key from the Default Account Keys drop-down list. For more information, see the JDBC Login Credentials Help topic.
6. In the Database area, specify the following information:
   • Database Server Type - Choose the database server type from drop-down list.
   • Hostname / IP Address - Enter the hostname or the IP address of the database server.
   • Port - Enter the port number used to access the SQL database.
   • Database Name - Enter the name of the database.
7. Click Save to add and save the target.