Output Connectors

Use output connectors to push data from Salesforce Data Pipelines to the remote system. Output connectors can push as part of a data prep output node, and some can also push out unprepared data using sync.

• Amazon S3 Output Connection
  Create a remote connection using the Amazon S3 output connector to write .csv data from Salesforce Data Pipelines to an Amazon S3 bucket when using Data Prep.
• Azure Data Lake Output Connection
  Create a remote connection using the Azure Data Lake output connector to write .csv data from Salesforce Data Pipelines to Microsoft Azure Data Lake Storage Gen2 when using Data Prep.
• Salesforce Output Connection
  Push your prepared dataset data into any Salesforce org from Salesforce Data Pipelines Salesforce Output connector and Data Prep. With your prepared data back in Salesforce, you can integrate external data, apply the suite of Salesforce automation tools to act on the data, and allow non-Salesforce Data Pipelines users access to the data through reports and dashboards. External connectors require OAuth 2.0 for server to server communication.
• Snowflake Output Connection
  Create a remote connection using the Snowflake output connector to write data from Salesforce Data Pipelines to a Snowflake table. Then, use Sync Out to push raw data from Salesforce Data Pipelines to Snowflake, or a Data Prep recipe output node to push transformed data.
• Sync Out for Snowflake
  Sync Out for Snowflake exports your raw local Salesforce data via Salesforce Data Pipelines to Snowflake using the Salesforce Data Pipelines output connector for Snowflake. With Sync Out for Snowflake, keep your Salesforce data in Snowflake up to date using scheduled Data Sync without the need for a third-party ETL tool. Fresh Salesforce data is vital if you maintain a central Snowflake data lake for processing, analysis, business automation, or storage. For example, give your shipping logistics team the freshest data by merging your account data from your system of record, Salesforce, with your ERP’s shipping data in your data lake.
• Tableau Online Output Connection
  Push your prepared data from Salesforce Data Pipelines into Tableau Online with the Tableau Online Output connector and Data Prep recipes. Your transformed, merged, and cleaned data is pushed to Tableau Online as a .hyper file for further analysis. For example, prepare historical Opportunity data for struggling products in Salesforce Data Pipelines, and then use Tableau Online’s analytics tools to identify helpful trends to optimize deals.