Orchestration Components

Zoho CRM Query Component

Zoho CRM Query This component retrieves data on a Zoho CRM server and loads it into a table. This stages the data, so the table is reloaded each time. You may then use transformations...

Apache Hive Query Component

Apache Hive Query This component retrieves data on a Apache Hive data warehouse and loads it into a table. This stages the data, so the table is reloaded each time. You may then use...

Apache Spark SQL Query Component

Apache Spark SQL Query This component retrieves data on a Apache Spark server and loads it into a table. This stages the data, so the table is reloaded each time. You may then use...

Survey Monkey Query

SurveyMonkey Query This component retrieves data on a SurveyMonkey server and loads it into a table. This stages the data, so the table is reloaded each time. You may then use transformations...

Data Transfer Component

Data Transfer Transfer a file from a chosen source to a chosen target. This component can use a number of common network protocols to transfer data up to a variety of sources....

Azure Blob Storage Load

Azure Blob Storage Load Note: This feature is only available for instances hosted on Azure. Load data into an existing table from objects stored in Azure Blob Storage. Properties Property Setting Description...

Salesforce Incremental Load

This article is part of the series on Incremental Load Tools and Shared Jobs Overview The Salesforce Incremental Load is a tool designed to allow users to easily configure a pre-existing (read-only)...

Dynamics 365 Business Central Query

Dynamics 365 Business Central Query This component retrieves data from a Dynamics 365 Business Central database and loads it into a table. This stages the data, so the table is reloaded each...

Azure Cosmos DB Query Component

Azure Cosmos DB Query This component integrates with the Azure Cosmos DB Data API to retrieve data and load it into a table. Doing this "stages" the data, so the table is...

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. This component's driver currently supports: Windows SharePoint...