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:
1Create the following structure for the serverless agent configuration in AWS or Azure: <Supplementary file location>/serverless_agent_config
2Add the JDBC drivers in the Amazon S3 bucket or Azure container in the following location in your AWS or Azure account: <Supplementary file location>/serverless_agent_config/jdbc
3Copy the following code snippet to a text editor:
where the source path is the directory path of the JDBC drivers in AWS or Azure.
4Ensure that the syntax and indentations are valid, and then save the file as serverlessUserAgentConfig.yml in the following AWS or Azure location: <Supplementary file location>/serverless_agent_config
When the .yml file runs, the JDBC drivers are copied from the AWS or Azure location to the serverless agent directory.
5In 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