What were the underlying reasons or business implications for the need of application integrations?
Following were some of the challenges that we had which implicated the need to automate our business process:
a) More than 24 hours to get data Sync from oracle ERP to various reporting tools.
b) Lot of Manual intervention was required in order to operate Project Management activity. To achivee this Financial Force project Order to Invoice has been implemented.
c) To view the various report based on Employee, Customer, Resource Allocation, Bill Rate, Projects, Expenses, Invoices Business users had to wait 24 to 48 hours to view the data as this was manually prepared by FTE in Excel from various source team.
Describe your application innovation strategy and how you executed the strategy.
GlobalLogic wanted to have some latest Integration tool which have the capability to send the data to realtime / Batch / Scheduled/Cron job manner so all the data transportation can happen across the various systems along with data transformation also if required and replace their existing legacy integration tool which doesn’t have capability to sync data to realtime and cron job manner. GL has mainly use case of integrating various On-Premises and cloud applications,In order to achieve this Objective GL selected SnapLogic Integration Platform after reviewing multiple other ETL tools available in industry.
Using SnapLogic, GL is able to achieve the multiple parallel application integrated within a period of 6-9 months from the time of getting initial license of this Product.
a) Integration with Oracle ERP Data to Salesforce (Scheduled Job and real-time).
b) From various sources Oracle ERP, Data Ware House and other third party vendors data is transformed as per business rules transformation as well and synced data to Financial force application which is Salesforce.
c) Any updates made in Salesforce also reaches as outbound in realtime and both respective applications are in sync.
Who was and how were they involved in building out the solution? (Please include the # of FTEs, any partners or SnapLogic professional services who were involved on the implementation)
Initially this is handled alone by myself and implemented the generic structure SnapLogic pipeline and provided the solution to Salesforce and later abhishek,raj2@globallogic.com joined and took over the remaining incoming integrations and made this project success and we are happily announcing that currently we went Live with this Solution.
What were the business results after implementing these application integrations?
Using SnapLogic post integration the whole Data transportation from ERP to Salesforce improved nearly by more than 90% improvement.the Millions of records from ERP data reaches in less than 15 mins which was earlier happening 3-4 employees manual data extract from ERP in Excel and generate the report based on Excel formula. Due to these Integration Refreshed data is available in Salesforce for reporting.
The flexibility, speed and ease of use of the SnapLogic Platform allowed us to remove the time based bottleneck of getting the data and get the refreshed report and increase in productivity by more than 75%.
Before this implementation Managers and Business owners had to wait 24-48 hours to get the various reports on either entity, and also 2 days behind data, but with this implementation Business owners get the refreshed data in one click which is near realtime data of across entity.
Anything else you would like to add?
GlobalLogic Investment in SnapLogic Integration Platform which is a true Enterprise Platform in the cloud has tremendous benefits in speeding up their Business Objectives related to all integration held and Data Availability resulting in increase growth and productivity.
