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
Before You Begin
-
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.
-
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>"
-
-
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
-
-
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
-
-
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
-
To remove this plug-in from an Agent, see Removing a Plug-in. The plug-in ID is FVT032025.
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 |