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.

Creating JDBC Database Server Targets

Perform the following steps to create the target:

1. In the left navigation menu, click 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 Submit to add and save the target.