ETL+ Mirrored Source(s)

List of Mirrored Sources

Expand your DW entry to view the list of mirrored sources. The following is an example. Mirrored sources have yellow boxes.

Each mirrored source header shows:

Checkbox: Check this box to select all objects from this source. More is explained in sections below.
Source Type icon: This is a quick way to view the source type (such as Excel or MS SQL).
Source Name: This is user-configurable in the source’s properties.
Dw Schema: When the Schema icon at the top of this panel is ON, then the source’s target SQL Schema shows between paranthesis. This is user-configurable in the source’s properties.
Number of target objects: It shows the number of target objects mapped from this source. The number is between paranthesis.
Favorites: Click the Favorites icon to put your prefered sources at the top of the list. Unclick them to return them to their alphabetical order.
Source Metadata Information (?): Mouse over this icon to view source detail properties.
Load Now: To load now objects from this table, one needs to select objects mapped to this source and click this icon.
Add Target Objects (+): Click this icon to review and/or add more target objects from this source.
Properties (wrench icon): Click this icon to review and/or change this source’s properties.
More (…): Click this icon to access additional source actions:
- Duplicate Source
- Delete Source
- Change Group’s Schema
- Collapse Columns Group
- Delete Group
- Expand Columns Group
- Freeze Group
- Tags
- Unfreeze Group
Expand (v): Click the source header or this icon to view the mapped target objects from this source.

To add a source object (like a table or view) to your data warehouse:

Click the + icon on the source header.
The Data Source panel opens. IMPORTANT:
- If the left panel of the panel is blank: Click the Refresh icon to load the available source objects. Some sources might take a long time to render the available source objects.
- You’ll need to click Refresh when the source object metadata changes (new or modified source objects).

Use the scroll bar on the left panel or use the search box to find the desired source objects and then check their checkboxes.
Click >> to map/add them to your Target Objects (right panel).
The image above shows a couple of checked source objects that were added to the Target Tables (they show in green fonts on the right panel).
Click the Save button on the top left to execute the change.

To add new Target Objects: Use the above section to add Target Objects to your data warehouse.

The following is for changing the settings of your target objects and executing data loads.

Click a mirrored source header to view its target objects.
Click the v icon on the right of a target object to view its columns and data types.