Connect to OneDrive with SSIS


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



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. Select one of Accounts in this organizational directory only as the supported account type to access data in your company.

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

  8. In nearby textbox, enter as Redirect URI or any other valid redirect URL, e.g.,

  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:
  1. Generate the token and click OK to save the configuration.

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


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


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


You can check our connector OneDrive article here.