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.

Step1:

  • Right-click over the “bv_wo_customer” folder and select New > Join.

One

 

 

 

Step2:

The “customer” view will get dragged onto the workspace.

Step3:

          Drag the “bv_wo_orders” view onto the workspace.

 

Two

 

Step4:

          Connect the “customer_code_internal” column from the customer table to the “customer_code” column of the orders table.

Three

Step5:

          In the Output tab, remove the “customer_code_internal” and “customer_code” columns

Four

Step6:

          Click save.

 

Five

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:

Six

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

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 4 months of experience in ETL tools – SSIS, DENODO, and SQL. He also has a good knowledge of Python and ADF.

More from this Author

Subscribe to the Weekly Blog Digest:

Sign Up
Follow Us
TwitterLinkedinFacebookYoutubeInstagram