Orchestration Components

Table Iterator

Table Iterator Component Loop over rows of data within a table or view and run another component for each row. This component implements a simple loop over rows of data in an...

If Component

If Component The 'If' component can evaluate an expression involving variables and direct the flow of an orchestration job depending upon whether the expression evaluates to 'true' or 'false'. The component has...

Twitter Query

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

Facebook Query

Facebook Query This component uses the Facebook 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 Analytics Query

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

API Query

API Query API Query is a generic query component to read data from JSON and XML based API's. An API is described in a "Profile" definition, which is a collection of XML...

Begin Component

Begin Component Note: This feature is only available for instances hosted on AWS. The "Begin" orchestration component starts a new transaction within Redshift. Transactions can help make multiple changes to a database...

Commit Component

Commit Component The "Commit" orchestration component ends a transaction within Redshift and makes all changes made since the latest Begin component visible to other database users. Transactions can help make multiple changes...

Rollback Component

Rollback Component The "Rollback" orchestration component ends a transaction within Redshift and undoes any changes made since the latest Begin component - changes are never visible to other database users. Transactions can...

Salesforce Query

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