Register Schemas and Tables

The Schema Manager is used to register physical database information and manage access permission for use in the i-META Designer.

Step1.  Launch Schema Manager

1.  Click the [Schema Manager] menu.
    Responsible for database connections, and provides access to information on Synonyms, Tables, and Views through the displayed dialog box.
   
   

Step2.  Add Schema

1. Select the database containing the data to be registered.
   
   

   Databse information is displayed based on the permissions set in ADMIN.

   
   
   
   

2. Right-click the DB service name, and select [Add Schema] from the dropdown menu. In the Add Schema dialog box, select the schema to register and click the [Save] button.
   
   

Step3.  Add Table

1. Right-click the [Tables] folder under the registered schema, then select [Add table] from the dropdown menu.
   
   
2. In the [Add object] dialog box, enter the name of the table to add and click the [Search] button.
   
   
3. From the search result, select the desired table and click [Save] button to complete the table addition.
   
   
   
   

4. Double-click the added table to view column, data, and permission settings on the right panel.
   
   
   
   

   You can update column information at the schema level from the registered schema in the schema tree, but it may take a long time if there are many tables.

   
   

Step4.  Add Derived Table

Add a derived table by writing SQL statements instead of using a physical table.

1. Right-click the [Tables] folder under the registered schema, then select [Add derived table] from the dropdown menu.
   
   
   
   

2. In Derived table dialog box, enter the table name and description, then input the SQL statement to create the table, click [Execution] button.
   Execute and verify the column information and data preview, then click the [Save] button.
   
   

   Derived tables are analyzed as sub-queries during data analysis. Functions sepcific to each DB are supported.

   
   
   
   

3. Check the created table information. 
   
   

Step5.  Other Features

1.   Update Column Information

If the table's column information has been modified after being registered in the Schema Manager, it must be updated.

1. Right-click the registered table and click [Update Column Information].
   
   
   

2.  Find the i-META file containing the table with updated column information, right-click the table, and click [Update field list] to update the field list.
   
   
   
   

   You can update column information at the schema level from the registered schema in the schema tree, but it may take a long time if there are many tables.

   
   

2.  View Related Reports

Enable checking i-META Files or the list of the reports that use the selected table.

1. Right-click the registered table and click [View related reports].
   
   
   
   
   

2. Enable checking i-META File and the list of the reports that use the selected table.
   
   
   
   

   Meta Report Object Information : Displays a list of meta reports that use the selected table. Data Source Object Information : Displays a list of reprorts that use the selected table.

   
   

3. Double-click the list of the i-META Files to view the list of reports associated with that meta file.