Data integration solutions, also known as ETL (Extract, Transform, Load) tools, are software applications designed to facilitate the process of extracting data from various sources, transforming or manipulating the data as per requirements, and loading the transformed data into a target database or application. These tools play a crucial role in data integration and data warehousing processes, enabling organizations to consolidate and manage large volumes of data from disparate sources to generate business insights and knowledge bases for Generative AI (GenAI).
Popular data integration solutions include IBM Data Fabric, Qlik (Talend), Informatica, Alteryx, Oracle, Azure Data Factory, Amazon Glue, and Nifi.
Point solution-based data reconciliation and financial close workflow tools like Blackline, Trintech, FloQast, and OneStream focus on functional use cases like bank and account reconciliations, transaction matching, workflow management, and financial statement assurance and compliance.
While both sets of players operate in an increasingly data-driven world to enable AI and GenAI value generation, there have been some interesting trends in the market:
- Data integration/ETL players are increasingly going private or consolidating, or owned by the Cloud scalers to provide one-stop services and scale up to manage growing data flows/types. Implications – need for business model and go to market reset is needed.
- Point solution providers are consolidating for scale and access to client data pipelines for next-gen AI-enabled solutions and expanding across the CFO’s operations and key working capital cross-functional flows.
So, what is next for these players, and what are the implications for enterprise and small/mid-sized organizations?
ETL Players
- The market for industry solutions in data and analytics is estimated to be significantly larger than functional solutions.
- Build functional and sector sales and solutions expertise and productize data to insights methodologies.
- Take a leaf from ERP and Cloud scalers and grow the implementation partner ecosystem to provide options beyond enterprise to mid-market and smaller enterprises.
Point Solution Providers
- Recognize that the data integration players are coming after their space and in many cases already embedded in IT/BI groups, making them formidable incumbents – if they were to pivot to a business outcomes focus.
- Partner with data integration providers – point solutions are typically dependent on structured data sets to be effective. So needing an ETL layer to augment the point solution is an imperative for the buyer client in an in increasing unstructured and multi-data source world.
- Differentiate significantly on functionality, particularly with embedded AI/ GenAI
Buyers
- Enterprise:
- Start with the end in mind – simplify data management ecosystem vs ETL and reconciliation solutions sprawl. Focus on specific business outcome based use cases that will scale-up.
- Consider a broader slate of players vs point solution providers.
- Focus on developing use cases and building MVPs that show value to the business stakeholders.
- Ecosystem of data integration partners, industry/functional expertise
- Mid-market and Small Organizations:
- IT needs to start with a cloud-first approach to systems and data integration.
- IT must simplify vendor and service integrator stack – a champion challenger model of a lead service partner and 1-2 smaller specialist partners to diversify delivery risk.
- Business leaders must consider solutions with Low/ No code user interfaces – seed self service development and change management capabilities within end users – to rapidly capture value from technology investments vs depending on internal IT
Conclusion
The conversation around data integration solutions needs to move from a purely technical discussion to a business-focused one. Data integration solutions are not just about managing data; they are about driving business outcomes.
In a rapidly evolving AI and GenAI-powered world, functional buyers who have traditionally focused on point solutions must recognize that process efficiency is fast becoming commoditized. Partnering or transitioning into the data integration space is no longer an option but an imperative.
Does this resonate with you? Please feel free to reach out.
Shared Services Imagineers 