# Data connector summary

{% hint style="info" %}
**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 [support@tonic.ai](mailto:support@tonic.ai).
{% endhint %}

Tonic Structural currently provides the following data connectors:

<table data-full-width="true"><thead><tr><th width="194" valign="top">Connector</th><th width="134" valign="top">Type</th><th width="173" valign="top">Supported versions</th><th valign="top">Structural limitations and differences</th></tr></thead><tbody><tr><td valign="top"><a href="dynamodb">Amazon DynamoDB</a></td><td valign="top">Application database</td><td valign="top"></td><td valign="top"><p>In the Structural application, the term "table" is generally replaced with "collection".</p><p><strong>Database View</strong> and <strong>Table View</strong> are replaced with <strong>Collection View</strong>.</p><p>No Privacy Report download.</p><p>Limited to De-Identify, Truncate, and Preserve Destination modes for collections.</p><p>Some generators not supported.</p><p>Self-consistency only.</p><p>No subsetting.</p><p>No upsert.</p><p>No output to a container repository.</p><p>No output to an Ephemeral snapshot.</p><p>No post-job scripts.</p><p>No workspace inheritance.</p></td></tr><tr><td valign="top"><a href="spark">Amazon EMR</a></td><td valign="top">Spark</td><td valign="top">5.28 - 6.2<br><br>Recommend EMR-6.1.0 or EMR-6.2.0</td><td valign="top">Professional and Enterprise licenses only.<br>Not available on Structural Cloud.<br>No workspace inheritance.<br>Limited logging information on the <strong>Jobs</strong> view.<br>Limited to De-Identify and Truncate table modes.<br>Some generators not supported.<br>No subsetting.<br>No upsert.<br>No output data to a container repository.<br>No output to an Ephemeral snapshot.<br>Supports <a href="../generation/subsetting/table-filtering">table filters</a> and <a href="../../generation/table-modes#table-mode-partition-config">partition settings</a> on de-identified tables.</td></tr><tr><td valign="top"><a href="amazon-redshift">Amazon Redshift</a></td><td valign="top">Data warehouse</td><td valign="top"></td><td valign="top">Professional and Enterprise licenses only.<br>Not available on Structural Cloud.<br>No Incremental and Scale table modes.<br>Some generators not supported.<br>No subsetting.<br>No upsert.<br>No output to a container repository.<br>No output to an Ephemeral snapshot.<br><a href="../generation/subsetting/table-filtering">Supports filters on de-identified tables.</a></td></tr><tr><td valign="top"><a href="databricks">Databricks</a></td><td valign="top">Spark</td><td valign="top">9.1 - 14.3 LTS</td><td valign="top">Professional and Enterprise licenses only.<br>No workspace inheritance.<br>Limited to De-Identify and Truncate table modes.<br>Some generators not supported.<br>No subsetting.<br>No output to a container repository.<br>No output to an Ephemeral snapshot.<br>Supports <a href="../generation/subsetting/table-filtering">table filters</a> and <a href="../../generation/table-modes#table-mode-partition-config">partition settings</a> on de-identified tables.<br>No post-job scripts.</td></tr><tr><td valign="top"><a href="db2-luw">Db2 for LUW</a></td><td valign="top">Application database</td><td valign="top">V11.5</td><td valign="top">Enterprise licenses only.<br>Not available on Structural Cloud.<br>Limited to De-Identify and Truncate table modes.<br>No upsert.<br>No output to a container repository.<br>No output to an Ephemeral snapshot.</td></tr><tr><td valign="top"><a href="file-connector">File connector</a></td><td valign="top">File connector</td><td valign="top">Can select .csv, .tsv, .json, .xml, and Parquet files from either Amazon S3, Google Cloud Storage, a local file system, or a file mount.<br><br>Can also select .txt or .gzip files that contain CSV, XML, or JSON content.</td><td valign="top">Professional and Enterprise licenses only.<br>Limited to De-Identify and Truncate table modes.<br>No workspace inheritance.<br>No subsetting.<br>No upsert.<br>No output to a container repository.<br>No output to an Ephemeral snapshot.<br>No post-job scripts.</td></tr><tr><td valign="top"><a href="google-bigquery">Google BigQuery</a></td><td valign="top"><p>Data warehouse</p><p></p><p>However, within Tonic it functions more like an application database.</p><p></p><p>Tonic uses the REST API or Storage API to interact with the data.</p></td><td valign="top"></td><td valign="top">Professional and Enterprise licenses only.<br>No hidden datasets as source or destination.<br>No Incremental table mode.<br>No Cross-Table Sum generator.<br>No subsetting.<br>No upsert.<br>No output to a container repository.<br>No output to an Ephemeral snapshot.<br><a href="../generation/subsetting/table-filtering">Supports filters on de-identified tables.</a></td></tr><tr><td valign="top"><a href="mongodb">MongoDB</a></td><td valign="top">Application database</td><td valign="top">3.6 and above<br><br>Also supports Amazon DocumentDB</td><td valign="top">Professional and Enterprise licenses only.<br>On the Structural application, the term "table" is generally replaced with "collection".<br><strong>Database View</strong> and <strong>Table View</strong> are replaced with <strong>Collection View</strong>.<br>No Privacy Report download<br>Limited to De-Identify, Truncate, and Preserve Destination modes for collections.<br>Some generators not supported.<br>Self-consistency only.<br>No upsert.<br>No output to a container repository.<br>No output to an Ephemeral snapshot.<br>No post-job scripts.<br>No workspace inheritance.</td></tr><tr><td valign="top"><a href="mysql">MySQL</a></td><td valign="top">Application database</td><td valign="top"><p>5.6, 5.7, and 8.x<br></p><p>Also supports</p><ul><li> MariaDB 10.0 and above</li><li>Amazon Aurora</li></ul></td><td valign="top"></td></tr><tr><td valign="top"><a href="oracle">Oracle</a></td><td valign="top">Application database</td><td valign="top">12.1 and above</td><td valign="top">Enterprise licenses only.<br>No Incremental table mode.<br>No output to a container repository.</td></tr><tr><td valign="top"><a href="postgres">PostgreSQL</a></td><td valign="top">Application database</td><td valign="top">10 through 16<br><br>Also supports Amazon Aurora</td><td valign="top"></td></tr><tr><td valign="top"><a href="salesforce">Salesforce</a></td><td valign="top">SaaS (Software as a Service)</td><td valign="top">Minimum Professional edition</td><td valign="top"><p>Professional and Enterprise licenses only.</p><p>Limited to De-identify and Truncate table modes.</p><p>Some generators not supported.</p><p>No upsert.</p><p>No output to a container repository.</p><p>No output to an Ephemeral snapshot.<br>No post-job scripts.</p></td></tr><tr><td valign="top"><a href="snowflake">Snowflake</a></td><td valign="top">Data warehouse</td><td valign="top"></td><td valign="top">Professional and Enterprise licenses only.<br>Some generators not supported.<br>No Scale and Incremental table modes.<br>No upsert.<br>No output to a container repository.<br>No output to an Ephemeral snapshot.<br><a href="../generation/subsetting/table-filtering">Supports filters on de-identified tables.</a></td></tr><tr><td valign="top"><a href="spark-sdk">Spark SDK (self-managed cluster)</a></td><td valign="top">Spark</td><td valign="top"></td><td valign="top">Professional and Enterprise licenses only.<br>Not available on Structural Cloud.<br>No workspace inheritance.<br>Limited to De-Identify and Truncate table modes.<br>Some generators not supported.<br>No subsetting.<br>No upsert.<br>No output to a container repository.<br>No output to an Ephemeral snapshot.</td></tr><tr><td valign="top"><a href="sql-server">SQL Server</a></td><td valign="top">Application database</td><td valign="top">2014 and above<br><br>Also supports Azure SQL</td><td valign="top">Professional and Enterprise licenses only.</td></tr></tbody></table>

