Datafor supports connections to a wide range of databases. Users can directly connect to any of the following databases:

• Apache Doris
• Amazon Redshift
• ClickHouse
• GaussDB
• GaussDB 200
• Google BigQuery
• Greenplum
• InfluxDB
• MySQL
• Microsoft SQL Server
• MongoDB
• Oracle
• PostgreSQL
• Snowflake
• SAP HANA
• TiDB
• Azure SQL
• Azure Synapse
• DuckDB
• Vertica

Connecting to Other Databases

If your database is not listed above but supports standard SQL syntax, you can use the Generic Database option to connect.

When to Use Generic Database:

• The target database supports SQL-92 or a later version of standard SQL.
• The target database supports JDBC connections and provides the necessary driver.

Important Notes

• Some databases may require additional drivers. Please refer to the official documentation of your database provider.
• The Generic Database option may not support certain database-specific dialects or features. Test SQL compatibility before use.
• If you encounter any issues during the connection process, contact your database administrator or the Datafor support team for assistance.