Data Source Compatibility matrix
Indexima can:
- load data from any data source using a JDBC connection
- connect to / create a link to an external (from Indexima) table
All those actions require the installation of a JDBC driver related to the database users want to query.
The drivers must be added in the folder /galactica/driver that is loaded automatically on service start.
| Data Source | Minimum version of the native JDBC driver (1) | External table creation available since | Ingested table creation available since | JDBC Connection String |
|---|---|---|---|---|
| Snowflake | 3.9.2 | 1.7.6 | set a connection string (3) | |
| Hive | 2.1 | 1.7.6 | ||
| BigQuery | 1.2.2.1004 | 1.7.7 | ||
| Redshift | 1.2.37.1001 | 1.7.7 | ||
| Impala | 2.6.15.1017 | 1.7.8 | ||
| Oracle | 12.2.0.1.0 | 1.7.9 | ||
Azure Synapse Microsoft SQL Server | 7.4.1 | 1.7.10 | ||
| PostgreSQL | 42.2.2 | 1.7.11 | ||
| MySQL | 8.0.18 | 1.7.11 | ||
| SAP Hana | 2.9.12 | 2021.5 | Connect to SAP HANA via JDBC | |
| Apache Hbase via Apache Phoenix | 1.7.6 | |||
| Sybase IQ Enterprise | 1.7.12 | set a connection string (2) |
(1) required to perform a JDBC LOAD or to create an external table
About JDBC Connection String
(2) user & password parameters have to be specified in lower case
(3) consider encoding password when it contains special characters
Special characters in password
Replace & by %26