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. | |
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. | |
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. | |
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 | | | |
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. | |
Application database | | Professional and Enterprise licenses only. |