In this episode of the Cloud Database Report Podcast, Ciaran Dynes, Chief Product Officer with Matillion, a technology company that specializes in data integration and preparation for data warehouses, discusses how best practices are changing when data warehouses are in the cloud. Ciaran is responsible for product strategy and incorporating customer requirements into Matillion’s products, which include tools for data integration and ETL.
The Big Themes:
- ETL, which stands for Extract, Transform, and Load, has been standard practice with on-premise data warehouses for 50 years. But ETL is changing in the cloud because data transformation happens in the cloud data warehouse, after data has been extracted and loaded. This new process is called ELT.
- Data must be integrated from myriad sources. Matillion says that many cloud data warehouses pull data from more than 1,000 databases, applications, and other sources.
- Data quality is an ongoing challenge, but automation can help.
The Big Quotes:
- “We’ve moved to this general concept of bronze, silver, and gold versions of data.”
- “That’s the game we’re in — can we connect, combine, then synchronize back out into the operational system so we can take an action with a customer in real time.”
- “Big data forced organizations to make data a board-level and executive-level conversation.”
- “The culture of data is changing rapidly within companies.”
About Cloud Database Report
As the traditional database market morphs rapidly into the cloud database market, it’s a game changer not just for the tech industry, but also for developers, database managers, data scientists, business users, and the entire data ecosystem. The pace of change in data management is accelerating, both because more data than ever is being generated and because business and IT decision makers are keenly aware that “big data” represents tremendous value if they are able to capitalize on it.
For many, cloud databases represent a faster, better, and cheaper way to do that. Cloud Database Report provides ongoing coverage and analysis of the cloud database market—the vendors, cloud database platforms, emerging technologies, trends, and business use cases.
This episode is brought to you by InterSystems Corp.