Orchestration Components

SharePoint Query

SharePoint Query The SharePoint Query component integrates with the SharePoint Data API to retrieve data from Microsoft SharePoint and load that data into a table. Warning: This component is potentially destructive. If...

Azure Blob Storage Unload

Azure Blob Storage Unload Component Creates files on a specified Azure Blob Storage account and loads them with data from a table or view. By default, your data will be unloaded in...

Twilio Query

Overview This component uses the Twilio API to retrieve data and load it into a table. Warning: This component is potentially destructive. If the target table undergoes a change in structure, it...

Azure SQL Query

Azure SQL Query Run an SQL Query on an Azure SQL Database and copy the result to a table, via Azure Blob Storage. This component is for data-staging - getting data into...

DoubleClick For Publishers Query

DoubleClick for Publishers Query This component retrieves data from the DoubleClick API and loads that data into a table. Doing this stages the data, so that the table is reloaded each time....

Azure Queue Storage Message Component

Azure Queue Storage Message Component Note: This feature is only available for instances hosted on Azure. Post a message to an Azure Queue Storage. Other applications (including Matillion ETL instances) can read...

JDBC Table Metadata To Grid

JDBC Table Metadata To Grid This component takes the metadata from a JDBC table and uses this data to populate a grid variable with data. The component can take the following metadata...