Data Integration

Traditionally, data integration has been referred to as ETL or ELT, which covers the following 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.

More recently, data integration has expanded to include a wider array of operations, including data migration/management and data warehouse automation.

Snowflake works with the following data integration tools:

Solution Software Requirements and Additional Information
Ajilius

Requirements:

Ajilius:None
Snowflake:None — Native Python integration

Additional reading:

Alooma

Requirements:

Alooma:None
Snowflake:None — Native JDBC integration

Additional reading:

Alteryx

Requirements:

Alteryx:Analytics 11.5 (or higher)
Snowflake:None — Native ODBC integration

Additional reading:

Attunity Replicate

Requirements:

Attunity Replicate:
 None
Snowflake:None — Native ODBC integration

Additional reading:

DataVirtuality

Requirements:

DataVirtuality:None
Snowflake:None — Native JDBC integration

Additional reading:

Integrate Your Data into Snowflake (DataVirtuality website)
Denodo

Requirements:

Denodo:Platform 6.0 (or higher)
Snowflake:None — Native JDBC integration

Additional reading:

Denodo Platform 6.0 (Denodo data sheet)
Diyotta

Requirements:

Diyotta:None
Snowflake:None — Native JDBC integration

Additional reading:

Diyotta and Snowflake (Diyotta website)
Replatforming: Netezza to Snowflake (Diyotta Datasheet — requires registration)
Fivetran

Requirements:

Fivetran:None
Snowflake:None — Native JDBC integration

Additional reading:

Flyway

Requirements:

Flyway:4.2.0 — See flyway/flyway pull #1776 (GitHub)
Snowflake:JDBC Driver — available via snowflake-jdbc (Maven Central)
Informatica

Informatica Cloud (service)

Requirements:

Informatica:

Cloud Connector for Snowflake — available directly in the Informatica Cloud interface or download from the Informatica Marketplace

Secure Agent — download and install from the Informatica Cloud interface

Snowflake:

ODBC Driver (only required for push-down optimization) — download from Snowflake web interface

None (for all other functionality) — native JDBC integration

Additional reading:

Snowflake Connector Guide (Informatica documentation)

Informatica PowerCenter (on-premises)

Requirements:

Informatica:

PowerCenter 10.2 (or higher)

PowerExchange for Snowflake — for details, see the Informatica Network announcement

Snowflake:

ODBC Driver (only required for push-down optimization) — download from Snowflake web interface

None (for all other functionality) — native JDBC integration

Additional reading:

PowerExchange for Snowflake Release Notes (Informatica documentation)
PowerExchange for Snowflake User Guide (Informatica documentation)

Note

  • For PowerCenter 9.6.1, please contact your Snowflake sales rep for connector information.
  • For PowerCenter 9.5.x (or lower), no connector is available.
Keboola

Requirements:

Keboola:None
Snowflake:None — Native JDBC integration

Additional reading:

Storage (Keboola Documentation)
Matillion

Requirements:

Matillion:None
Snowflake:None — Native JDBC integration

Additional reading:

How to Get Started (Matillion website)
Snowflake articles with videos (Matillion Community)
Segment

Requirements:

Segment:None
Snowflake:None — Native Go integration

Additional reading:

Snowflake Destination (Segment Documentation)
SnapLogic

Requirements:

Snaplogic:4.7.0 (or higher) with Snowflake Snap Pack
Snowflake:JDBC Driver — available via snowflake-jdbc (Maven Central)

Additional reading:

Snowflake Snap Pack (SnapLogic Documentation)
Snowplow

Requirements:

Snowplow:Snowflake Loader — snowplow-snowflake-loader (GitHub)
Snowflake:None — Native JDBC integration

Additional reading:

Stitch

Requirements:

Stitch:None
Snowflake:None — Native JDBC integration

Additional reading:

Talend

Talend 6.4 (or higher):

Requirements:

Talend:None
Snowflake:None — Native JDBC integration

Additional reading:

Snowflake Components in Talend (Talend Documentation)
Centralizing Snowflake Metadata (Talend Documentation)

Talend 6.3 (or lower):

Requirements:

Talend:Snowflake component — contact Talend for more information
Snowflake:JDBC Driver — available via snowflake-jdbc (Maven Central)
TMMData

Requirements:

TMMData:None
Snowflake:None — Native JDBC integration
Wherescape

Requirements:

Wherescape:None
Snowflake:None — Native JDBC integration

Additional reading: