User GuidesAPI ReferenceRelease NotesEnrichment APIs
Doc HomeHelp CenterLog In

Core Connect

This Tamr Core service imports data from and exports data to cloud storage and other external data stores.

The Core Connect service allows you to import and export large data files between Tamr Core and your cloud storage provider. You can use this service through Tamr Core's user interface (UI) and through API calls. Core Connect supports API interaction through the Swagger UI or command-line utilities.

Before You Use Core Connect

Users require access to appropriate cloud storage locations.

Supported Connections and File Types

Connection

Import File Type

Export File Type

S3

Delimited
Avro
JSON*
Parquet**

Delimited
Avro
JSON*
Parquet**

ADLS Gen 2

Delimited
Avro
Parquet**

Delimited
Avro
Parquet**

GCS

Delimited
Avro
Parquet**

Delimited
Avro
Parquet**

Server local file system

Delimited
Avro
Parquet**

Delimited
Avro
JSON*
Parquet**

HDFS (export only)

N/A

Avro

*Core Connect supports newline-delimited JSON.
**To import or export Parquet files, you use the JDBC Driver for Parquet.

Supported JDBC Driver Versions

For each driver, see the related resources for the configuration and parameters specific to that driver.

For examples, see Example jdbcUrl Values for Supported Drivers.

Driver

Version

Related Resources

Amazon Redshift

2.1.0.9

Amazon Redshift JDBC driver documentation

Azure Synapse

Provided via CData 21.0.8228

A separate license is required to use this driver.

CData JDBC Driver for Azure Synapse

DataStax(DSE) Cassandra

42

DataStax documentation

Google BigQuery

Provided via CData 22.0.8297

A separate license is required to use this driver.

CData BigQuery JDBC driver documentation

Hive

1.2.1000.2.6.4.0-91 #

Apache Hive documentation

H2

1.3.148

H2 JDBC driver documentation

Microsoft SQL Server / Azure SQL

7.4.1.jre8

Microsoft SQL Server JDBC driver documentation

MySQL

5.1.4 #

Note: This version supports the free MySQL Community Edition.

MySQL JDBC driver documentation

Oracle RDBMS

12.2.0.1

Oracle JDBC driver documentation

Parquet

Provided via CData 22.0.8297

A separate license is required to use this driver.

CData Parquet JDBC driver documentation

PostgreSQL

42.3.3

PostgreSQL JDBC driver documentation

Presto

0.255

Presto JDBC driver documentation

Salesforce

Provided via CData 21.0.8017

A separate license is required to use this driver.

CData Salesforce JDBC driver documentation

SAP HANA

Provided via CData 21.0.8228

A separate license is required to use this driver.

CData JDBC Driver for SAP HANA

SnowFlake

3.13.23

Snowflake JDBC driver documentation

Teradata RDBMS

17

Teradata JDBC driver documentation

Tibco TDV

8.3

TIBCO TDV JDBC driver documentation

Configuring Core Connect

See Configuring Core Connect.

Using the Core Connect API

See Using the Core Connect API.

Importing and Exporting with the Core Connect UI

To import using the Core Connect UI, see Uploading a Dataset into a Project, and to export see Exporting a Dataset.