SSIS Components for OneNote

Build 21.0.7930

Establishing a Connection

Connecting with the OneNote Connection Manager

Adding a new OneNote connection to the SSIS package is straightforward. Right-click within the Connection Manager window and select New Connection from the menu. Then, choose the OneNote Connection Manager from the Add SSIS Connection Manager window.

Alternatively, you can create a new connection directly using the OneNote Source or the OneNote Destination. You can set the connection properties in the OneNote Connection Manager window.

Authenticating to OneNote

OneNote 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 Azure AD

Azure AD is a connection type that goes through OAuth. Set your AuthScheme to AzureAD and see Using OAuth Authentication for an authentication guide.

Authenticating using Azure Service Principal

Azure Service Principal is a connection type that goes through OAuth. Set your AuthScheme to AzureServicePrincipal and see Using Azure Service Principal Authentication for an authentication guide.

Authenticating using MSI Authentication

If you are running OneNote 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.

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