1 Create a test environment (database user) with the existing data warehouse tables loaded.

2 Load a copy of the QAD metadata repository into this test environment. See the Installation and Administration Guide for instructions on how to load a metadata repository.

3 Create any connections to UNIX or Windows servers where host scripts are currently executed. See either creating a Windows connection (see "Windows" on page 128) or creating a Unix connection (see "UNIX" on page 157).

4 Create a Data Warehouse connection mapping back to the test environment. See creating a connection to the data warehouse (see "Data Warehouse" on page 96).

5 Incorporate any Host system scripts currently used. See incorporating host scripts (see "Integrating, Host Scripts" on page 979).

6 Browse the Data Warehouse connection (Browse/Source Tables).

7 Drag and drop each existing data warehouse table into an appropriate object type. See Selecting an appropriate table type (see "Integrating, Selecting a Table Type" on page 981)

8 Answer the retrofit questions, and build any required procedures. See integrate questions (see "Integrating, Questions" on page 981).

9 Edit and amend all generated procedures, or create new procedures to handle the existing processing methodology. See procedure changes (see "Integrating, Procedures" on page 986).

10 Test the new environment.