How to set the dependency for Matillion Job with External ETL job running from Autosys

Matillion ETL
1

We are currently in process of setting up incremental Data loads from Oracle DB (On-prem) to Snowflake using Matillion Jobs. All the Oracle tables will be refreshed on daily basis using IBM DataStage ETL tool and these DataStage jobs are scheduled to run on Autosys.

 

Requirement is : Run the Matillion Job once the Oracle table refresh is completed .

How do we set up the Dependency between the IBM DataStage job which is running on Autosys with Matillion Incremental Load Job which is running on Cloud.

2

Hi DK129642,

 

You could have the DataStage job launch the Matillion job once the Oracle table refresh is completed?

 

If you can make the DataStage job run a Bash script, you can launch a Matillion job asynchronously using curl:

 

curl -X POST -u user:password http://<InstanceAddress>/rest/v1/group/name/<GroupName>/project/name/<ProjectName>/version/name/<VersionName>/job/name/<JobName>/run?environmentName=<EnvironmentName>

 

BR