Orchestration Components

CloudWatch Publish Component

Cloudwatch Publish Component Note: This feature is only available for instances hosted on AWS. Publish metrics to Cloudwatch. Within the AWS console, you may then attach alarms to get alerts when metrics...

Bash Script Component

Bash Script Component Run a Bash script. The script is executed in an external bash process hosted by the Matillion ETL instance. Any errors encountered while running the script will immediately halt...

Google Spreadsheets Query

Google Sheets Query This component uses the Google Sheets API to retrieve data and load it into a table. This stages the data, so the table is reloaded each time. You may...

RDS Bulk Output Component

RDS Bulk Output Note: This feature is only available for instances hosted on AWS. Load the contents of a table (or view) into a table in an Amazon RDS database. Properties Property...

Marketo Query

Marketo Query This component uses the Marketo Rest API to retrieve data and load it into a table. This stages the data, so the table is reloaded each time. You may then...

Retry Component

Retry Component Repeatedly attempt to run a connected component until it succeeds or a maximum number of attempts is reached. This component is used like an Iterator component, where it is attached...

Google Adwords Query Component

Google AdWords Query This component uses the Google AdWords API to retrieve data and load it into a table. This stages the data, so the table is reloaded each time. You may...

HubSpot Query Component

HubSpot Query This component uses the HubSpot API to retrieve data and load it into a table. This stages the data, so the table is reloaded each time. You may then use...

Excel Query Component

Excel Query This component can load data stored in an Office Open XML Excel sheet into a table. This stages the data, so the table is reloaded each time. You may then...

OData Query Component

OData Query This component uses the OData API to retrieve data and load it into a table. This stages the data, so the table is reloaded each time. You may then use...