JDBC Connector

Back Next

Administration of JDBC Connector

Before you use JDBC objects as sources or targets in tasks, an administrator must install and configure JDBC connections.

As a user, you can use JDBC after an administrator performs the following tasks:

Install the JDBC_IC connector for your organization.

Use the latest database driver version that your database supports. Ensure that the JDBC driver jar files for the database are installed in the same directory on all the Secure Agent machines in the runtime environment.

Update the CLASSPATH system variable to the path to the JDBC driver jar file. If the directory path is not specified during JDBC connection configuration, the Secure Agent obtains the jar file from the directory that is specified in the CLASSPATH system variable.

Using the serverless runtime environment for a JDBC connection

If you want to use the serverless runtime environment for a JDBC connection, perform the following tasks:

Create the following structure for the serverless agent configuration in AWS:

<Supplementary file location>/serverless_agent_config

Add the JDBC drivers in the Amazon S3 bucket in the following location in your AWS account:

<Supplementary file location>/serverless_agent_config/jdbc

Copy the following code snippet to a text editor:

version: 1
agent: 
  dataIntegrationServer:
    autoApply: 
      jdbc:
        drivers:
          - fileCopy:
              sourcePath: jdbc/<Driver_filename>

where the source path is the directory path of the JDBC drivers in AWS.

Ensure that the syntax and indentations are valid, and then save the file as

serverlessUserAgentConfig.yml

in the following AWS location:

<Supplementary file location>/serverless_agent_config

When the .yml file runs, the JDBC drivers are copied from the AWS location to the serverless agent directory.

In the JDBC connection properties, specify the following directory of the serverless runtime environment in the

JDBC Jar Directory

field:

/home/cldagnt/SystemAgent/serverless/configurations/jdbc

Introduction to JDBC Connector

Download Guide