Denodo: A data virtualization platform
Data virtualization is a core technology that enables modern data integration and data management solutions.
Factors of data virtualization:
- Connect, introspect, and govern any data source with zero data replication: Quickly connect disparate structured and unstructured sources. Catalog your entire data ecosystem. Data stays in the sources and it is accessed on-demand, with no need to create another copy.
- Combine and integrate into business data views: Build data models that suit the needs of the consumer, even across multiple sources. Hide the complexity of your back-end technologies from the end users.
- Consume and secure data views in multiple formats: The virtual model can be secured and consumed using standard SQL and other formats like REST, SOAP, and OData.
Combining the data
With the data sources and base views in place we are in a position of starting to combine all the data. The first steps are to have a denormalized, standardized view of each data source so we get a set of base business entities.
- Right-click over the “bv_wo_customer” folder and select New > Join.
The “customer” view will get dragged onto the workspace.
Choosing a Global Software Development Partner to Accelerate Your Digital Strategy
To be successful and outpace the competition, you need a software development partner that excels in exactly the type of digital projects you are now faced with accelerating, and in the most cost effective and optimized way possible.
Get the Guide
Drag the “bv_wo_orders” view onto the workspace.
Connect the “customer_code_internal” column from the customer table to the “customer_code” column of the orders table.
In the Output tab, remove the “customer_code_internal” and “customer_code” columns
Step7: With these steps we have created a new view that contains the standardized names for each customer_code, instead of the wrong ones that we originally had. To check that everything is working properly click on and then Execute again:
Here we have successfully combined the customers and order data in denodo.
For more such blogs click here
Thanks for reading!! Hope you enjoyed reading this blog.
Informative and very well explained Himanshu.