Directory: Set this to the path which will be used to store the replicated file.See the property for more information on how to acquire this. OAuthClientSecret: Set this to the key generated for the app you created.OAuthClientId: Set this to the application Id of the app you created.Account: Set this to the name of the account.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. You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs.Īuthenticating to a Gen 1 DataLakeStore Account ![]() This is the last step of the driver installation. ![]() If you have not already, first specify connection properties in an ODBC DSN (data source name). You can then work with Azure Data Lake Storage data just as you would a linked SQL Server instance.Ĭonnect to Azure Data Lake Storage as an ODBC Data Source After you have started the service, you can use the UI in SQL Server Management Studio or call stored procedures to create the linked server. You can use the SQL Gateway to configure a TDS (SQL Server) remoting service and set up a linked server for Azure Data Lake Storage data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |