1. Documentation
2. 2024.0 (Latest) 10.3 10.2 10.1 10.0 9.10 9.9 9.8 9.7 9.6 9.5 9.4 9.3 9.2 9.1 9.0 8.2 8.1 8.0 7.6
3. Studio
4. Connect
5. Database Connectors

Database Connectors

SQL Connectors

Via connection objects and the operators

• Read Database,
• Write Database, and
• Update Database,

Altair AI Studio supports all relational database systems offering a fully compliant JDBC driver, including:

• AccessDB
• HSQLDB
• Microsoft SQL Server (JTDS / Microsoft)
• MySQL
• Oracle
• PostgreSQL
• Sybase

Aside from the operators mentioned above, and as discussed in more detail in Best practices, there are two possible approaches to interacting with the database.

1. Execute SQL

   Assuming you're familiar with standard SQL or the SQL dialect for your database, you can send SQL queries directly to the database.

2. In-Database Processing

   If you're more familiar with Altair RapidMiner operators than SQL, you can create a subprocess in the In Database Nest that will automatically be converted to SQL.