The integrate process
The steps in the integration process are:
- Create a test environment (database user) with the existing data warehouse tables loaded.
- Load a copy of the WhereScape metadata repository into this test environment. Refer to the RED Installation Guide for instructions on how to load a metadata repository.
Working within the WhereScape RED tool proceed to:
- Create any connections to UNIX or Windows servers where host scripts are currently executed. Refer to either Windows connection or Unix connection for details.
- Create a Data Warehouse connection mapping back to the test environment. Refer to the data warehouse / metadata repository connection for details.
- Incorporate any Host system scripts currently used. Refer to integrating host scripts for details.
- Browse the Data Warehouse connection (Browse > Source Tables).
- Drag and drop each existing data warehouse table into an appropriate object type. Refer to integrating selecting table type for details
- Answer the retrofit questions and build any required procedures. Refer to integrating questions for details.
- Edit and amend all generated procedures or create new procedures to handle the existing processing methodology. Refer to integrating procedures changes for details.
- Test the new environment.
Removing the metadata for a table
It is possible to delete the metadata for a table without deleting the table object itself. For example, if the integration process is incorrectly undertaken, the metadata for the specific table can be removed.
To delete the metadata only:
- Right-click the table and select Delete Metadata and Drop Table from the context menu. A prompt is displayed which enables you to select the Delete metadata only option.
- Ensure you have selected the Delete metadata only option before clicking OK.