 |
 | Creating a connection
|
In the DQ Repoditory view:Expand the Metadata node and right-click DB Connection. Select New connection in the menu.
Next
|
 |
In the Database Connection wizard.Enter your connection information. Click Next.
Next
 | Name is an obligatory field. Spaces and special characters are not allowed.
|
|
 |
Enter your database information (Login, password, hostname, port, etc.). Don't forget to verify that the information is correct by clicking Check. Click Finish.
|
 |
The cif and cim databases can now be accessed via the repository.
|
 |
 | Creating a connection analysis
|
In the DQ Repository view:Expand the Data Profiling node and right-click Analysis. Select New Analysis in the menu.
Next
|
 |
In the new window, select the Database Structure Overview category. Click Next.
|
| The panel on the right describes the different analysis types and helps you to choose the one which best suits your needs.
|
|
 |
Indicate your connection information. The Name field is obligatory and neither spaces nor special characters are allowed. Click Next.
|
 |
Select the database that you want to analyze. In this example, the connection is called StagingDB. Click Next.
|
 |
The new menu allows you to filter the tables and views that you want to analyze. You can insert a customized list. Each table name must be separated by a comma (eg.: table1,table2,table3).
|
 |
You can now run your analysis by clicking on the run icon. |
 |
 | Viewing your analysis results
|
You can now access the results of your analysis. Analysis Parameters: in this zone you can add filters on the tables or views. Analysis summary: information concerning your last analysis. Statistical Information: your analysis results. The rows higlighted in red indicate that no record is available.
|
 |
You can view all of your table keys by doing the following: - In the table list, click right on the #keys column - Select View keys
|
 |
By clicking the table names in the database view you can now access all of the information concerning the tables in your databases.
|
