Connecting to Azure Data Lake Storage

Azure Data Lake Storage is a cloud-based file storage and management facility designed for big data. You can use the Azure Data Lake Storage data connector to import your organization's Azure data.

Before you start

Before you start the connection process, review the Windows DSN Configuration section in the CData documentation, and gather any connection prerequisites such as user name, password, token, or key values.

For help gathering the connection prerequisites, contact the Azure Data Lake Storage administrator in your organization. If your administrator cannot help you, you or your administrator should contact Azure Data Lake Storage Support.

Connection properties

Beyond basic connectivity and authentication, you can configure additional properties of the connection to the data source. For more information, see Connection Properties in the CData documentation.

Create an Azure Data Lake Storage connection

1. From the Analytics main menu, select Import > Database and application.
2. From the New Connections tab, in the ACL DSN Connectors (Bundled) section, select Azure Data Lake Storage.

   Tip

   You can filter the list of available connectors by entering a search string in the Filter connections box. Connectors are listed alphabetically.

   The DSN Configuration dialog box appears.

3. In the DSN Configuration dialog box, click Show Required.
4. Provide values for the required fields, if any.
5. Click Test Connection.

   Note

   When you click the Test Connection button, it validates whether the connection and authentication details provided are correct. If you click OK without clicking Test Connection, the connection details are saved without any validation and may not work later if the values provided are incorrect.

   The log-in page for Azure Data Lake Storage appears.

6. Provide the connection details and authenticate your log-in.

   When the connection is successful, a dialog box opens displaying a success message.

7. Click OK in the dialog box that appears.

   The connection to Azure Data Lake Storage is established successfully.

8. In the DSN Configuration dialog box, click OK.

The connection for Azure Data Lake Storage is saved to the Existing Connections tab. In the future, you can reconnect to Azure Data Lake Storage from the saved connection.

Once the connection is established, the Data Access window opens to the Staging Area and you can begin importing data. For help importing data from Azure Data Lake Storage, see Working with the Data Access window.

Rename the connection

When you create the Azure Data Lake Storage data connector, you cannot provide a Connection name of your choice and the connection is saved to the Existing Connections tab with the same name as your data source. If you want to rename it, navigate to the Existing Connections tab, expand the ACL Connectors (DSN) section, click the ellipsis icon corresponding to Azure Data Lake Storage and select Rename connection.