Supported databases
Via connections and the operators
- Read Database
- Write Database
- Update Database
- Execute SQL
Altair AI Cloud supports relational database systems offering a fully compliant JDBC driver.
Whitelists
For the following databases, a subset of drivers are whitelisted:
HSQLDB
| driver | checksum |
|---|
| hsqldb-2.5.0.jar | 3d1a26905a82ccb66da8f63efa443b5b |
| hsqldb-2.6.1.jar | 855805d373e8ea58e75913ded352338a |
| hsqldb-2.7.0.jar | 7a2c69826a293cb7bd67023360f62ecb |
| hsqldb-2.7.1.jar | 0d99b8af583b80eb114d9d483300bee5 |
MSSQL
| driver | checksum |
|---|
| mssql-jdbc-11.2.1.jre11.jar | 7e5ab3ba6926ade25378cf871e2ae6a8 |
| mssql-jdbc-11.2.3.jre11.jar | 35acf0eb21d67f6e993de82c9922f5a5 |
| mssql-jdbc-12.1.0.jre11-preview.jar | e95a57ed0edbca6644b6b5869a78c6ba |
| mssql-jdbc-12.2.0.jre11.jar | dd6efff9a4af32a2114f7c442a917aac |
MYSQL
| driver | checksum |
|---|
| mariadb-java-client-3.0.7.jar | 505a77fb9ed11de08a84cd83c090f1dd |
| mysql-connector-java-8.0.30.jar | 923639aff48f9a47fa6c7c9025859f5c |
| mysql-connector-java-8.0.31.jar | da96f0f83ff811921c044b8ea407f254 |
| mysql-connector-java-8.0.32.jar | 3ba9d1a80e33ec5c5d55d752e0a76677 |
ORACLE
| driver | checksum |
|---|
| ojdbc10-19.16.0.0.jar | 6a1563bd36d3590e55c354f0e73f5025 |
| ojdbc11-21.7.0.0.jar | e2809f4d4a43cf59ff7fa1137a25d5e6 |
| ojdbc11-21.8.0.0.jar | 4a5bd2c2ed6843ad2c34d22c2b46d9d2 |
| ojdbc11-21.9.0.0.jar | 6aaaf331683c4972ada2ce65a03f4380 |
POSTGRESQL
| driver | checksum |
|---|
| postgres-42.5.1.jar | c760d13432898f1225463ac4f85587fb |
| postgresql-42.5.2.jar | 33968b135f52c8a5aaf7cbf07f77ce16 |
| postgresql-42.5.3.jar | 38ae934c5e1e7855081491285fbb4f9f |
SYBASE
| driver | checksum |
|---|
| jtds-1.2.8.jar | 793d8021b715bdf05fdbc6d46fb8e914 |
| jtds-1.3.0.jar | a0e43823e84f297f113ec60e33b1feba |
| jtds-1.3.1.jar | ac86cbf0426f28e7bdfb1ed1884bf583 |
Create a connection
To create a database connection, the following information is required:
- Connection name - The name you give to the connection
- System - The choice of database, given in the dropdown list
- User - The user of the database
- Password - The user's password
- URL Prefix - The URL of the database
- Host -
- Port - The port on which the database is available, e.g. 5432 for PostgreSQL
- Database -