RapidMiner

Learn 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, refer to the 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

  • RapidMiner Studio must be installed.

  • The Exasol JDBC driver must be installed. To learn more, see JDBC Driver.

  • Your Exasol database must be running and reachable from the environment where the tool is used.

Exasol SaaS

  • The IP address of the host where the tool is running must be in the allowed IP address list in Exasol SaaS. To learn how to allow traffic to your database, see Network security (SaaS).

  • To connect the tool to an Exasol SaaS cluster you will need the connection string and a personal access token (PAT) for authentication. To learn how to get the connection details, see Connect to Exasol SaaS.

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 the Custom (configure in Driver tab) option. This will let you configure the Exasol JDBC driver in the driver tab later.

    • User: The username of the Exasol user.

    • Password: The password of the Exasol user.

      For Exasol SaaS, use a valid personal access token as password.

    • Configure URL Manually: Select this option and enter the following details:

    • Host: The URL for the Exasol database.

      For example: jdbc:exa:192.168.6.11..14:8563

      To learn about supported URL structures for the JDBC driver, see Exasol URL.

      For Exasol SaaS, use the connection string provided in the web console as hostname.

    • User: The username of the Exasol user.

    • Password: The password of the Exasol user.

      For Exasol SaaS, use a valid personal access token as password.

  4. In the Driver tab, select the Exasol JDBC driver .jar file.

  5. Click Test connection to verify that the connection works, then click Save.

    If the connection test fails, check the connection string and authentication details.

To learn how to use RapidMiner with Exasol, refer to the RapidMiner Documentation.