Search…
⌃K
Links

Data connector summary

Tonic provides the following data connectors:
Connector
Type
Supported versions
Tonic limitations and differences
Spark
Recommend EMR-6.1.0 or EMR-6.2.0 with Spark 3.0.0 or Spark 3.0.1.
Any version that works with Spark 2.4.x (but not 2.4.2) or Spark 3.x should work.
Professional and Enterprise licenses only.
No support for workspace inheritance.
Limited logging information on the Job History view.
Limited to De-Identify and Truncate table modes.
Some generators not supported.
No subsetting.
Supports table filters and partition settings on de-identified tables.
Data warehouse
Professional and Enterprise licenses only.
Incremental and Scale table modes not supported. Some generators not supported.
Spark
Tested on Databricks v7.4, 9.1, and 10.4.
Any version that works with Spark 2.4.x (but not 2.4.2), Spark 3.0.x, or Spark 3.1.x should work.
Professional and Enterprise licenses only.
No support for workspace inheritance.
Limited to De-Identify and Truncate table modes.
Some generators not supported.
No subsetting.
Supports table filters and partition settings on de-identified tables.
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.
Preserve Destination and Incremental table modes not supported. Cross-Table Sum generator not supported. No subsetting. Supports filters on de-identified tables.
MongoDB
Application database
3.6 and above
Professional and Enterprise licenses only.
On the Tonic UI, the term "table" is generally replaced with "collection".
Database View and Table View are replaced with Collection View.
Limited to De-Identify, Truncate, and Preserve Destination modes for collections.
Some generators not supported.
No post-job scripts. All schema changes must be resolved in parent workspaces.
Application database
Oracle
Application database
Enterprise licenses only.
Incremental table mode not supported.
Application database
9.6 and above
Data warehouse
Professional and Enterprise licenses only.
Some generators not supported. Scale and Incremental table modes not supported.
Spark
Professional and Enterprise licenses only.
No support for workspace inheritance.
Limited to De-Identify and Truncate table modes.
Some generators not supported.
No subsetting.
Spark
Professional and Enterprise licenses only.
No support for workspace inheritance.
Limited to De-Identify and Truncate table modes.
Some generators not supported.
No subsetting. Supports table filters and partition settings on de-identified tables.
Application database
Professional and Enterprise licenses only.