After completing this exercise, you will be able to:
• Create Datastores and import metadata for the Alpha Acquisitions, Beta Businesses, Delta, HR Data Mart and Omega databases
Business Example
You have been hired as a Data Services designer for Alpha Acquisitions. Alpha has recently acquired Beta Businesses, an organization that develops and sells software products and related services. In an effort to consolidate and organize the data, and simplify the reporting process for the growing company, the Omega data warehouse is being constructed to merge the data for both organizations, and a separate data mart is being developed for reporting on Human Resources data. You also have access to a database for staging purposes called Delta. To start the development process, you must create datastores and import the metadata for all of these data sources.
Task:
Create Datastores and import metadata for the Beta Businesses and Delta databases.
1. Log in to the Data Services Designer.
2. In your Local Object Library, create a new source Datastore for the BETA Businesses database.
3. In your Local Object Library, create a new Datastore for the DQSTANDALONE database.
4. In your Local Object Library, create a new Datastore for the DELTA staging database.
Solution 1: Create Source and Target Datastores
Task:
Create Datastores and import metadata for the Beta Businesses and Delta databases.
1. Log in to the Data Services Designer.
a) From the Windows Terminal Server (WTS) training environment desktop, choose Start → Programs → SAP Business Objects Data Services 4.0 SP1
→ Data Services Designer.
b) In the dialog box, enter your assigned User ID.
c) Enter your password, which is the same as your User ID.
d) Choose the Log on button.
e) In the list of repositories, select your repository DSREPO##, where ## is the number portion of your User ID.
f) Choose OK.
2. In your Local Object Library, create a new source Datastore for the BETA Businesses database.
a) In the Local Object Library, select the Datastores tab and right-click in the Datastores workspace to select the New option from the context menu.
b) In the resulting dialog box, use the options:
Field Value
Datastore name BETA
Datastore type Database
Database type Microsoft SQL Server
Database version Microsoft SQL Server 2005 Database server name Supplied by the Instructor
Database name BETA
User name sourceuser (lower case)
Password sourcepass (lower case)
Continued on next page
Choose OK to finish.
c) In the Local Object Library, right-click the BETA datastore to select the Open option from the context menu.
The tables from the BETA database are displayed on the Metadata window on the right.
d) Import the metadata for the BETA database source tables by selecting all the tables, right-click on them and from the menu, choose the option Import.
• source.addrcodes
Note: This database is a read-only database.
e) View the data for the USA_Customers table and confirm that Jane Hartley from Planview Inc. is the first customer record by right-clicking on the table in the Local Object Library and choose the option View data.
3. In your Local Object Library, create a new Datastore for the DQSTANDALONE database.
a) In the Local Object Library, select the Datastores tab and right-click in the Datastores workspace to select the New option from the context menu.
b) In the resulting dialog box, use the options:
Field Value
Datastore name DQSTANDALONE
Datastore type Database
Continued on next page
Database type Microsoft SQL Server Database version Microsoft SQL Server 2005 Database server name Supplied by the Instructor
Database name DQSTANDALONE
User name sourceuser (lower case)
Password sourcepass (lower case)
Choose OK to finish.
c) In the Local Object Library, right-click the DQSTANDALONE datastore to select the Open option from the context menu.
The tables from the DQSTANDALONE database are displayed on the Metadata window on the right.
d) Import the metadata for the DQSTANDALONE database source tables by selecting all the tables, right-click on them and from the menu, choose the option Import.
Note: This database is a read-only database.
4. In your Local Object Library, create a new Datastore for the DELTA staging database.
a) In the Local Object Library, select the Datastores tab and right-click in the Datastores workspace to select the New option from the context menu.
b) In the resulting dialog box, use the options:
Field Value
Datastore name DELTA
Continued on next page
Datastore type Database
Database type Microsoft SQL Server
Database version Microsoft SQL Server 2005 Database server name Supplied by the Instructor
Database name DELTA## (where ## is the
group number assigned by your instructor)
User name student## or consult your instructor Password student## or consult your instructor Choose OK to finish.
c) You do not have to import any metadata.
Note: This database is a read/write database and will be used as the target for your template tables.
Lesson Summary
You should now be able to:
• Define Data Quality processes
• Use Data Quality transforms
• Configure Data Quality transforms
Unit Summary
You should now be able to:
• Define Data Quality processes
• Use Data Quality transforms
• Configure Data Quality transforms