You are viewing the RapidMiner Studio documentation for version 2024.0 - Check here for latest version
Database Connectors
SQL Connectors
Getting started: Learn how to create a connection object
Read more: Best practices
Via connection objects and the operators
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.
-
Assuming you're familiar with standard SQL or the SQL dialect for your database, you can send SQL queries directly to the database.
-
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.