Control-M for Fivetran

Fivetran is an automated data integration platform that enables data extraction, transformation, and loading (ETL) processes across various cloud platforms.

Control-M for Fivetran enables you to do the following:

• Trigger connection synchronizations and re-synchronizations, as well as data transformations

• Manage Fivetran credentials in a secure connection profile.

• Connect to the Fivetran SaaS service.

• Introduce all Control-M capabilities to Control-M for Fivetran, including advanced scheduling criteria, complex dependencies, resource pools, lock resources, and variables.

• Integrate Fivetran jobs with other Control-M jobs into a single scheduling environment.

• Monitor the status, results, and output of Fivetran jobs.

• Attach an SLA job to the Fivetran jobs.

Setting up Control-M for Fivetran

This procedure describes how to deploy the Fivetran plug-in, create a connection profile, and define a Fivetran job in Control-M SaaS and Automation API.

Before You Begin

• Verify that you have Java installed, as described in Control-M External Java Installation.

• Verify that Automation API is installed, as described in Setting Up the API.

• Verify that Agent version 9.0.21.080 or higher is installed.

Begin

1. On the Agent host, run one of the following commands to set the Java environment variable:

   • Linux:

     • Bourne shell/bash: export BMC_INST_JAVA_HOME=<java_directory>

     • csh/tcsh: setenv BMC_INST_JAVA_HOME <java_directory>

   • Windows: set BMC_INST_JAVA_HOME="<java_directory>"

2. Do one of the following:

   • Install: Run one of the following provision image commands:

     • Linux: ctm provision image Fivetran_plugin.Linux

     • Windows: ctm provision image Fivetran_plugin.Windows

   • Upgrade: Run the following command:

     ctm provision agent::update

3. Create a Fivetran connection profile in Control-M SaaS or Automation API, as follows:

   • Control-M SaaS: Create a Centralized Connection Profile with Fivetran Connection Profile Parameters

   • Automation API: ConnectionProfile:Fivetran

4. Define a Fivetran job in Control-M SaaS or Automation API, as follows:

   • Control-M SaaS: Create a Job with Fivetran Job parameters

   • Automation API: Job:Fivetran

Change Log

The following table provides details about changes that were introduced in new versions of this plug-in:

Plug-in Version	Details
1.0.00	Initial version