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.
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.
Data warehouse
Incremental and Scale table modes not supported. Some generators not supported.
No subsetting.
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.
No support for workspace inheritance.
Limited to De-Identify and Truncate table modes.
Some generators not supported.
No subsetting.
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.
Preserve Destination and Incremental table modes not supported. Cross-Table Sum generator not supported. No subsetting.
MongoDB
Application database
3.6 and above
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
Incremental table mode not supported.
Application database
9.6 and above
Data warehouse
Some generators not supported. Scale and Incremental table modes not supported.
No subsetting.
Spark
No support for workspace inheritance.
Limited to De-Identify and Truncate table modes.
Some generators not supported.
No subsetting.
Spark
No support for workspace inheritance.
Limited to De-Identify and Truncate table modes.
Some generators not supported.
Application database