1. Databases
Auto Insights can connect to ODBC compatible databases, which captures 80% - 90% of databases on the market today. The databases that we can connect to are listed in this section.
MySQL
MySQL 5.5 or later
MariaDB 5.5 or later
POSTGRES
PostgreSQL server versions from 7.4 to 12 (e.g. Amazon Redshift)
MS SQL
Microsoft SQL Server 2008
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
Analytics Platform System
Azure SQL Database
Azure SQL Data Warehouse
ORACLE SQL
Oracle Database 11.2 or later
SNOWFLAKE
Snowflake instance: <account_identifier>.snowflakecomputing.com
For secure database connections, it is necessary to comply with TLS v1.2 at least.
2. CSV & ZIP files
Auto Insights also accepts .csv and .zip files.