Advanced Operations - Combination Between Different Data Sources

At the beginning of the tutorial, you saw how to create new views using the join operation but the views involved in the joins were all coming from the same datasource. In this section, you will see how you can create a new join view using the exact same procedure but coming from two different and heterogeneous data sources.

To create the derived view you can follow these steps:

  1. Right-click on the personal_data_crm view and select New > Join.
  2. Drag & drop the billing_information view to the Join View wizard Model tab.
  3. We will use client_id = customer_id as the join condition so drag & drop a line from the client_id field in the personal_data_crm view to the customer_id field in the billing_information view.
Join wizard model tab

In the Output tab:

  • Name the view: client_with_bills.
  • Remove the field return_customer_id from the output schema of the view (you already have the customer_id field).
    Join wizard output tab
  • click Save.

Now, if you execute the new view we will get the information about the bills from the different clients.

Client with bills results

The Web service needs a mandatory input parameter and Denodo is automatically taking care of providing this parameter in the join view using the data coming from the personal_data_crm view.

NOTE