Orchestration Components

SFTP Put Object

SFTP Put Object Transfer a file from Amazon S3 onto a remote host through SFTP. Properties Property Setting Description Name Text The descriptive name for the component. Set Home Directory as Root...

Sugar CRM Query

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

File Iterator Component

File Iterator Component Loop over matching files in a remote file system. This component searches for files in a number of remote file systems, running its attached component once for each file...

Dynamics NAV Query

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

Oracle Eloqua Query

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

SAP Netweaver Query

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

Mailchimp Query

Mailchimp Query This component uses the Mailchimp 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 transformations to...

Delete Tables

Delete Tables Component This component allows you to delete a list of tables in a single operation. Note that the Delete Component has more in common with the Snowflake DROP TABLE statement...

S3 Get Object

S3 Get Object Note: This feature is only available for instances hosted on AWS. Transfer a file from Amazon S3 to a remote host. This component can use a number of common...

Storage Load Generator

Overview S3 Load Generator is a tool that helps users load delimited data from public objects in an S3 Bucket (Amazon Simple Storage Service). Cloud Storage Load Generator is a tool that...