Excel Add-In for OneDrive

Build 20.0.7695

Establishing a Connection

Configure a Connection Profile

From the CData ribbon, click Get Data and select From OneDrive to launch the CData Query window. To setup your connection, you will have to click the Select button. Here you can set the connection settings, test the connection, and save the connection profile.

Authenticating to OneDrive

OneDrive uses the OAuth authentication standard. To authenticate using OAuth, you will need to create an app to obtain the OAuthClientId, OAuthClientSecret, and CallbackURL connection properties. See Using OAuth Authentication for an authentication guide.

Authenticating using MSI Authentication

If you are running OneDrive on an Azure VM, you can leverage Managed Service Identity (MSI) credentials to connect:

  • AuthScheme: Set this to AzureMSI.

The MSI credentials will then be automatically obtained for authentication.

Connection Properties

The Connection properties describe the various options that can be used to establish a connection.

Managing Connections

After successfully authenticating to OneDrive you will be able to customize the data you are importing. To learn more about this, see Managing Connections.

See Also

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7695