Combine Data From Multiple Data Sources. The first step is to identify which data you want to extract. To combine tables from different sources simply select the source you want and drag the table onto the canvas.
There are 3 ways to do Data Synchronization ie putting the data together in the context using a webi report. In this example we merge data from two data sources into one dataset and then use this dataset to build a summary report. Click on the Data tab.
Combine all data sources into one list.
Just below the Data tab click on New Query then choose From Other Sources in options. Just follow the step by step guide below to successfully combine data from various worksheets. This may be a more. For example you can combine SAP HANA and Odata sources or local CSV tables and SAP ABAP sources.