RapidMiner

This article explains how to connect RapidMiner to an Exasol database and import data from Exasol to RapidMiner.

RapidMiner allows you to create visual workflows using data from an Exasol database. RapidMiner can be integrated with Exasol using the Exasol JDBC connector.

For more information about RapidMiner, see RapidMiner Documentation.

Exasol takes no responsibility for changes in functionality or terms of use for third-party tools. For more details about the compatibility and use of these tools with Exasol, refer to the respective software vendor’s website.

Environment

The following procedure uses RapidMiner Studio 9.7 for Windows.

Prerequisites

  • Your Exasol SaaS database must be running. For more information, see Database Management.

  • The IP address of the host where the tool is running must be in the allowed IP address list. For more information, see Network Security.

  • Exasol JDBC driver is installed
  • RapidMiner Studio is installed

Get JDBC Driver and Connection Details

To connect to your Exasol SaaS database from a tool you need a valid connection string. You must also allow network access to the database from the tool, and make sure that the latest Exasol JDBC driver is installed.

  1. On the Databases page in the web console, click on Connect via tools on the cluster that you want to connect to.

    connect via tools

  2. In the wizard, enter the IP address of the client or server that will connect to the database and click Add IP, then click Next. This will add the IP address to the list of IP addresses that are allowed network access to the cluster. The allow list is found on the Security page in the web console. For more information, see Network Security.

    If the IP address is already present in the allow list, just click Next.

    enter ip address

  3. If the latest JDBC driver for your operating system is not already installed, select the driver type and operating system and click on Download to download the latest driver to your local system. For more information about how to install the driver, see JDBC Driver.

    download driver

  4. Click on Next to view your connection details:

    connection details

  5. Copy the Connection string, Port, and User name values from the Connect details dialog. You will need to enter these details in the tool that should connect to the Exasol SaaS database.

  6. To generate a new Personal Access Token (PAT) to use for authentication in the client, click on the Password row, then click on Copy to copy the PAT to your clipboard. For more information, see Personal Access Token.

    generated pat

    The generated PAT is only shown once and cannot be retrieved after you have closed the wizard.

  7. Click on Done to close the wizard.

Connect RapidMiner to Exasol

  1. In the Repository tab, right-click Local Repository and select Create Connection. Alternately, select Create Connection in the Connections menu.
  2. In the Create a new connection dialog, select Database as a connection type, provide a name for the connection, and click Create.

  3. In the Edit connection dialog, enter the following details in Setup tab:

    • Database system: Select Custom (configure in Driver tab) option from this drop-down. This will let you configure the Exasol JDBC driver in the driver tab later.
    • User: The username for the database user.
    • Password: The personal access token for the database user.
    • Configure URL Manually: Select this option and enter the connection string that you copied from the Connect details.

  4. In the Driver tab of Edit connection dialog, locate the Exasol JDBC driver .jar file by specifying the path for the file.

  5. Click Test connection to verify a successful connection to Exasol database and then click Save.

Load Data into RapidMiner

Follow these steps to load data into RapidMiner from Exasol database: 

  1. In the Repository tab, click Import Data button. Alternately, select Import Data from the File menu.

  2. In the Import Data - Where is your data? dialog, select Database.
  3. In the Import Data - Select the data location dialog, select the Exasol database connection that you created in Connect RapidMiner to Exasol and click Next.
  4. In the Import Data - Build a query to create a data table dialog, select the table, attributes, and where clause and click Next.

  5. In the Import Data - Where to store the data? dialog, select the location, specify a name for the data table, and click Finish.
    The data will be imported from Exasol to RapidMiner Studio.