CA WA integration with snowflake

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.