Combine data source feature allows you to create a new data source from the existing extracted mode data sources by appending all rows with column mapping.
To create combine data source, click Combine Data Source
from the data source listing page.
Combine data source page will open as follows.
Here, extract mode data sources will be listed out. You can select more than one data sources to create combine data source.
If you want to map the data source columns, use the Column Mapping
option.
The default column mapping based on the source table columns is shown as follows. If the target table column does not match with the source table column, NULL
value is selected by default. You can select the desired mapping column using this window.
Then, click Append
to create a new data source. It navigates to the data source editing page and appended data is shown in the preview grid as follows.
You can change the column mapping using the settings icon near the table name.
You can see the combined tables list by expanding the arrow icon near the table name.
You can combine new tables from shared tables option as follows.
Using the delete icon, you can remove the table from the combined table list.
To save the data source, click Save and Exit
as follows.
Now, combined data source created successfully. In server page, Data Refresh Status
will be shown as follows.