Zoho Integration Case study

Zoho SQL Server integration

It is imperative for today’s global business processes to be in sync with the latest in technologies. In doing so IT systems are constantly changing and there is a need to migrate as seamlessly as possible— but not at the cost of production outages. In this case study we discuss

  • How we created a custom integration with the ZOHO system to map to an existing SQL server to migrate from one CRM application to another
  • Right questions to ask to the client before start of any integration project
  •  Digging deeper to discover more questions
  • Finally creating the application and using Windows Service to run the application automatically. 

Solution

We used the standard Zoho APIs to create the integration when an order was created from SQL server to update Zoho. We did field mapping between 2 systems to create below transactions in ZOHO

  • Create Customer
  • Create Product
  • Link Multiple products to customer
  • Finally Create Sales order

Challenges

We realized some technical issues and also some integration related scenarios that we got stuck with

  • Zoho library keeps giving request time out errors to connect to the APIs after few API calls.
  • We figured out that if we run JSFiddler then library works perfectly and found there’s an open issue in Zoho library where connection is not closed after API calls.
  • We created a windows service application to keep the integration running and which will check in the database for any new orders and then create the newly created orders in Zoho.
Please fill in the details to download the case study.

    Results

    Accomplishments

    Deliverables
    Application deployed on Windows server in client's environment which runs the integration near real time

    Other Case Studies

    • All
    • Case Study
    Case Study Machineroad

    Read more about how we integrated SAP with HubSpot APIS for one of our clients.

    We integrated the solution design to match the requirement and made it configurable to run for multiple clients on Hubspot.

    Read More →
    SAP Integration with 3rd Party – REST, WSDL based

    Read more to understand how we help clients to move to cloud from their existing system landscape. For instance, how we helped one of our clients to move their website hosted in WordPress to Azure. 

    Read More →
    Mailchimp Automation

    Read more about how Mailchimp can be used effectively and to manage your email channels and create automation using email to move your lead ahead in the buyer journey.

    Download the checklist to know more.

    Read More →
    Image Processing

    Read more about how we implemented an image processing application and did OCR and added algorithms to improve accuracy.

    Read More →
    Zoho Integration Case Study

    This case study Talks about how we integrated SQL server data to migrate to a New Zoho instance. It helps to save a lot of data migration and manual effort as we created the integration to use the existing APIs
    Read more to find out

    Read More →
    Power BI integration with Quickbooks

    Read about how we successfully integrated QuickBooks(an accounting software) with Power BI to generate custom reports and visualize updated data real time.

    Read More →