ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

CA WA integration with snowflake

book

Article ID: 221340

calendar_today

Updated On:

Products

CA Workload Automation DE - Business Agents (dSeries) CA Workload Automation AE - Business Agents (AutoSys) Workload Automation Agent

Issue/Introduction

How to configure Workload Automation to integrate with snowflake.

 

Environment

Release : 12.0

Component : CA Workload Automation Database Agent

Resolution

You can use Workload Automation Agent for Databases (plugin) to integrate with snowflake.

Steps:

1. Install Agent for Databases (Plugin)

2. Copy the JDBC driver(s) for snowflake to the '<agent_install_dir>/jars/ext' directory.

3. Specify the Database URL, user ID and password in the agent's agentparm.txt file.

4. Add JDBC driver class for snowflake in jdbc.drivers property in the agentparm.txt file.

For example;

jdbc.drivers=oracle.jdbc.OracleDriver:net.sourceforge.jtds.jdbc.Driver:net.snowflake.client.jdbc.SnowflakeDriver

5. Restart the agent.

Notes:
- Encrypt the password using the password utility shipped with the agent.
- Refer to the snowflake documentation on the JDBC Driver connection string for snowflake.