Data Integration

Commonly referred to as ETL, data integration encompasses the following three primary operations:

Extract:

Exporting data from specified data sources.

Transform:

Modifying the source data (as needed), using rules, merges, lookup tables or other conversion methods, to match the target.

Load:

Importing the resulting transformed data into a target database.

The more recent usage of the term is ELT, emphasizing that the transformation operation does not necessarily need to be performed before loading, particularly in systems such as Snowflake that support transformation during or after loading.

In addition, the scope of data integration has expanded to include a wider range of operations, including:

  • Data preparation.

  • Data migration, movement, and management.

  • Data warehouse automation.

The following data integration tools and technologies are known to provide native connectivity to Snowflake:

Solution

Version / Installation Requirements

Notes

Ab Initio (https://www.abinitio.com/)

Ab Initio: No requirements — contact Ab Initio for more details

Snowflake: ODBC Driver — download from the ODBC Download (https://developers.snowflake.com/odbc/) page

Agile Data Engine (https://www.agiledataengine.com/)

Agile Data Engine: No requirements

Snowflake: No requirements

Airbyte (https://airbyte.com/)

Airbyte: No requirements

Snowflake: No requirements

  • Validated by the Snowflake Ready Technology Validation Program.

  • Additional resources:

    • Connectors > Connector Catalog > Destinations > Snowflake (https://docs.airbyte.com/integrations/destinations/snowflake) (Airbyte Documentation)

Alteryx (https://www.alteryx.com)

Available in Partner Connect

Alteryx Designer Cloud: No requirements

Snowflake: No requirements

Amazon Data Firehose (https://aws.amazon.com/kinesis/data-firehose/)

Amazon Data Firehose: No requirements

Snowflake: No requirements

Additional resources:

  • Amazon Data Firehose documentation (https://docs.aws.amazon.com/firehose/latest/dev/create-destination.html#create-destination-snowflake)

  • Getting Started with Snowflake and Amazon Data Firehose (https://quickstarts.snowflake.com/guide/getting_started_with_snowflake_and_aws_kdf/#0)

AWS Glue (https://aws.amazon.com/glue/)

AWS Glue: No requirements

Snowflake: No requirements

Additional resources:

  • Connecting to Snowflake in AWS Glue Studio (https://docs.aws.amazon.com/glue/latest/dg/connecting-to-data-snowflake.html)

  • Utilizing the new AWS Glue Studio Native Connector for Snowflake (link removed)

Artie (https://www.artie.so/)

Artie: No requirements

Snowflake: No requirements

  • Additional resources:

    • Artie Transfer - Snowflake (https://docs.artie.so/real-time-destinations/snowflake) (Artie Documentation)

Ascend.io (https://www.ascend.io/)

Available in Partner Connect

Ascend.io: No requirements

Snowflake: No requirements

  • Available for trial via Snowflake Partner Connect.

  • Additional resources:

    • Seamlessly Ingest, Transform, and Orchestrate Snowflake Workloads (https://www.ascend.io/snowflake/) (Ascend website)

    • Connections > Warehouse > Snowflake (https://developer.ascend.io/docs/snowflake) (Ascend Documentation)

Azure Data Factory (https://azure.microsoft.com/en-us/services/data-factory/)

Azure Data Factory: No requirements

Snowflake: No requirements

  • Additional resources:

    • Copy activity in Azure Data Factory (https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-overview) (Azure Data Factory Documentation)

    • Copy data from and to Snowflake by using Azure Data Factory (https://docs.microsoft.com/en-us/azure/data-factory/connector-snowflake) (Azure Data Factory Documentation)

Boomi (https://boomi.com/)

Boomi: DCP 4.2 (or higher) or Integration July 2020 (or higher)

Snowflake: No requirements

CData Software (https://www.cdata.com/)

Available in Partner Connect

CData Software: The latest version (https://www.cdata.com/drivers/snowflake/download) of the driver/connector/application is always recommended, but legacy versions will continue to work if they are licensed.

Note that any changes to Snowflake since the release of a driver may not be available in the driver depending on how the changes are implemented.

Snowflake: No requirements

  • Available for trial via Snowflake Partner Connect.

  • Additional resources:

    • Snowflake - Driver Documentation (https://www.cdata.com/drivers/snowflake/docs/) (CData Software Documentation)

    • Snowflake Integration Guides and Tutorials (https://www.cdata.com/kb/tech/snowflake-article-list.rst) (CData Software Knowledge Base)

Celigo (https://www.celigo.com/)

Celigo: No requirements

Snowflake: No requirements

  • Validated by the Snowflake Ready Technology Validation Program.

  • Additional resources:

    • Snowflake Prebuilt Integrations (https://www.celigo.com/integrations/snowflake/) (Celigo website)

    • Set up a connection to Snowflake (https://docs.celigo.com/hc/en-us/articles/360048048792-Set-up-a-connection-to-Snowflake) (Celigo Help Center)

    • Automate application and data integration use cases using integrator.io (http://integrator.io/) — free trial available (Celigo integrator.io website, login required)

Census (https://www.getcensus.com/)

Available in Partner Connect

Census: No requirements

Snowflake: No requirements

  • Available for trial via Snowflake Partner Connect.

  • Additional resources:

    • Data Sources > Snowflake (https://docs.getcensus.com/sources/snowflake) (Census Documentation)

    • Destinations > Snowflake (https://docs.getcensus.com/destinations/snowflake) (Census Documentation)

    • Sync Snowflake to Salesforce (https://www.getcensus.com/sync/snowflake-to-salesforce) (Census website)

Coalesce (https://coalesce.io/)

Available in Partner Connect

Coalesce: No requirements

Snowflake: No requirements

  • Available for trial via Snowflake Partner Connect.

  • Snowflake Quickstart:

    • Accelerate Transformations with Coalesce and Snowflake (https://quickstarts.snowflake.com/guide/transform_your_data_with_coalesce/)

  • Additional resources:

    • Quick Start Guide (https://docs.coalesce.io/docs/quick-start) (Coalesce Documentation)

Datameer (https://www.datameer.com/)

Datameer: v7

Snowflake: No requirements

  • Snowflake Quickstart:

    • Getting Started with Datameer (https://quickstarts.snowflake.com/guide/getting_started_datameer/)

  • Additional resources:

    • User Guide > Getting Started (https://documentation.datameer.com/datameer/) (Datameer Documentation)

    • User Guide > Deploying Data to Snowflake (https://documentation.datameer.com/datameer/deploying_data_to_snowflake/) (Datameer Documentation)

DataVirtuality (https://datavirtuality.com/)

DataVirtuality: No requirements

Snowflake: No requirements

  • Additional resources:

    • Snowflake Data Warehouse Connector (https://documentation.datavirtuality.com/21/reference-guide/connecting-datasources/jdbc-connectors/snowflake-data-warehouse-connector) (DataVirtuality website)

dbt Labs (https://www.getdbt.com/)

Available in Partner Connect

dbt: v0.13 (or higher)

Snowflake: No requirements

  • Available for trial via Snowflake Partner Connect.

  • Validated by the Snowflake Ready Technology Validation Program.

  • Snowflake Quickstarts:

    • Data Engineering with Snowpark Python and dbt (https://quickstarts.snowflake.com/guide/data_engineering_with_snowpark_python_and_dbt/#0)

    • Accelerating Data Teams with dbt Core and Snowflake (https://quickstarts.snowflake.com/guide/data_teams_with_dbt_core/)

    • Accelerating Data Teams with Snowflake and dbt Cloud Hands On Lab (https://quickstarts.snowflake.com/guide/accelerating_data_teams_with_snowflake_and_dbt_cloud_hands_on_lab/)

    • Data Engineering with Apache Airflow, Snowflake and dbt (https://quickstarts.snowflake.com/guide/data_engineering_with_apache_airflow/)

  • Additional resources:

    • Getting Started > Supported Databases > Snowflake (https://docs.getdbt.com/docs/profile-snowflake) (dbt Documentation)

    • Building Models > Warehouse-Specific Configs > Snowflake (https://docs.getdbt.com/docs/snowflake-configs) (dbt Documentation)

    • How we configure Snowflake (https://blog.fishtownanalytics.com/how-we-configure-snowflake-fc13f1eb36c4) (Fishtown Analytics Blog)

Denodo (http://www.denodo.com/)

Denodo: Denodo Platform 6.0 (or higher)

Snowflake: No requirements

  • Additional resources:

    • Denodo Platform 8.0 Datasheet (https://www.denodo.com/en/system/files/document-attachments/ds-denodoplatform8.0-01-web_0.pdf) (Denodo website)

    • How to connect to Snowflake from Denodo (https://community.denodo.com/kb/en/view/document/How%20to%20connect%20to%20Snowflake%20from%20Denodo) (Denodo Knowledge Base)

Devart ODBC Driver for Snowflake (https://www.devart.com/odbc/snowflake/)

Devart ODBC Driver for Snowflake: No requirements

Snowflake: No requirements

  • Additional resources:

    • Overview - ODBC Driver for Snowflake (https://docs.devart.com/odbc/snowflake/) (Devart Documentation)

Devart Python Connector for Snowflake (https://www.devart.com/python/snowflake/)

Devart Python Connector for Snowflake: No requirements

Snowflake: No requirements

  • Additional resources:

    • Overview - Python Connector for Snowflake (https://docs.devart.com/python/snowflake/) (Devart Documentation)

Devart SSIS Data Flow Components for Snowflake (https://www.devart.com/ssis/snowflake/)

Devart SSIS Data Flow Components for Snowflake: No requirements

Snowflake: No requirements

  • Additional resources:

    • Devart SSIS Data Flow Components > Overview (https://docs.devart.com/ssis/) (Devart Documentation)

Diyotta (https://support.diyotta.com/)

Diyotta: No requirements

Snowflake: No requirements

  • Acquired by ThoughtSpot (https://www.thoughtspot.com/)

  • Additional resources:

    • Working with Snowflake Data Object (https://support.diyotta.com/docs/latest/user-guide/using-diyotta-studio/working-with-data-object/working-with-snowflake-data-object) (Diyotta website)

dlt (https://dlthub.com/)

dlt: No requirements

Snowflake: No requirements

  • Validated by the Snowflake Ready Technology Validation Program.

  • Additional resources:

    • Getting started (https://dlthub.com/docs/intro) (dlt Documentation)

    • Destinations > Snowflake (https://dlthub.com/docs/dlt-ecosystem/destinations/snowflake) (dlt Documentation)

    • Sources > 30+ SQL Databases (https://dlthub.com/docs/dlt-ecosystem/verified-sources/sql_database/#supported-databases) (dlt Documentation)

Domo (https://www.domo.com/)

Available in Partner Connect

Domo: No requirements

Snowflake: No requirements

Available for trial via Snowflake Partner Connect.

  • Additional resources:

    • Connect everything, everywhere (https://www.domo.com/data-integration/connectors)

    • Combine and transform your data (https://www.domo.com/data-integration/etl)

    • Magic ETL on Snowflake (https://domo-support.domo.com/s/article/000005455?language=en_US)

    • Domo Data Connectors (https://domo-support.domo.com/s/topic/0TO5w000000ZanLGAS/connectors?language=en_US)

Etleap (https://etleap.com/)

Available in Partner Connect

Etleap: No requirements

Snowflake: No requirements

Etlworks (http://etlworks.com)

Etlworks: No requirements

Snowflake: No requirements

  • Additional resources:

    • Etlworks and Snowflake (https://etlworks.com/using-etlworks-to-load-data-in-snowflake.html) (Etlworks website)

    • Working with Snowflake (https://support.etlworks.com/hc/en-us/sections/360002758614-Working-with-Snowflake) (Etlworks Documentation)

Fivetran (https://www.fivetran.com)

Available in Partner Connect

Fivetran: No requirements

Snowflake: No requirements

  • Available for trial via Snowflake Partner Connect.

  • Validated by the Snowflake Ready Technology Validation Program.

  • Snowflake Quickstarts:

    • Automating Data Pipelines to Drive Marketing Analytics with Snowflake and Fivetran (https://quickstarts.snowflake.com/guide/vhol_fivetran/)

    • Fivetran - Automate Salesforce Insights: Source, Target, Transformations, Dashboard…NO CODE (https://quickstarts.snowflake.com/guide/modern_data_stack_with_fivetran_snowflake_salesforce/)

  • Additional resources:

    • Strategic Partner: Snowflake (https://www.fivetran.com/partners-snowflake) (Fivetran website)

    • Connectors > Destinations > Snowflake (https://fivetran.com/docs/destinations/snowflake) (Fivetran Documentation)

Google Cloud Data Fusion (https://cloud.google.com/data-fusion)

Google Cloud Data Fusion: Snowflake plugin

Snowflake: No requirements

  • Additional resources:

    • Cloud Data Fusion Plugins (https://cloud.google.com/data-fusion/plugins) (Google Cloud website)

    • Cloud Storage to Snowflake Action (https://github.com/data-integrations/snowflake-plugins/blob/develop/docs/CloudStorageToSnowflake-action.md) (GitHub)

Google Cloud Dataflow (https://cloud.google.com/dataflow)

Google Cloud Dataflow: Apache Beam

Snowflake: No requirements

  • Additional resources:

    • Snowflake I/O (https://beam.apache.org/documentation/io/built-in/snowflake/) (Apache Beam Documentation)

    • Class SnowflakeIO (https://beam.apache.org/releases/javadoc/2.25.0/org/apache/beam/sdk/io/snowflake/SnowflakeIO.html) (Apache Beam Javadoc)

Heap (https://heap.io/)

Heap: Connect

Snowflake: No requirements

  • Additional resources:

    • Heap Connect for Snowflake (https://docs.heap.io/docs/heap-connect-snowflake-integration) (Heap Documentation)

Hevo Data (https://hevodata.com/)

Available in Partner Connect

Hevo Data CDC for ETL: No requirements

Snowflake: No requirements

  • Available for trial via Snowflake Partner Connect.

  • Additional resources:

    • Destinations > Data Warehouses > Snowflake (https://docs.hevodata.com/destinations/data-warehouses/snowflake/) (Hevo Documentation)

Hightouch (https://hightouch.com/)

Available in Partner Connect

Hightouch: No requirements

Snowflake: No requirements

  • Available for trial via Snowflake Partner Connect.

  • Snowflake Quickstart:

    • Suppress existing customers from a Youtube campaign with Hightouch and Snowflake (https://quickstarts.snowflake.com/guide/suppress_existing_customers_from_youtube_campaign_with_hightouch_and_snowflake/)

  • Additional resources:

    • Activate the Data Cloud (https://hightouch.com/snowflake/) (Hightouch website)

    • Sources > Snowflake (https://hightouch.com/docs/sources/snowflake/) (Hightouch Documentation)

HVR (https://www.hvr-software.com/)

HVR: No requirements

Snowflake: ODBC Driver — download from the ODBC Download (https://developers.snowflake.com/odbc/) page

  • Validated by the Snowflake Ready Technology Validation Program.

  • Additional resources:

    • Requirements for Snowflake (https://www.hvr-software.com/docs/5/location-class-requirements/requirements-for-snowflake) (HVR Documentation)

    • Quick Start for HVR - Snowflake (https://www.hvr-software.com/docs/5/quick-start-guides/quick-start-for-hvr-snowflake) (HVR Documentation)

IBM InfoSphere DataStage (https://www.ibm.com/us-en/marketplace/datastage/)

DataStage: InfoSphere Information Server 11.7

Snowflake: JDBC Driver — download from the JDBC Driver page in the Maven Central Repository (https://central.sonatype.com/search?q=g%3Anet.snowflake%20snowflake-jdbc)

  • Snowflake Quickstart:

    • Use IBM DataStage to Load Enterprise Data into Snowflake (https://quickstarts.snowflake.com/guide/data_engineering_with_datastage/)

  • Additional resources:

    • Snowflake connector (https://www.ibm.com/docs/en/iis/11.7?topic=databases-snowflake) (InfoSphere Information Server Documentation)

    • DataStage on Cloud Pak for Data free trial (https://dataplatform.cloud.ibm.com/registration/stepone?context=cpdaas&apps=cos%2Cdatastage&regions=us-south%2Ceu-de&S_PKG=ov80049&cm_mmca1=10000665&cm_mmca2=000000TF) (IBM Cloud Pak for Data website)

    • DataStage on Cloud Pak for Data as a Service:

      • DataStage on Cloud Pak for Data as a Service (https://dataplatform.cloud.ibm.com/docs/content/svc-welcome/datastage.html) (Documentation)

      • Snowflake connection (https://dataplatform.cloud.ibm.com/docs/content/wsj/manage-data/conn-snowflake.html?audience=wdp) (Documentation)

    • DataStage on Cloud Pak for Data Software:

      • DataStage on Cloud Pak for Data (https://www.ibm.com/docs/en/cloud-paks/cp-data/4.6.x?topic=services-datastage) (Documentation)

      • Snowflake connection (https://www.ibm.com/docs/en/cloud-paks/cp-data/4.6.x?topic=catalogs-snowflake-connection) (Documentation)

      • ELT run mode in DataStage (https://www.ibm.com/docs/en/cloud-paks/cp-data/4.6.x?topic=data-elt-run-mode) (Documentation)

Informatica (https://www.informatica.com)

Available in Partner Connect

Informatica Cloud:

  • Cloud Connector for Snowflake — available directly in the Informatica Cloud interface or by download from the Informatica Marketplace (https://marketplace.informatica.com/solutions/snowflake_elastic_data_warehouse).

  • Secure Agent — download and install from the Informatica Cloud interface

Snowflake:

  • For push-down optimization: ODBC Driver — download from the ODBC Download (https://developers.snowflake.com/odbc/) page

  • For all other functionality: No requirements

  • Available for trial via Snowflake Partner Connect.

  • Validated by the Snowflake Ready Technology Validation Program.

  • Snowflake Quickstarts:

    • Harness the Power of Snowflake with Informatica Intelligent Data Management Cloud (https://quickstarts.snowflake.com/guide/harness_the_power_of_snowflake_with_informatica_idmc/)

    • Accelerate Data Transformation with the Telecom Data Cloud and Informatica (https://quickstarts.snowflake.com/guide/Accelerate_Data_Transformation_with_the_Telecom_Data_Cloud/)

  • Additional resources:

    • FAQ: Informatica Cloud Connector for Snowflake (https://community.snowflake.com/s/article/Informatica-Cloud-Connector-for-Snowflake-FAQ) (Snowflake Community)

    • Snowflake Cloud Data Warehouse Connector Related Queries (https://kb.informatica.com/faq/7/Pages/21/553165.aspx) (Informatica Network)

Informatica (https://www.informatica.com)

Available in Partner Connect

Informatica Data Loader: No requirements

Snowflake: No requirements

  • Available for trial via Snowflake Partner Connect.

  • Additional resources:

    • How to Video - Getting Started with Informatica Data Loader for Snowflake (https://video.informatica.com/detail/video/6308017723112) (Informatica Videos)

Apache Kafka (https://kafka.apache.org/)

Apache Kafka: No requirements

Kafka Connect: API 2.0.0 to 2.2.0 (all other versions are not supported)

Snowflake: Snowflake Connector for Kafka — download from Maven (https://mvnrepository.com/artifact/com.snowflake)

Keboola (http://www.keboola.com/)

Available in Partner Connect

Keboola: No requirements

Snowflake: No requirements

  • Available for trial via Snowflake Partner Connect.

  • Snowflake Quickstart:

    • Getting Started with Keboola (https://quickstarts.snowflake.com/guide/getting_started_keboola/)

  • Additional resources:

    • Storage (https://help.keboola.com/storage/?_ga=2.36925536.1177541999.1508806853-909758245.1508806853) (Keboola Documentation)

    • Snowflake Transformation (https://help.keboola.com/manipulation/transformations/snowflake) (Keboola Documentation)

Knoema (https://knoema.com/)

Available in Partner Connect

Knoema: No requirements

Snowflake: No requirements

Matillion ETL (https://www.matillion.com/products/etl-software/)

Available in Partner Connect

Matillion Data Productivity Cloud: No requirements

Snowflake: No requirements

Matillion ETL (https://www.matillion.com/products/etl-software/)

Available in Partner Connect

Matillion ETL: No requirements

Snowflake: No requirements

  • Available for trial via Snowflake Partner Connect.

  • Validated by the Snowflake Ready Technology Validation Program.

  • Snowflake Quickstart:

    • Cloud Native Data Engineering with Matillion and Snowflake (https://quickstarts.snowflake.com/guide/cloud_native_data_engineering_with_matillion_and_snowflake/)

  • Additional resources:

    • Snowflake: How to Get Started (https://www.matillion.com/etl-for-snowflake/how-to-get-started/) (Matillion website)

    • Snowflake articles with videos (https://www.matillion.com/community/snowflake/) (Matillion Community)

Nexla (https://www.nexla.com/)

Available in Partner Connect

Nexla: No requirements

Snowflake: No requirements (ODBC, JDBC, and API options)

Pentaho (http://www.pentaho.com)

Pentaho Data Integration (PDI):

  • Pentaho 8.3 (or higher): Snowflake plugin — download from the Pentaho Customer Portal (requires login)

  • Pentaho 8.2 (or lower): No Pentaho requirements, but some Snowflake requirements

Snowflake:

  • Pentaho 8.3 (or higher): No requirements

  • Pentaho 8.2 (or lower):

    • JDBC Driver — download from the JDBC Driver page in the Maven Central Repository (https://central.sonatype.com/search?q=g%3Anet.snowflake%20snowflake-jdbc)

      or

    • 3rd-party connector (PentahoSnowflakePlugin) — download from GitHub (https://github.com/inquidia/PentahoSnowflakePlugin)

  • Additional resources:

    • PDI and Snowflake (https://help.pentaho.com/Documentation/8.3/Products/PDI_and_Snowflake) (Pentaho Documentation)

    • Bulk load into Snowflake (https://help.pentaho.com/Documentation/8.3/Products/Bulk_load_into_Snowflake) (Pentaho Documentation)

    • PentahoSnowflakePlugin Readme (https://github.com/inquidia/PentahoSnowflakePlugin/blob/master/README.md) (GitHub)

    • Configuring a JDBC connection to Snowflake Using Pentaho (https://community.snowflake.com/s/article/configuring-a-jdbc-connection-to-snowflake-using-pentaho) (Snowflake Community)

Precog (https://precog.com/)

Precog: No requirements

Snowflake: No requirements

  • Validated by the Snowflake Ready Technology Validation Program.

  • Request a trial (https://precog.com/demo/).

  • Additional resources:

    • AI-driven, no-code ELT for Snowflake (https://precog.com/use-cases/no-code-elt-for-snowflake/) (Precog website)

    • Case study: How a Luxury Gelato Chain Uses Precog to Actually Get Realtime, Multi-Source Analytics (https://precog.com/how-a-luxury-gelato-chain-uses-precog-to-actually-get-realtime-multi-source-analytics/) (Precog website)

Qlik (http://www.qlik.com/)

Available in Partner Connect

Qlik Replicate: No requirements

Snowflake: ODBC Driver — download from the ODBC Download (https://developers.snowflake.com/odbc/) page

Redpoint Global Inc. (https://www.redpointglobal.com/)

Redpoint:

  • Redpoint Orchestration v7.3 (or higher)

  • Redpoint Data Management v9.4.9.3 (or higher)

Snowflake:

  • ODBC Driver (for Redpoint Orchestration) — download from the ODBC Download (https://developers.snowflake.com/odbc/) page

  • JDBC Driver (for Redpoint Data Management) — download from the JDBC Driver page in the Maven Central Repository (https://central.sonatype.com/search?q=g%3Anet.snowflake%20snowflake-jdbc)

  • Additional resources:

    • Redpoint and Snowflake: No Data Replication and Complete CDP Functionality (https://www.redpointglobal.com/blog/redpoint-and-snowflake-no-data-replication-and-complete-cdp-functionality/) (Redpoint Blog)

    • Redpoint Orchestration > Snowflake ODBC driver configuration (https://docs.redpointglobal.com/rpi/admin-appendix-a-database-preparation#Admin:AppendixA-Databasepreparation-SnowflakeODBCdriverconfiguration) (Redpoint Documentation)

    • Redpoint Data Management > RDBMS providers: Snowflake (https://docs.redpointglobal.com/rpdm/rdbms-database-providers#RDBMSdatabaseproviders-RDBMS_providers_SnowflakeA6B0F944RDBMSproviders:Snowflake) (Redpoint Documentation)

Rivery (https://rivery.io/)

Available in Partner Connect

Rivery: No requirements

Snowflake: No requirements

  • Available for trial via Snowflake Partner Connect.

  • Validated by the Snowflake Ready Technology Validation Program.

  • Additional resources:

    • Now Compatible with Snowflake (https://rivery.io/now-compatible-snowflake/) (Rivery website)

    • Integrations: Snowflake (https://rivery.io/integration/snowflake/) (Rivery website)

    • Customer Spotlight: Roomjoom (https://rivery.io/customer-spotlight-roojoom/) (Rivery website)

SAP Data Services (https://www.sap.com/products/data-services.html)

SAP Data Services: 4.2 SP12 (or higher)

Snowflake: ODBC Driver — download from the ODBC Download (https://developers.snowflake.com/odbc/) page

  • Snowflake Quickstart:

    • SAP Accounts Receivable to Snowflake using ADF (https://quickstarts.snowflake.com/guide/sap_accounts_receivable_to_snowflake_using_adf/)

  • Additional resources:

    • Data Services — What’s New (https://help.sap.com/viewer/9f1b4472ec98409682d91953b9e68c92/4.2.12/en-US/578e89ed6d6d1014b3fc9283b0e91070.html) (SAP Help Portal)

    • Data Services Supplement for Big Data (https://help.sap.com/viewer/af6d8e979d0f40c49175007e486257f0/4.2.12/en-US/bdfc176728dc466bbaf5012a9e3793bc.html) (SAP Help Portal)

Segment (http://segment.com/)

Segment: No requirements

Snowflake: No requirements

Skyvia (https://skyvia.com/)

Skyvia: No requirements

Snowflake: No requirements

  • Additional resources:

    • Skyvia and Snowflake integration (https://skyvia.com/connectors/snowflake) (Skyvia website)

    • Working with Snowflake (https://docs.skyvia.com/connectors/databases/snowflake_connections.html) (Skyvia Documentation)

Solace (https://solace.com/)

Solace: No requirements

Snowflake: No requirements

  • Additional resources:

    • Solace and Snowflake integration (https://solace.com/integration-hub/pubsub-connector-for-snowflake/) (Solace website)

SnapLogic (https://www.snaplogic.com/)

Available in Partner Connect

Snaplogic: 4.7.0 (or higher) with Snowflake Snap Pack

Snowflake: JDBC Driver — download from the JDBC Driver page in the Maven Central Repository (https://central.sonatype.com/search?q=g%3Anet.snowflake%20snowflake-jdbc)

  • Available for trial via Snowflake Partner Connect.

  • Additional resources:

    • Snowflake Snap Pack (https://docs-snaplogic.atlassian.net/wiki/display/SD/Snowflake+Snap+Pack) (SnapLogic Documentation)

Snowplow (https://snowplowanalytics.com/)

Snowplow: Snowflake Loader — download from GitHub (https://github.com/snowplow-incubator/snowplow-snowflake-loader)

Snowflake: No requirements

  • Additional resources:

    • Snowflake Loader (https://docs.snowplowanalytics.com/docs/pipeline-components-and-applications/loaders-storage-targets/snowplow-snowflake-loader/) (Snowplow Documentation)

Stitch (https://www.stitchdata.com/)

Available in Partner Connect

Stitch: No requirements

Snowflake: No requirements

  • Available for trial via Snowflake Partner Connect.

  • Additional resources:

    • Connecting a Snowflake Data Warehouse to Stitch (https://www.stitchdata.com/docs/destinations/snowflake/connecting-a-snowflake-data-warehouse-to-stitch#main/) (Stitch Documentation)

StreamSets (https://streamsets.com/)

Available in Partner Connect

StreamSets: No requirements

Snowflake: No requirements

  • Utilizes Snowpipe for continuous loading.

  • Available for trial via Snowflake Partner Connect.

  • Validated by the Snowflake Ready Technology Validation Program.

  • Snowflake Quickstarts:

    • StreamSets’ Transformer for Snowflake: Hands on Lab (https://quickstarts.snowflake.com/guide/streamsets_transformer_for_snowflake_hol)

    • Process Change Data Capture (CDC) data from Oracle to Snowflake Using StreamSets (https://quickstarts.snowflake.com/guide/cdc_data_from_oracle_to_snowflake_in_streamsets/)

    • A Dive Into Slowly Changing Dimensions with Snowpark and StreamSets (https://quickstarts.snowflake.com/guide/snowflake_transformer/)

  • Additional resources:

    • Tame Snowflake with StreamSets (https://streamsets.com/partners/snowflake) (StreamSets website)

Striim (https://www.striim.com/)

Available in Partner Connect

Striim: No requirements

Snowflake: No requirements

Supermetrics (https://supermetrics.com/)

Supermetrics: No requirements

Snowflake: No requirements

  • Validated by the Snowflake Ready Technology Validation Program.

  • Additional resources:

    • Snowflake Data Warehouse: Getting started (https://supermetrics.com/docs/product-dwh-snowflake-getting-started/) (Supermetrics Documentation)

Tableau Prep (https://www.tableau.com/products/prep)

Tableau: Prep 2018.3 (or higher)

Snowflake: ODBC Driver — download from the ODBC Download (https://developers.snowflake.com/odbc/) page

  • Snowflake Quickstart:

    • Visual Analytics powered by Snowflake and Tableau (https://quickstarts.snowflake.com/guide/visual_analytics_powered_by_snowflake_and_tableau/)

  • Additional resources:

    • Snowflake for Tableau Prep (https://www.tableau.com/products/new-features/prep#feature-91953) (Tableau website)

Talend (https://www.talend.com)

Available in Partner Connect

Talend:

  • Talend 6.4 (or higher): No requirements

  • Talend 6.3 (or lower): Snowflake component required — contact Talend for details

Snowflake: No requirements

  • Available for trial via Snowflake Partner Connect.

  • Validated by the Snowflake Ready Technology Validation Program.

  • Additional resources:

    • Snowflake Components in Talend (https://help.talend.com/reader/vftIUG8awmW0On_yhMotqA/NBw~_mrvqvi7Af1~T4d2BQ) (Talend Documentation)

    • Centralizing Snowflake Metadata (https://help.talend.com/reader/I5~nujSNXadpT4WYWRHrjw/0U7ZQgxwfY4b6AYyT_SV1A) (Talend Documentation)

TIBCO Spotfire (https://www.tibco.com/)

TIBCO ActiveMatrix BusinessWorks:

  • 6.x (or higher)

  • Plug-in for Snowflake 6.x (or higher)

Snowflake: JDBC Driver — download from the JDBC Driver page in the Maven Central Repository (https://central.sonatype.com/search?q=g%3Anet.snowflake%20snowflake-jdbc)

  • Validated by the Snowflake Ready Technology Validation Program.

  • Additional resources:

    • TIBCO ActiveMatrix BusinessWorks Plug-in for Snowflake User’s Guide (https://docs.tibco.com/pub/bwpluginsnowflake/6.0.1/doc/html/GUID-53E7AE6F-9F9B-4059-9136-CB0A9A1684EC.html) (TIBCO Documentation)

TMMData (http://www.tmmdata.com/)

TMMData: No requirements

Snowflake: No requirements

Trifacta (https://www.trifacta.com)

Trifacta: No requirements

Snowflake: No requirements

  • Additional resources:

    • Trifacta for Snowflake (https://www.trifacta.com/solutions/snowflake/) (Trifacta website)

    • Trifacta for Snowflake: Data Prep for Your Cloud Data Warehouse or Data Lake — Part 1 (https://www.trifacta.com/blog/trifacta-for-snowflake-part-1/) (Trifacta blog)

Wherescape (http://www.wherescape.com/)

Wherescape: No requirements

Snowflake: No requirements

  • Validated by the Snowflake Ready Technology Validation Program.

  • Additional resources:

    • Wherescape Automation for Snowflake (https://www.wherescape.com/products-services/wherescape-automation-for-snowflake/) (Wherescape website)

windsorsi (https://windsor.ai/)

windsor.ai: No requirements

Snowflake: No requirements

  • Additional resources:

    • Utilizing Windsor.ai connector for Snowflake data integration (https://windsor.ai/destinations/snowflake/)

    • Documentation: How to integrate data into Snowflake with Windsor.ai (https://windsor.ai/documentation/how-to-integrate-data-into-snowflake/)

Workato (https://www.workato.com/)

Workato: No requirements

Snowflake: No requirements

  • Validated by the Snowflake Ready Technology Validation Program.

  • Additional resources:

    • Workato is Snowflake Ready… (https://blog.workato.com/2020/08/workato-snowflake-ready/#.X5yFdlNKjuw) (Workato Blog)

    • Connectors > Snowflake (https://docs.workato.com/connectors/snowflake.html) (Workato Documentation)

Language: English