Connecting to Zoho CRM with SSIS


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



Create an Application from Zoho’s side

  1. Go to Zoho API Console

  2. Click Add Client link

  3. Select Server-based Applications option

  4. Enter the desired client name (Display purpose only)

  5. Enter some URLs for the Company homepage

  6. For Authorized Redirect URI, enter (Or enter your own, but we recommend using ZappySys one if possible). This URL must match the Zoho Connector UI.

  7. Click CREATE.
    Creating an App in Zoho

  8. Copy the Client ID and Client Secret
    Zoho credentials

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

  4. Fill in the connector fields: Client ID and Client Secret

  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 Zoho 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 Zoho CRM article here.