Skip to main content
Version: v0.7.x

Import MS SQL Server data

This tutorial guides you through importing data from MS SQL Server into your H2O Drive workspace. Follow the steps below to connect to your data source and import the data.

Prerequisites​

Before you begin, you will need:

  • Access credentials to your MS SQL database

Step 1: connect the database​

Let's connect to your MS SQL database.

  1. On the H2O Drive home page, click Import.
  2. Select MS SQL Server from the drop-down 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 Redshift database.
    • Profile Name: A suitable name for your personal credentials profile. This is the name that will appear on the drop-down list (which you saw on the previous screen) when you are selecting the credentials profile you want 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 connection URL to the database.
      note

      For more information, see SQL Connection String in the Microsoft documentation.

      import-mssql-data
  5. Click Save.

Step 2: select the data tables​

  1. Select the credentials profile that you just created from the drop-down list.
  2. Enter an SQL Query to indicate the exact data and the data table that you want to import. Then, enter a name for your file so you can easily identify it on your Drive workspace later. select-credentials
  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