Azure data studio odbc how to#
See the property for more information on how to acquire this.
To authenticate against a Gen 1 DataLakeStore account, the following properties are required: Add a description, a duration, and take note of the generated key. At a minimum, "Azure Data Lake" and "Windows Azure Service Management API" are required. Select "Required permissions" and change the required permissions for this app.Select Web app for the type of application you want to create. Provide a name and URL for the application.Sign in to your Azure Account through the.Gen 1 uses OAuth 2.0 in Azure AD for authentication.įor this, an Active Directory web application is required. Authenticating to a Gen 1 DataLakeStore Account Information for connecting to Azure Data Lake Storage follows, along with different instructions for configuring a DSN in Windows and Linux environments. You can also create the database link and execute queries from SQL Developer.Ĭonnect to Azure Data Lake Storage as an ODBC Data Source
This article shows how to use the CData ODBC Driver for Azure Data Lake Storage to create a database link from Azure Data Lake Storage to Oracle and to query Azure Data Lake Storage data through the SQL*Plus tool. The Oracle Database Gateway for ODBC and Heterogeneous Services technology enable you to connect to ODBC data sources as remote Oracle databases.
0 kommentar(er)
