Amazon Redshift

Control-M for AWS Redshift enables you to do the following:

• Execute any of the following AWS Redshift job operations:
  • Execute an AWS Redshift-supported SQL statement.
  • Copy a queried database and schema into an existing or new file in cloud storage.
  • Copy data from an S3 bucket to a table in AWS Redshift.
  • Call an existing procedure and its arguments.
  • Manage AWS Redshift credentials in a secure connection profile.
• Connect to any AWS Redshift endpoint.
• Integrate AWS Redshift jobs with other Control-M jobs into a single scheduling environment.
• Monitor the status, results, and output of AWS Redshift jobs in the Monitoring domain.
• Attach an SLA job to your AWS Redshift jobs.
• Introduce all Control-M capabilities to Control-M for AWS Redshift including advanced scheduling criteria, complex dependencies, Resource Pools, Lock Resources, and variables.
• Run 50 AWS Redshift jobs simultaneously per Agent.

Control-M integration for AWS Redshift is available for these product versions:

• Control-M 21.300 and later
• Control-M SaaS Agent 21.300 and later

Supporting Documentation

Integrating AWS Redshift and Control-M

Control-M SaaS for AWS Redshift