Skip to main content

Software Development

Combining The Data In Denodo Platform.

Microsoftteams Image (3)

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.

Microsoftteams Image (4)

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.


          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



          Click save.



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.

Thoughts on “Combining The Data In Denodo Platform.”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Himanshu Padole

Himanshu Padole works at Perficient as an Associate Technical Consultant. He has over 1 year of experience in ETL tools – SSIS, Denodo, Informatica, Talend, and SQL. He also has a good knowledge of Python, ADF, and Databricks.

More from this Author

Follow Us