Select a visualization style and add it to the report.If needed, modify columns, click Create Report, and add the data source to the report.Use your instance name ( myinstance in CONNECT_SERVER_URL), username, and password to connect to your Connect Server instance.Authorize the Connector to connect to an external service (your Connect Server instance).Log into Google Data Studio, click data sources, create a new data source, and choose CData Connect Server Connector.The steps below outline connecting to CData Connect Server from Google Data Studio to create a new Microsoft OneDrive data source and build a simple visualization from the data. Visualize Live Microsoft OneDrive Data in Google Data Studio With the virtual database created, you are ready to connect to Microsoft OneDrive data from Google Data Studio. Click Privileges -> Add and add the new user (or an existing user) with the appropriate permissions.See the OAuth section of the Help documentation for an authentication guide. To authenticate using OAuth, you will need to create an app to obtain the OAuthClientId, OAuthClientSecret, and CallbackURL connection properties. OneDrive uses the OAuth authentication standard. Select 'Microsoft OneDrive' from Available Data Sources.Įnter the necessary authentication properties to connect to Microsoft OneDrive.Log into Connect Server and click Databases.

Connect to Microsoft OneDrive from Connect ServerĬData Connect Server uses a straightforward, point-and-click interface to connect to data sources and generate APIs. Get more information on the CData Connect Server and sign up for a free trial at. This article requires a CData Connect Server instance and the CData Connect Server Connector for Google Data Studio.

Sign out of one drive microsoft