Orchestration Components

LDAP Query Component

LDAP Query This component connects to an LDAP server to retrieve data and load it into a table. This stages the data, so the table is reloaded each time. You may then...

MongoDB Query Component

MongoDB Query This component connects to a MongoDB server to retrieve data and load it into a table. This stages the data, so the table is reloaded each time. You may then...

Dynamics CRM Query

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

NetSuite Query Component

NetSuite Query This component uses the NetSuite 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...

Google BigQuery Component

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

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...