Skip to main content
Version: v0.7.x

Import Oracle data

This tutorial guides you through importing an Oracle database into your H2O Drive workspace. Follow the steps below to connect to your datasource and import the data.

Prerequisites​

Before you begin, you will need:

  • Access credentials to your Oracle database

Step 1: connect the database​

Let's connect to your Oracle database.

  1. On the H2O Drive home page, click Import.
  2. Select Oracle from the dropdown list of sources.
  3. If you have not added a credentials profile already, click Add New Credentials.
  4. Enter the following details to connect to the PostgreSQL database.
    • Profile Name: A suitable name for your personal credentials profile. This is the name that will appear on the dropdown list (which you saw on the previous screen) when you are selecting the credentials profile you wish to use.
    • User: The username used to access the database.
    • Password: The password credential used to access the database.
    • Database: The name of the database.
    • Port: The port number on which the database instance is running.
    • Server: The server IP address on which the database instance is running.
      note

      For more information, see Connecting to Oracle Database in the Oracle documentation.

      import-oracle-data
  5. Click Save.
  6. Select the credentials profile that you just created from the dropdown list and click Next. select-credentials

Step 2: select the data tables​

  1. Select the data table that you wish to import. Optionally, you can also enter an SQL Query to specify the exact columns or rows of the datatable that you want to import. select-data-table
  2. Enter a filename for the table so that you will be able to easily identify it on your H2O Drive workspace later.
  3. Click Next. You have successfully imported a dataset! You should now be able to see it displayed on H2O Drive under the specified filename. imported-dataset

Step 3: share the dataset​

  1. Select the imported dataset by clicking on the filename.
  2. Click Get Link to get a pre-signed link that you can share with other users or applications that need to access this dataset.
  3. Set the expiration time and click Get Link. set-expiry-time
  4. Copy the link that appears and click Close. You can now use the copied link to share this dataset.

You can import this dataset using the pre-signed link to H2O-3, Driverless AI, or share it with someone else who can then import it onto their H2O Drive instance using the HTTP download option.

Feedback