How to copy Zoom data to SQL Server in SSIS


This article guides you through connecting to Zoom API in SSIS


  • SSIS PowerPack: Download and install the ZappySys SSIS PowerPack from Here.

  • Have a Zoom account:


Create/Select an App in Zoom Marketplace Portal:

  1. Go to Zoom Marketplace Portal and sign in there.

  2. If you have a created app, click on manage, select the created app, and skip to the final step.
    Note: Make sure it is an OAuth Type App

  3. Once you successfully log in, select the “Build Legacy App” option from the Develop dropdown at the top left of the page.

  4. Click on Create button of OAuth panel section of page.

  5. Enter the name for your application and choose the app type (Recommended “Account-Level App”) option for your API

  6. Then proceed with clicking the Create button.

  7. In Redirect URL for OAuth enter this as Redirect URI and add it to allow lists.

  8. In the scope tab, select the scopes you need

  9. Save the Client ID and Client Secret

Connect with Zoom 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 Zoom connector. Press Continue for the next step.

  4. Fill in the connector fields, including Client ID, Client Secret, and the scopes.

  5. Generate the token and click OK to save the configuration.

  6. 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 Zoom 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


You can check our connector Zoom article here.