Executive Summary
About Client
SydConsulting (Services You Demand) is an SAP professional consultancy initiated in April 2013 by Grant McPherson. Grant had been working in international SAP consultancy businesses in NZ and Europe when he and his wife Katy chose to return to New Zealand. Grant was frustrated with the local SAP consultancy practices because they had a profit-first focus. SYD was explicitly formed with the core values of Customer-first, Employee second & Profit third.
https://www.syd.co.nz/
Location: Auckland,NZ
Project Background
SYD Consulting created a digital network on the SAP Business Technology Platform and integrated it using SAP Integration Suite to track and trace its products at every phase of the supply chain. SAP CPI Support enabled:
- Optimal implementation of source-to-pay and design-to-operate processes, leveraging the cloud integration capabilities of the SAP Integration Suite
- Higher security as a result of simplified integration among connected participants due to the cloud integration capabilities of the SAP Integration Suite
- Increased trust in the SYD Consulting brand
- Enhanced business agility and lower transaction costs
Scope & Requirement
Implementation
Technology and Architecture
Technology
The web app was deployed with the below technological component
•Application SAP BOBJ
• File migration LCM
• Database: SQL Server
• Cloud: NA
• On premise servers
Integrations
• Single Sign-on using Active directory
• No other integration requirement
Security:
• In built Data Encryption
• Roles and Authorisation based access for each user group and Admin for specific users.
Backup and Recovery
Existing File system backup functionality was being reused.
Scalability
Not Required
Cost Optimization
As per license agreement with SAP. No additional costing needed
Code Management, Deployment
NA
Challenges
Worked on a complex integration scenario with multiple integration tools like Mulesoft
Project Completion
Duration
Nov 2022 to Ongoing
Deliverables
- Support existing Production CPI flows
Support
- For all Licenses we implement we provide monthly billing with 20 days credit Terms.
- We provide Value added services by sending reports to the client on the license usage and last activity date for each user to help them manage their license cost and to get visibility
Testimonial
Awaited
Next Phase
We are also in discussion with other projects for the client
- Ongoing CPI work identified
- Mulesoft 3.9 migration to Mulesoft 4
If You Are Looking For Similar Services? Please Get In Touch
Executive Summary
About Client
DEEPIQ simplifies industrial analytics and offers the only self-service application for end-to-end (Data + AI) OPs for the industrial world. With this app, your SMEs can digitize their expertise, and your data teams can build and deploy robust analytic pipelines.
Location: Have Offices Globally in USA, India, Canada
Project Background
We help clients to move to the cloud from their existing system landscape. For this particular case study we helped the client DEEPIQ to move to website hosted in WordPress to Azure.
Scope & Requirement
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:
- We faced some issues pertaining to system changes not working as per the new standards
- Creating a backup strategy without having proper backup tools in place
- Ensuring this end-to-end migration did not lead to data loss
- Additional security enhancements are to be added to ensure unauthorized users do not modify reports.
Project Completion
Duration
Deliverables
- Migration of data and applications securely without impacting the existing user base
- Using Traffic manager to configure routing to 2 different websites
- Adding Auth0 with Traffic manager routing traffic to different domains
Testimonial
Evania Fernandes
building Manager
ultimate property group
Next Phase
If You Are Looking For Similar Services? Please Get In Touch
Executive Summary
About Client
The world today is witnessing a growing trend in the use of technology in the health sector. This allowed us to assist our client, a pharmaceutical company in tracking medical devices and the quality of medicines on the go along with the inventory and transit status, and we supported them in AWS to IoT integration.
Project Background
In this case study, we achieved the following:
- How we implemented a small AWS IoT integration application with a toolkit to assure product quality, elevate the efficiency of medical devices, and raise alerts in case manual intervention is required
- Set up AWS for the application to manage the devices seamlessly
- Interaction with the device to fetch vital information
- Finally, creating a mobile application and using AWS IoT to monitor the devices
Scope & Requirement
We used the below solution components to create a responsive web application that gives a holistic view of all the devices connected to the system and information on their vital parameters.
Implementation
Technology and Architecture
Technology/ Services used
We used AWS services and helped them to setup below
- Cloud: AWS
- Organization setup: Control tower
- AWS SSO for authentication using existing AzureAD credentials
- Policies setup: Created AWS service control policies
- Templates created for using common AWS services
Security & Compliance:
- Tagging Policies
- AWS config for compliance checks
- NIST compliance
- Guardrails
- Security Hub
Network Architecture
- Site to Site VPN Architecture using Transit Gateway
- Distributed AWS Network Firewall
- Monitoring with Cloud Watch and VPC flow logs.
Backup and Recovery
- Cloud systems and components used followed AWS’s well-Architected framework and the resources were all Multi-zone availability with uptime of 99.99% or more.
Cost Optimization
- Alerts and notifications are configured in the AWS cost
Code Management, Deployment
- Cloudformation scripts for creating stacksets and scripts for generating AWS services was handed over to the client
Challenges
We encountered some issues as below:
- AWS setup and pricing were complicated to understand as it is based on usage and consumption, which was a difficult thing to assess at the start of the application
- Ensuring data privacy and security is of utmost importance in this case. Since devices can be hacked without much effort due to poor encryption and that could allow unauthorized access
- Impeccable quality assurance of the whole setup was to be achieved in this case of the pharmaceutical industry, which involves dealing with medicines are surgical instruments, so there was a need for honest sharing of information if anything was not going as expected.
- Understanding the client’s vision of how they needed the UI was challenging.
Project Completion
Duration
Deliverables
- Responsive web application
- Login mechanism using 2 Factor authentication
- Integration with AWS IoT to send and receive data
- Creating screen design using SAP Build on Fiori Guidelines.
- Raspberry Pi3
- Humidity and Temperature sensor to be added
- Using AWS IoT integration core functionality.
- Responsive web application
- Backend in Azure
- Coding in C#, JavaScript, and Angular 5 using Fiori guidelines
- Using MQTT to receive data
Support
- 1 month of extended support
- A template for Cloud formation stack to create more AWS resources using the available stacks
- Screen-sharing sessions with a demo of how the services and new workloads can be deployed.
Testimonial
Evania Fernandes
building Manager
ultimate property group
Next Phase
If You Are Looking For Similar Services? Please Get In Touch
Executive Summary
About Client
Since 2015 BAC has been instrumental in evolving and simplifying the customer experiences of forward-thinking organizations across Asia Pacific, Europe, North America, the UK, and Ireland. BAC helps organizations unify their people, processes, and technologies to deliver industry-leading customer and employee experiences. BAC enables you to leverage technology to align your sales, marketing, and success teams, so you can make the most of every interaction, even as you grow. We supported the client with SAP Integration with Hubspot.
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
Awaiting
building Manager
Bacpartners
Next Phase
