Categories

Versions

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

Using the Dropbox Connector

The Dropbox Connector allows you to read and write to files in your Dropbox account directly from RapidMiner Studio. There is no need for the Dropbox desktop client to be installed on your machine. This document will walk you through how to:

The Dropbox Connector uses an authentication mechanism called OAuth 2.0. Instead of giving RapidMiner your username and password, you generate an access token that can be used by RapidMiner Studio to connect to your Dropbox account. This token cannot be used by any other applications and helps keep your Dropbox credentials secure.

Follow these steps to connect RapidMiner Studio to Dropbox:

Connect to your Dropbox account

  1. In RapidMiner Studio, select the new process icon New Process Icon to create a new process. Drag the Read Dropbox operator into the Process view, and click on the operator. In the Parameters view, click the Dropbox icon Dropbox icon to open the Manage Connections window.

    You can also open Manage Connections through Tools > Manage Connections.

  2. Click on Add connection Add Connection Icon in the lower left of the window, give a name to the new connection, and set Connection type to Dropbox icon Dropbox Connection:

  3. Click on Create IconCreate and select your new Dropbox connection.

  4. To the right of the access token field, click the Id Icon button to request an access token.

  5. Click on Request access token Website Icon to open the Dropbox website in your browser. If you are not already logged into your Dropbox account, you will have to do so now. You can manually copy the URL by clicking on Show URL instead.

  6. Click Allow to give RapidMiner access to your Dropbox account and to generate a token:

  7. Copy the access token:

  8. Return to RapidMiner Studio, enter the access token, and click Complete IconComplete:

  9. While not required, we recommend testing your new Dropbox connection by clicking the Connection Test IconTest button at the bottom of the Manage Connections window:

    If the test fails, check whether you copied the complete access token.

  10. Close the Manage Connections dialog by clicking on Save IconSave all changes.

You have successfully connected RapidMiner Studio to your Dropbox account. The next sections will show you how to use this connector to read and write files.

Browse and read files

Reading files from Dropbox is incredibly simple using the Dropbox Connector:

  1. Click on the Read Dropbox operator in the Process view. Select your Dropbox connection from the connection drop down menu in the operator parameters:

  2. Click on the file chooser button file chooser icon to view the files in your Dropbox account. Select the file that you want to load and click File Chooser IconOpen.

  3. Connect the output of Read Dropbox to a suitable operator. In this case, we selected a .XLS file, so we will connect the output to a Read Excel operator:

    As you can see in this example, the Read Dropbox operator works similarly to the Read File operator. It only loads the selected file, but does not process it. The actual processing of the data takes place in additional operators such as Read Excel, Read CSV, or Read XML.

Write files to your Dropbox account

The Write Dropbox operator works similarly to the Read File operator: it expects a file as input (provided by another operator) and stores it at the specified location in your Dropbox account.

The simplest example using the Write Dropbox operator would be to connect it to the output of Read Dropbox. This setup would simply copy a file from one location in your Dropbox account to another without changing the file itself.

We will configure the Write Dropbox operator from the end of the previous section.

  1. Click on the Write Dropbox operator, select your Dropbox connection in the Parameters view, and select a location for the new file via the file chooser File Chooser Icon. Note that by default the Write Dropbox operator does not overwrite existing files. Instead, a number is appended to the file name. For example, if Analysis_Results.xls already exists, the new file would be stored as Analysis_Results (1).xls. You can disable this feature by checking the overwrite parameter (visible in Expert Mode).

  2. Run Run Process the process and navigate to the location you specified. In the Dropbox online view, you can see that Analysis_Results.xls was successfully updated just a few seconds ago!

You should now see the new file stored via the Write Dropbox operator.