# 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>.
{% 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 post-job scripts.</p><p>No workspace inheritance.</p></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"><p>Professional and Enterprise licenses only.</p><p>Not available on Structural Cloud.</p><p>No Incremental table mode.</p><p>Some generators not supported.</p><p>No upsert.</p><p>No output to a container repository.</p><p><a href="../generation/subsetting/table-filtering">Supports filters on de-identified tables.</a></p></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"><p>Professional and Enterprise licenses only.</p><p>No workspace inheritance.</p><p>Limited to De-Identify and Truncate table modes.</p><p>Some generators not supported.</p><p>No subsetting.</p><p>No output to a container repository.</p><p>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.</p><p>No post-job scripts.</p></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"><p>Enterprise licenses only.</p><p>Not available on Structural Cloud.</p><p>Limited to De-Identify and Truncate table modes.</p><p>No upsert.</p><p>No output to a container repository.</p></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"><p>Professional and Enterprise licenses only.</p><p>Limited to De-Identify and Truncate table modes.</p><p>No workspace inheritance.</p><p>No subsetting.</p><p>No upsert.</p><p>No output to a container repository.</p><p>No post-job scripts.</p></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"><p>Professional and Enterprise licenses only.</p><p>No hidden datasets as source or destination.</p><p>No Incremental table mode.</p><p>No Cross-Table Sum generator.</p><p>No subsetting.</p><p>No upsert.</p><p>No output to a container repository.</p><p><a href="../generation/subsetting/table-filtering">Supports filters on de-identified tables.</a></p></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"><p>Professional and Enterprise licenses only.</p><p>On 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 upsert.</p><p>No output to a container repository.</p><p>No post-job scripts.</p><p>No workspace inheritance.</p></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.2 and above - as of Structural V1500<br><br>For earlier versions, contact Tonic.ai.</td><td valign="top"><p>Enterprise licenses only.</p><p>No Incremental table mode.</p><p>No output to a container repository.</p></td></tr><tr><td valign="top"><a href="postgres">PostgreSQL</a></td><td valign="top">Application database</td><td valign="top">10 through 17<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 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"><p>Professional and Enterprise licenses only.</p><p>Some generators not supported.</p><p>No Incremental table mode.</p><p>No upsert.</p><p>No output to a container repository.</p><p><a href="../generation/subsetting/table-filtering">Supports filters on de-identified tables.</a></p></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"><p>Professional and Enterprise licenses only.</p><p>Not available on Structural Cloud.</p><p>No workspace inheritance.</p><p>Limited to De-Identify and Truncate table modes.</p><p>Some generators not supported.</p><p>No subsetting.</p><p>No upsert.</p><p>No output to a container repository.</p></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>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.tonic.ai/app/setting-up-your-database/data-connector-summary.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
