Workload Automation integration with snowflake

Products

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

Issue/Introduction

Configure Workload Automation to integrate with snowflake.

 

Environment

Release : 12.x

Component : CA Workload Automation Database Agent

Resolution

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.