The Sources Page

The Sources page is divided into two panes. Source systems and source tables are displayed in a tree view in the left pane. When you select a source table, its columns are listed in the right pane. You can perform various actions on source systems, sources, and source columns from this page.

To expand/collapse the tree view, click on the icons.

Source systems

Hover over the source system row to open a popup button menu with available actions.

	Add Custom View	Opens a dialog where you can define a new custom view. For more information, see Custom Views.
	Scan Metadata	Select source tables and start scanning metadata. For more information, see The Sources Page.

Sources

Hover over a source row to open a popup button menu with available actions.

	Edit source	Edit the source settings. For more details, see Edit Sources.
	Delete source	Remove the source from the configuration.
	Show data	Show the source data currently loaded on the business object. For more details, see Show Data. This button will only be visible if source data has been loaded.
	Apply and load	Apply the current changes and load the source data on the defined business objects. This icon will only be visible if you have made changes to the source configuration.
	Scan metadata	The selected source will be scanned again and any structure changes since the previous scan will be applied.

Source Columns

Naming

Yotilla automatically generates business object and business attribute names for the columns in the scanned tables based on the technical names of source tables and columns. You can change the name of an object or attribute by clicking on it and typing the new name.

Remove or ignore columns

To remove the metadata for a column from the configuration, click on the column dropdown menu and select Remove.

To keep the metadata for a column in the configuration but exclude it from being loaded into any layer of the data warehouse, click on the dropdown menu and select Ignore.

When the source is loaded into Yotilla, the column will be either removed or ignored depending on what you selected. The selected action is indicated on the column row.

Bulk edit/ignore/remove

To perform actions on more than one column at the same time, check the boxes next to the desired columns and select an action from the dropdown menu at the top (above the checkboxes).

To check/uncheck the checkboxes for all columns, click on the checkbox at the top.

Bulk edit	Opens a dialog where you can choose actions to be performed on the selected columns.
Toggle ignore state	Toggles the ignore state for the selected columns. You can use this to quickly remove the ignore flag from columns that you previously marked to be ignored, and at the same time set the ignore flag on other columns.
Remove columns	Marks the selected columns to be removed.

If a column has been marked to be removed, any subsequent action on that column will be ignored.