As organisations across the globe strive to secure that all-important single source of truth for data-driven decision making, Informatica’s Intelligent Data Management Cloud (IDMC) has become a go-to solution for big brands and small to medium enterprises to leverage their data previously left underutilised in multiple siloes.
Driven by their revolutionary AI-powered CLAIRE engine, Informatica’s IDMC consolidates vast amounts of on-premise and cloud-based data to serve up unprecedented analytics and business intelligence.
Within our Informatica practice at ISW, we have assisted many organisations to prepare for and implement IDMC – with strategies designed to optimise performance and ensure the strongest possible return on investment. For existing customers, we leverage IDMC full capabilities to ensure they are extracting the most value from the platform.
A high-profile example of this would be Canon Australia. The company’s IT leadership team were aiming to optimise its performance as part of their ongoing commitment to continuous improvement and maximising efficiency across their business.
Specifically, the team was seeking to improve integration between their IDMC environment and CRM system to:
- increase capacity
- accelerate interface processing time
- consolidate duplicate workflows
With the new IDMC licensing model now based on data consumption, Canon Australia were also keen to reduce the system workload which in turn will lower their IPU (Informatica Processing Unit) spend.
Solving integration challenges to boost IDMC performance
Working closely with our skilled technical team, a number of solutions were devised to solve Canon Australia’s challenges with their CRM integration and enhance IDMC performance.
A sample of these technical strategies include the following:
- Adopt incremental load strategies to reduce processing times and resource utilisation.
- Identify and merge appropriate integration tasks.
- Provide a standardised method for bulk loads.
- Improve staging architecture to service the on-premise SQL database and reporting systems.
- Apply Informatica’s standard naming conventions to support further development.
- Redesign scheduled tasks and incremental loading of Objects.
- Clean up duplicated aspects of data and reconcile the scheduled task to avoid dependency issues.
- Provide documentation outlining approaches to deployment in the new environment.
Josh Butler (Platform Delivery Manager, IT Operations at Canon Australia) says the changes have created widespread benefits – from a massive improvement in integration performance to faster reporting times and simplified overall management.
“This project has helped us in many ways and we are now in a better position prior to our next renewal. Thanks to our work with ISW, we’ve achieved a reduction in duplication of CRM data, the introduction of best practice naming conventions, and simplified management of metadata changes.
“Most importantly, integration performance has improved by an impressive 66% and our users can now access one source of truth in our SQL database with real time data.”
Leveraging ISW’s Cloud Ignition Service offerings
Currently, ISW is providing Cloud Ignition Service offerings where our ISW certified experts work with you to assess your existing Informatica cloud environment to provide recommendations on:
- how your environment can be improved to align with best practice
- opportunities to increase performance
- efficiency improvements to reduce overall throughput and decrease IPU spend
- any aspects of Informatica you may be entitled to but aren’t currently using
Contact ISW to take your Informatica experience to the next level.
If your business would benefit simply call us on 1800 056 002 or register your interest here.