SAP integaration with Hubspot
SAP integaration with Hubspot
This case study explores the features & challenges of migrating from Azure Dataverse to Azure blob Storage under Microsoft Dynamics Support.
Implementation
About Client
- https://www.bac.co/
- Location: Sydney, NSW
Project Background
This case study has details about how we designed and developed the integration of SAP with
HubSpot system. In this case study, we list the APIs we used and how we enabled initial and
delta load, including the configuration we did in HubSpot. Overall, a new DB instance needs to be created (DB-2) that will take data from DB-1 (based on some pre-defined business rules) and feed selective data into the HubSpot CRM instance.
This new database must be created from the client’s existing SAP Central Management System (CMS) instance. The new database needs to comply with the existing pre-defined entity-relationship model. The initial data dump will happen from the CMS to the new database (as shown below).
Also required is syncing batch routines to sync to the said database with SAP post-dump. Finally, this new database needs to be integrated into HubSpot. To list down the objectives:
- Ability to send initial and delta load in the Hubspot system
- Send Contacts, Organizations, and deals data to Hubspot
Scope & Requirement
- SAP Integration with Hubspot APIS
- Integrate solution design to match the requirement
- Make it configurable to run for multiple clients on Hubspot
- Integrate it via a scheduler to run as a Batch Job can be done via Logic Apps, Cron Jobs etc.
- Get the data synced to Hubspot daily for contacts, Companies and Deals
Implementation
Technology and Architecture
Technology
- The migration was deployed with the below technological component
- For Azure Dataverse- The underlying technology used was Azure SQL Database
- For Azure Blob Storage- It supported the most popular development frameworks including Java, .NET, Python & Node.js
Security & Compliance:
- Tagging Policies
- Azure config for compliance checks
- NIST compliance
- Guardrails
- Security Hub
Backup and Recovery
- Azure Backup provided a simple, secure, cost-effective, and cloud-based backup solution to protect the business or application-critical data stored in Azure Blob in two ways- Continuous backups & Periodic backups
Network Architecture
- Site to Site VPN Architecture using Transit Gateway
- Distributed Azure Network Firewall
- Monitoring with Cloud Watch and VPC flow logs.
Cost Optimization
- Alerts and notifications are configured in the Azure cost
Code Management, Deployment
- Cloudformation scripts for creating stacksets and scripts for generating Azure services was handed over to the client
Challenges
- We encountered some issues as below:
- Ensure the data is correct as the Contact, company and deals may have mandatory fields which needs to be filled in to ensure that it does not fail when creating the record via API Example name is mandatory for Person
- Ensure the Daily Quota Limit for the API is within the threshold if there are more records to be created it would need to be spaced out.
- Since the calculated field value was dependent on todays date so even if there was no update on the customer but the last order date remained the same we had to run a delta load as a script to update all Contacts records because days since last sale would have been T+1 each day.
- The integration was placed in VPN so we were not sure if It is going to run unattended or not it initially kept crashing but later we were able to move it to a stable zone within the network so it could run 24*7
Project Completion
Duration
Deliverables
- Integration code base
- SAP system integrated with HubSpot
- Batch scheduled to run daily and real time for some scenarios
- Initial Data Loading
Support
- We helped Customer to get the systems integrated using which they could do better lead management based on analytics in HubSpot
- The integration ran without any issues after Go live and we provided support of 2 weeks
- Same code based was used by the client to integrate multiple other similar customers they had
Testimonial
building Manager Bacpartners
Next Phase
If You Are Looking For Similar Services? Please Get In Touch
Testimonial
Peritos is a team of highly skilled developers, technical experts, and delivery managers. We’ve been very impressed with their commitment. Their developers and delivery managers have conducted themselves with professionalism and diligence at all times, and the quality of the work they have performed has been excellent. Many times, they proposed better solutions, which resulted in better and faster products. Peritos is a reliable AWS Partner. You can trust and be satisfied.
“We are very happy with the results of this major IT project with Peritos Solutions. Their staff gained a good knowledge of our business and processes. They were able to work with many of our diverse team members and launch Business Central ERP on time and on budget according to our requirements. We will be using them again for future projects and additional development actions. Thank you!”
The project was completed on time and as per the agreed budget. The communication was excellent, as was the dedication to quickly turning around the required report development. The overall experience was good, and I would definitely work with the Peritos Team again.
Share us
Get A Quote
Proud projects that
make us stand out
Recent Home
Recent Home
Recent Home
Recent Home
Thinking about a project? Get in touch with us.
Connect with Us Today through the Details Below or Fill
Out the Form for a Prompt Response
Book Free Consultation
Guaranteed response within 8 business hours.
Trusted by Startups and Fortune 500 companies
We can handle projects of all complexities.
Startups to Fortune 500, we have worked with all.
Top 1% industry talent to ensure your digital success.
SAP Support Services-Development & Consulting for Big4
SAP Support Services-Development & Consulting for Big4
Take a look at the summary of our contractors' work delivering SAP support services for Big4 clients across different projects.
Implementation
About Client
The Big Four consists of Deloitte, Ernst & Young (EY), KPMG, and PricewaterhouseCoopers (PwC), and are the largest professional services networks in the world in terms of revenue. They are usually grouped because of their comparable size and ability to offer clients a wide range of professional services. These firms are also considered attractive for those pursuing a career in professional services, mainly accounting, due to their frequent engagement with Fortune 500 companies. The Big Four provides clients with various services, including audit, assurance, taxation, management consulting, valuation, market research, actuarial, corporate finance, and legal services. It’s worth noting that a significant majority of public company audits, as well as many private company audits, are conducted by these four networks. We assisted the client with setting up different SAP support services.
Project Background
With sound experience in SAP support services, we deeply understand the technology and how to apply it to our client’s needs. We provided guidance and a detailed plan to revolutionize businesses and streamline processes. Our end-to-end services create, implement, and integrate software, solutions, and strategies within your established infrastructure. We use best-practice solutions to ensure lasting success, including Enterprise & Solution Architecture, Application Implementation & System Integration, Custom Development & Application Extension, Application Design & User Experience, Template Creation & Rollout Delivery, and Transition & Landscape Transformation.
Scope & Requirement
- ABAP development RICEF objects
- Adobe form customizations
- Ongoing support
- Automation
- API based integration
Implementation
Technology and Architecture
Technology
- The migration was deployed with the below technological component
- For Azure Dataverse-
- The underlying technology used was Azure SQL Database
- For Azure Blob Storage- It supported the most popular development frameworks including Java, .NET, Python & Node.js
Security & Compliance:
- Tagging Policies
- Azure config for compliance checks
- NIST compliance
- Guardrails
- Security Hub
Backup and Recovery
- Azure Backup provided a simple, secure, cost-effective, and cloud-based backup solution to protect the business or application-critical data stored in Azure Blob in two ways- Continuous backups & Periodic backups
Network Architecture
- Site to Site VPN Architecture using Transit Gateway
- Distributed Azure Network Firewall
- Monitoring with Cloud Watch and VPC flow logs.
Cost Optimization
- Alerts and notifications are configured in the Azure cost
Code Management, Deployment
- Cloudformation scripts for creating stacksets and scripts for generating Azure services was handed over to the client
Challenges
- Managing multiple clients via ServiceNow portal was a bit challenging where each client has its own SAP environment.
Project Completion
Duration
- Feb 2021 to Feb 2022 ~ 1 year
Deliverables
- Dynamics License
- Power App License
- Power App per use License
- Power App per app license
Support
Products supported
- S/4 Retail, MM, FI and Integration
- Fiori
- Customization and Data
Testimonial
Awaited
Next Phase
No new work identified
If You Are Looking For Similar Services? Please Get In Touch
Testimonial
Peritos is a team of highly skilled developers, technical experts, and delivery managers. We’ve been very impressed with their commitment. Their developers and delivery managers have conducted themselves with professionalism and diligence at all times, and the quality of the work they have performed has been excellent. Many times, they proposed better solutions, which resulted in better and faster products. Peritos is a reliable AWS Partner. You can trust and be satisfied.
“We are very happy with the results of this major IT project with Peritos Solutions. Their staff gained a good knowledge of our business and processes. They were able to work with many of our diverse team members and launch Business Central ERP on time and on budget according to our requirements. We will be using them again for future projects and additional development actions. Thank you!”
The project was completed on time and as per the agreed budget. The communication was excellent, as was the dedication to quickly turning around the required report development. The overall experience was good, and I would definitely work with the Peritos Team again.
Share us
Get A Quote
Proud projects that
make us stand out
Recent Home
Recent Home
Recent Home
Recent Home
Thinking about a project? Get in touch with us.
Connect with Us Today through the Details Below or Fill
Out the Form for a Prompt Response
Book Free Consultation
Guaranteed response within 8 business hours.
Trusted by Startups and Fortune 500 companies
We can handle projects of all complexities.
Startups to Fortune 500, we have worked with all.
Top 1% industry talent to ensure your digital success.
