Prerequisite: If you have not already done so, please Download the AdventureWorks Sample Database.
Steps:
- Right-click on the new data source, AW.
- Click Read objects from Data Source
-
This will read the metadata from the data source such as table names, field names, data types, relations, and primary keys.
-
Expand table nodes to view and select individual fields.
- Right-click on table names to Preview the source table and select data by viewing its values.
- For this Exercise, click Select All.
- In the Business Unit, expand the Tables node to see the newly added tables.