The volume of data in your organisation keeps growing exponentially, and data continues to be distributed across a complex infrastructure in which cloud, big data and NoSQL are the rule rather than the exception? This, while the need to analyse data faster, in real time, increases rapidly. Existing data integration solutions can no longer keep up with these developments.
Data virtualisation makes it possible to integrate data sources and to unlock such data sources in real time, without replicating the data – irrespective of the structure, technology or location. Data virtualisation is the ultimate resource for setting up a logical data warehouse. Kadenza supports you in this, with the data virtualisation solutions from Denodo.
Data integration without replication
With data virtualisation, your organisation can anticipate and respond to new and altered information needs much faster, much better and in a less expensive way. With data virtualisation, you can unlock, transform and integrate all your data sources with the push of a button. The result is a virtual data hub that supplies uniform data services to business applications and users, without the need to know the technical details, such as location and format. Thus, data virtualisation provides much faster access to (new) data sources. When you virtualise data from consolidated data sources, like data warehouses, the need for more physical consolidation and replication of data also disappears.
Data virtualisation and ETL
Data virtualisation and ETL are often placed on opposite sides of the fence, unnecessarily. Although the solutions differ substantially, they are complementary in many situations. For example, with data virtualisation, you can quickly combine new data with data in a data warehouse (fed via ETL processes). Moreover, data virtualisation fills the gap where ETL falls short because data replication is just not possible considering the location or size of the data source. On the other hand, it’s more difficult to apply data virtualisation when you need historical data that’s not available in a source system. In that case, data replication via an ETL tool may be the solution.
Data virtualisation enables your organisation to respond fast and with the necessary flexibility to users’ nearly insatiable demands for usable information – mostly in the form of reports or dashboards. With a data virtualisation layer, your users can create reports quickly, easily change how information is displayed, refer to original data sources, and even build virtual data marts, preventing any new occurrences of data replication.
Big data and cloud
Data virtualisation makes it possible to easily integrate big data sources and cloud solutions with other sources and existing data warehouses, in one architecture. And, without the need to move or replicate data. In addition – apart from performance optimisation within the actual platform – you make smart use of the underlying data sources’ functionalities to optimise the performance. You make maximum use of the computing power of the underlying data source.
360-degree view of the customer
Build a 360-degree view of all the available customer information, by establishing the virtual integration of all data sources, like relational databases, business applications, cloud data, NoSQL data stores, spreadsheets and (un)structured data. This way, you’ll always and quickly have an up-to-date and relevant overview of all your customers’ information, within your organisation and beyond.
Create a central platform to execute data deliveries within and outside of your organisation more efficiently, to implement changes with greater flexibility, and to ease the burden of managing it all. Doing so will help you get a grip on the countless data sets and users within and beyond your organisation. You can easily provide insight into how data sets were created, who has access to what data, and what information is being requested. In other words, you make sure that your organisation uses the data sets in a compliant manner.
Independent consultant, teacher and author, Rick van der Lans, explains:
“It has to be faster!”
- A logical data warehouse architecture provides much more flexibility and productivity
- The use-by-date for the classical data warehouse has expired
- Thanks to data virtualisation, we can switch to a logical data warehouse, step by step
Clients appreciate us for our sincere interest, professionalism and the results that we achieve.
- Business applications, organisation or technology: our employees know what is involved.
- We build bridges in the data-driven organisation. Bridges between business and IT and between technology and user.
- The experience that we have acquired is incorporated into tools, methods and reusable knowledge.