Data connector summary

Coming soon!

Development is underway to support the following new data connector:

• SAP ASE (formerly Sybase)

We currently have a read-only version of this connector available. With the read-only version, you can connect to source data and configure your workspace, but you cannot run data generation.

To learn more about and request access to this read-only connector, contact [e-mail].

Tonic Structural currently provides the following data connectors:

Connector	Type	Supported versions	Structural limitations and differences
Amazon DynamoDB (Beta)	Application database		In the Structural application, the term "table" is generally replaced with "collection". Database View and Table View are replaced with Collection View. No Privacy Report download. Limited to De-Identify, Truncate, and Preserve Destination modes for collections. Some generators not supported. Self-consistency only. No subsetting. No upsert. No output to a container repository. No output to an Ephemeral snapshot. No post-job scripts. No workspace inheritance.
Amazon EMR	Spark	5.28 - 6.2 Recommend EMR-6.1.0 or EMR-6.2.0	Professional and Enterprise licenses only. Not available on Structural Cloud. No workspace inheritance. Limited logging information on the Jobs view. Limited to De-Identify and Truncate table modes. Some generators not supported. No subsetting. No upsert. No output data to a container repository. No output to an Ephemeral snapshot. Supports table filters and partition settings on de-identified tables.
Amazon Redshift	Data warehouse		Professional and Enterprise licenses only. Not available on Structural Cloud. No Incremental and Scale table modes. Some generators not supported. No subsetting. No upsert. No output to a container repository. No output to an Ephemeral snapshot. Supports filters on de-identified tables.
Databricks	Spark	9.1 - 14.3 LTS	Professional and Enterprise licenses only. No workspace inheritance. Limited to De-Identify and Truncate table modes. Some generators not supported. No subsetting. No output to a container repository. No output to an Ephemeral snapshot. Supports table filters and partition settings on de-identified tables. No post-job scripts.
Db2 for LUW	Application database	V11.5	Enterprise licenses only. Not available on Structural Cloud. Limited to De-Identify and Truncate table modes. No upsert. No output to a container repository. No output to an Ephemeral snapshot.
File connector	File connector	Can select .csv, .tsv, .json, .xml, and Parquet files from either Amazon S3, Google Cloud Storage, a local file system, or a file mount. Can also select .txt or .gzip files that contain CSV, XML, or JSON content.	Professional and Enterprise licenses only. Limited to De-Identify and Truncate table modes. No workspace inheritance. No subsetting. No upsert. No output to a container repository. No output to an Ephemeral snapshot. No post-job scripts.
Google BigQuery	Data warehouse However, within Tonic it functions more like an application database. Tonic uses the REST API or Storage API to interact with the data.		Professional and Enterprise licenses only. No hidden datasets as source or destination. No Incremental table mode. No Cross-Table Sum generator. No subsetting. No upsert. No output to a container repository. No output to an Ephemeral snapshot. Supports filters on de-identified tables.
MongoDB	Application database	3.6 and above Also supports Amazon DocumentDB	Professional and Enterprise licenses only. On the Structural application, the term "table" is generally replaced with "collection". Database View and Table View are replaced with Collection View. No Privacy Report download Limited to De-Identify, Truncate, and Preserve Destination modes for collections. Some generators not supported. Self-consistency only. No upsert. No output to a container repository. No output to an Ephemeral snapshot. No post-job scripts. No workspace inheritance.
MySQL	Application database	5.6, 5.7, and 8.x Also supports MariaDB 10.0 and above Amazon Aurora
Oracle	Application database	12.1 and above	Enterprise licenses only. No Incremental table mode. No output to a container repository.
PostgreSQL	Application database	10 through 16 Also supports Amazon Aurora
Salesforce	SaaS (Software as a Service)	Minimum Professional edition	Professional and Enterprise licenses only. Limited to De-identify and Truncate table modes. Some generators not supported. No upsert. No output to a container repository. No output to an Ephemeral snapshot. No post-job scripts.
Snowflake on AWS	Data warehouse		Professional and Enterprise licenses only. Some generators not supported. No Scale and Incremental table modes. No upsert. No output to a container repository. No output to an Ephemeral snapshot. Supports filters on de-identified tables.
Snowflake on Azure	Data warehouse		Professional and Enterprise licenses only. Some generators are not supported. No Scale and Incremental table modes. No upsert. No output to container artifacts. No output to an Ephemeral snapshot. Supports filters on de-identified tables.
Spark SDK (self-managed cluster)	Spark		Professional and Enterprise licenses only. Not available on Structural Cloud. No workspace inheritance. Limited to De-Identify and Truncate table modes. Some generators not supported. No subsetting. No upsert. No output to a container repository. No output to an Ephemeral snapshot.
SQL Server	Application database	2014 and above Also supports Azure SQL	Professional and Enterprise licenses only.
Yugabyte	Application database	2024.1 and above Yugabyte SQL (YSQL) only	Professional and Enterprise licenses only. Limited to De-Identify, Truncate, and Scale table modes. Some generators not supported. No upsert. No output to a container repository. No output to an Ephemeral snapshot.