SELECT Name, Size FROM Files ORDER BY Size Write a SQL query based on the virtual database, e.g.Use the "Write SQL" tool to retrieve the Office 365 data.Once you configure the connection to CData Connect, you can query Office 365 and build visualizations. Click to Use a secure connection (SSL) Query Office 365 Data with Metabase.Password: The password for the above CData Connect user.Database name: The name of the virtual database you just created (e.g.Port: The port of the MySQL endpoint for your Connect instance (e.g.Host: The URL of your Connect instance (e.g.Configure the connection to CData Connect and click "Save".Navigate to the administration screen (Settings -> Admin) and click "Add Database" from the "Databases" tab.Use the MySQL interface to connect to CData Connect. Click Privileges -> Add and add the new user (or an existing user) with the appropriate permissions.Īfter creating the virtual database, navigate to your Metabase instance.See the "Getting Started" chapter of the help documentation for a guide to using OAuth. To authenticate requests, you will need to obtain the OAuthClientId, OAuthClientSecret, and OAuthCallbackURL by registering an app with Office 365. Office 365 uses the OAuth authentication standard. Select "Office 365" from Available Data Sources.Įnter the necessary authentication properties to connect to Office 365. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |