You are viewing the RapidMiner Studio documentation for version 9.8 - Check here for latest version

Database Connectors

SQL Connectors

Via connection objects and the Operators Read Database, Write Database, and Update Database, RapidMiner Studio supports all relational database systems offering a fully compliant JDBC driver, including:

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

In-Database Processing

Performing various data transformations directly in a relational database system instead of transferring the entire dataset and doing those transformations locally can have multiple benefits:

reduced data transfer
leveraging the computing power and efficiency of the relational database system
ensuring the original data does not leave the relational database

The In-Database Processing extension enables Studio users to perform common data preparation and ETL tasks directly in the relational database. To do this, users can chain operators as they normally would in Studio, and the extension translates this into a complex SQL query that is then executed in the relational database system.

Currently it supports the following products:

MySQL
PostgreSQL
Microsoft SQL Server
Oracle
Google BigQuery

We are continuously adding support to other database vendors based on popular demand.

To start using In-Database Processing, you need to install the In-Database Processing Extension:

Install In-Database Processing Extension in Studio

View in the RapidMiner Marketplace

How to install extensions

NoSQL Connectors

Cassandra – connecting to and integrating your Cassandra account with RapidMiner Studio
MongoDB – connecting to and integrating your MongoDB account with RapidMiner Studio
Solr – connecting to and searching your Solr server with RapidMiner Studio
Splunk – connecting to and searching your Splunk server with RapidMiner Studio