Connect to OneDrive with SSIS

[daniel]

Introduction

This article will show you how to connect to OneDrive with our connector inside SSIS.

Prerequisites

• SSIS PowerPack: Download and install the ZappySys SSIS PowerPack from the Customer Download Area or trial version
• Get a Microsoft account:

Steps

Create an Application from the OneDrive side

1. Go to Azure Portal and login there.

2. Then go to Azure Active Directory.

3. On the left side, click menu item App registrations

4. Then proceed with clicking New registration.

5. Enter a name for your application.

6. To access data in your company, select one of Accounts in this organizational directory only as the supported account type.

7. In Redirect URI section leave option selected at Web.

8. In nearby textbox, enter https://login.microsoftonline.com/common/oauth2/nativeclient as Redirect URI or any other valid redirect URL, e.g., https://zappysys.com/oauth

9. Use this Redirect URI in the Redirect URL grid row.

10. Copy Application (client) ID, TenantID, Secret ID From your App configuration
    

    

Connect with OneDrive connector in SSIS:

1. Drag and drop a Data Flow task in your SSIS package.
2. Inside the Data Flow, add an API Source component.
3. Create a new connection within the API Source, and choose the OneDrive connector. Press Continue for the next step.
4. Fill in the connector fields: Client ID and Client Secret. For the Authorization URL and Token URL, you can use these URLs:

  * https://login.microsoftonline.com/daed1250-xxxx-xxxx-xxxx-ef0a982d3d1e/oauth2/v2.0/authorize
  * https://login.microsoftonline.com/daed1250-xxxx-xxxx-xxxx-ef0a982d3d1e/oauth2/v2.0/token
  * https://login.microsoftonline.com/common/oauth2/v2.0/authorize
  * https://login.microsoftonline.com/common/oauth2/v2.0/token

5. Generate the token and click OK to save the configuration.
   !Outlook Connector|690x493](upload://1gYMpTCRSs1AO0fc0aAFXBKreTb.png)

6. Select a table/endpoint and preview the data.
   

   

Video tutorial

SSIS API Source - Read data from popular API Data Sources using predefined Connector File

Considerations

Save the credentials so you do not have to search in your account every time.

Conclusion

Following these steps, you can seamlessly connect to OneDrive CRM within SSIS, utilizing the ZappySys tool for efficient data retrieval and integration. If you encounter any issues or need further assistance, you can contact our support team via chat on our website or through email at support@zappysys.com.

References

You can check our connector OneDrive article here.