--- title: Integrating Hubspot and Custom ERP using SiddhiQL description: Integrating HubSpot with ERP, your business can effectively share data around sales history, shipping data and project information to capitalize on more opportunities. image: https://blog.e-zest.com/hubfs/Integrating%20Hubspot%20and%20custom%20ERP%20using%20SiddhiQL.png --- [![e-Zest logo\_An accion lab company\_Colour](https://blog.e-zest.com/hubfs/images/Logos%20with%20Tagline/Corporate/SVG/e-Zest%20logo_An%20accion%20lab%20company_Colour.svg "e-Zest logo_An accion lab company_Colour")](https://www.e-zest.com/) - [WORK](https://www.e-zest.com/our-work) - [SERVICES](https://www.e-zest.com/our-services) - [Product Engineering](https://www.e-zest.com/digital-product-engineering-services) - [Enterprise Data Services](https://www.e-zest.com/enterprise-data-services) - [Digital Commerce](https://www.e-zest.com/digital-commerce-services) - [Digital Operations](https://www.e-zest.com/digital-operations) - [Digital Consulting](https://www.e-zest.com/digital-transformation-consulting-services) - [Digital Experience Design](https://www.e-zest.com/digital-experience-design) - [INSIGHTS](https://blog.e-zest.com/) - [CAREERS](https://www.e-zest.com/careers) - [ENTERPRISE DATA SERVICES](https://www.e-zest.com/enterprise-data-services) - [GENERATIVE AI](https://www.e-zest.com/generative-ai) - [Healthcare](https://healthcare.e-zest.com) - [Contact Us](https://www.e-zest.com/contact-us) - ![Elevating Product Engineering with AI and ML](https://blog.e-zest.com/hubfs/Elevating%20Product%20Engineering%20with%20AI%20and%20ML.jpg) [BLOGS](https://blog.e-zest.com) #### Elevating Product Engineering with AI and ML As technology evolves and customer choices broaden, there is an increasing ... [Read more](https://blog.e-zest.com/elevating-product-engineering-with-ai-and-ml) - ![e-Zest – An Accion Labs Company gets Recognition as a Contender in the ISG Provider Lens™ Study on Digital Engineering Services 2024](https://blog.e-zest.com/hubfs/e-Zest%20%E2%80%93%20An%20Accion%20Labs%20Company%20-%20Gets%20Recognition%20as%20a%20Contender%20in%20the%20ISG%20Provider%20LensTM%20Study%20on%20Digital%20Engineering%20Services%202024.jpg) [NEWS](https://blog.e-zest.com/news) #### e-Zest – An Accion Labs Company gets Recognition as a Contender in the ISG Provider Lens™ Study on Digital Engineering Services 2024 We are delighted to announce that e-Zest – An Accion Labs Company has been ... [Read more](https://blog.e-zest.com/news/e-zest-an-accion-labs-company-gets-recognition-as-a-contender-in-the-isg-provider-lens-study-on-digital-engineering-services-2024) - ![e-Zest Solutions supports Digital Pune Mission](https://blog.e-zest.com/hubfs/blog-files/Digital%20Literacy%20Bus%20e-Zest.png) [CSR](https://blog.e-zest.com/csr) #### e-Zest Solutions supports Digital Pune Mission **Pune, India:** e-Zest Solutions, a leading digital technology innovation ... [Read more](https://blog.e-zest.com/csr/e-zest-solutions-supports-digital-pune-mission) - [Work](https://www.e-zest.com/our-work) - [Services](https://www.e-zest.com/our-services) - [Insights](https://blog.e-zest.com) - [Careers](https://www.e-zest.com/careers) - [Enterprise Data](https://www.e-zest.com/enterprise-data-services) - [Generative AI](https://www.e-zest.com/generative-ai) - [Innovations](https://www.e-zest.com/innovations) - [Healthcare](https://healthcare.e-zest.com) - [About](https://www.e-zest.com/about-us) - [Contact](https://www.e-zest.com/contact-us) - [Blog](https://blog.e-zest.com/) - [News](https://blog.e-zest.com/news) - [CSR](https://blog.e-zest.com/csr) - [![Linkedin Icon](https://blog.e-zest.com/hubfs/icons/linkedin_icon_white.svg)](https://www.linkedin.com/company/e-zest-solutions/) - [![Twitter Icon](https://blog.e-zest.com/hubfs/twitter-logo-silhouette%20(5).svg)](https://twitter.com/ezest) - [![Facebook Icon](https://blog.e-zest.com/hubfs/facebook-app-logo%20(4).svg)](https://www.facebook.com/61259256638) - [![Instagram Icon](https://blog.e-zest.com/hubfs/instagram-logo%20(4).svg)](https://www.instagram.com/ezestsolutions/) - [![Youtube Icon](https://blog.e-zest.com/hubfs/icons/youtube_icon_white.svg)](https://www.youtube.com/user/ezestcorporate) [![Go to top icon](https://blog.e-zest.com/hubfs/AA%20Assets/top%20button.svg)](https://blog.e-zest.com/integrating-hubspot-and-custom-erp-using-siddhiql#top) Hit enter to search or ESC to close Insights e-Zest members share technology ideas to foster digital transformation. - [Blog](https://blog.e-zest.com) - [Whitepaper](https://blog.e-zest.com/whitepaper) - [Playbook](https://blog.e-zest.com/playbook) - [News](https://blog.e-zest.com/news) - [Innovation](https://blog.e-zest.com/innovation) - [Media Kit](https://www.e-zest.com/media-kit) # Integrating Hubspot and Custom ERP using SiddhiQL [Pranav Shah](https://blog.e-zest.com/author/pranav-shah) Nov 28, 2018 [ERP](https://blog.e-zest.com/topic/erp) [HubSpot](https://blog.e-zest.com/topic/hubspot) [Enterprise CRM](https://blog.e-zest.com/topic/enterprise-crm) [SiddhiQL](https://blog.e-zest.com/topic/siddhiql) - - - - **What is Hubspot?** Hubspot is a CRM tool for use by marketing and sales departments, which track and manage interactions between a company and its customers. It also has other product to take care of content management, social media marketing, web analytics, and landing pages development. It is an efficient tool which can also integrate with Gmail and Microsoft Office. It is a cloud-based product which provides SaaS (Software as a Service). It can be considered as an entire marketing solution. ![hubspot-growth-stack](https://blog.e-zest.com/hs-fs/hubfs/hubspot-growth-stack.png?width=600&name=hubspot-growth-stack.png)*Image Courtesy: www.Hubspot.com* **What is a custom ERP?** Custom ERP is a project management tool which helps its users to plan, organize and manage resources. Across management levels from the CEO to team members down the chain, custom ERP is used to consume and enter the relevant information. Custom ERP need a backend database. It can be MS-SQL or MySQL or any other RDBMS. This database can be connected to Kafka - which is based on a publisher-subscriber model and can be used as a Kafka connector to custom ERP database. The integration of these two tools can be done by stream processing. Here comes in picture stream processing studio – SiddhiQL. **What is SiddhiQL?** SiddhiQL is a complex event processor designed to identify complex events in the stream, processes the complex events and notify them in real time. SiddhiQL can have input stream events right from HTTP, Kafka, TCP, in-memory, WSO2Event, e-mail, JMS, file, RabbitMQ, MQTT, WebSocket, Twitter and Amazon SQS. Basically, SiddhiQL can accept event inputs from many different types of sources, process it to generate insights and publish them to many types of a sink. In our case, Kafka source of SiddhiQL is used to identify the complex stream coming from Kafka connector connected to custom ERP database. The stream contains the data in the payload that could be of created through the new project, milestones – which can be achieved in a project or any other functionality in which custom ERP works. SiddhiQL identifies the required events from Kafka source and it will send that particular event from Kafka stream to Hubspot. Sample SiddhiQL snippet for identifying an event from Kafka is as follows: `@App:name("HelloKafka")``@source(type='kafka', topic.list='kafka_topic', partition.no.list='0', threading.option='single.thread', group.id="group", bootstrap.servers='localhost:9092', @map(type='json'))``define stream SweetProductionStream (projectCode string, projectName string, totalBid int, expectedDuration int, expectedStartDate string, expectedEndDate string, over bool);` **HubAPI:** Hubspot supports API through which deals, companies, contact can be created, updated and deleted. Various APIs can be called to Hubspot; basically, in two ways – using unique Hapikey in URL of API call and OAuth 2.0. In our case, we will be using Hapikey of Hubspot account. Some of the APIs include: ![hubspot-API](https://blog.e-zest.com/hs-fs/hubfs/hubspot-API.png?width=600&name=hubspot-API.png) **Workflow:** In a custom ERP, the project milestones can be created through simple steps. Similarly, milestones can be created as a custom deal property in Hubspot which offers flexibility to create custom properties as we need. As ERP has backend database in some RDBMS, it provides different views from which project tables are created. One such view is Milestone view which contains fields like milestone name, project name, milestone amount and other required details. Kafka can be connected to this ERP RDBMS database view. This access provides the integration of source Kafka and SiddhiQL that will identify the project update stream and pass it to the extension program which eventually is intended to update deal related to that project. ![hubspot-custom-erp-integration.tif](https://blog.e-zest.com/hs-fs/hubfs/hubspot-custom-erp-integration.tif.png?width=468&name=hubspot-custom-erp-integration.tif.png) *Workflow for integration of custom ERP and Hubspot* As the stream is received in the extension program, it will check for current values of a milestone received in the database. The steps included for updating a milestone or creating a new milestone in Hubspot include: - SiddhiQL identifies events from a custom ERP - Get all deals APIs from which dealId is extracted - Using dealId call to get a deal API from which initial milestones and their values can be identified - Form JSON for updated milestone amount and total deal amount - Update the deal with payload in JSON using deal API Sample update a deal API can be as follows: Example URL: [https://api.hubapi.com/deals/v1/deal/19320611?Hapikey=demo](https://api.hubapi.com/deals/v1/deal/19320611?Hapikey=demo) Note: Your "content-type" must be application/JSON. Example deal update JSON: { "properties": \[ { "name": "amount", "value": "70000" } \] } As SiddhiQL application can be kept running, this enables changes from a custom ERP to be reflected in Hubspot in real time. Vice-versa, data from Hubspot can also be reflected in Whizible in real time. This ensures total integration of the CRM application and project management tool. The system is made to withstand various scenarios like: - Alert notification via email when the project is not present in Hubspot - Total deal amount equals to the sum of all milestone amount - Notifications in Hubspot when a deal is updated via API - Upon successful updating, the event can be replicated in another Kafka topic or any other source/sink Thus, integration of Hubspot and custom ERP can prove to be helpful for a company using it as it maintains the integrity of both the systems. - - - ### Similar Blog [![Automation of supply chain management for manufacturing organisations](https://blog.e-zest.com/hubfs/sonal-automation-of-scm-for-manufacturing-organisations-20170905.png) Automation of supply chain management for manufacturing organisations In today’s world managing the supply chain including the day to day operations has become one of the biggest challenge for ... By Aditya Dharmadhikari Sep 07, 2017](https://blog.e-zest.com/automation-of-supply-chain-management-for-manufacturing-organisations) [Keep Tuning the Product Going by the intense competition in the market, it has become all the more vital for a product to perform better and have ... By Teena Gupta Feb 26, 2014](https://blog.e-zest.com/keep-tuning-the-product/) [Tech Digest – Week 33, 2012 **Sibal for impetus to cloud computing** By Corporate Aug 17, 2012](https://blog.e-zest.com/tech-digest-week-33-2012/) [Creating Business Value with ERP In the last decade, ERP (Enterprise Resource Planning) have exploded into the global business landscape. The economic downturn ... By Abha Kastwar Jul 22, 2010](https://blog.e-zest.com/creating-business-value-with-erp/) ## Helping Organizations Thrive in the Digital Age [Contact Us](https://www.e-zest.com/contact-us) - [About](https://www.e-zest.com/about-us) - [Services](https://www.e-zest.com/our-services) - [Work](https://www.e-zest.com/our-work) - [Insights](https://blog.e-zest.com/) - [Healthcare](https://healthcare.e-zest.com/) - [Accion Labs](https://www.accionlabs.com/) - - - - - - Dallas - Detroit - Hannover - Vienna - London - Pune © 2025 e-Zest Solutions - [Privacy Policy](https://www.e-zest.com/privacypolicy) - [Cookie Policy](https://www.e-zest.com/cookie-policy) Contact us Contact us e-Zest is a leading digital innovation partner for enterprises and technology companies that utilizes emerging technologies for creating engaging customers experiences. Being a customer-focused and technology-driven company, it always helps clients in crafting holistic business value for their software development efforts. It offers software development and consulting services for cloud computing, enterprise mobility, big data and analytics, user experience and digital commerce.