Data Warehouse Center Administration Guide

Migrating from the Visual Warehouse Host Adapters to Classic Connect

To migrate from the Visual Warehouse V1.3 Host Adapters to Classic Connect:

1. Edit the Meta Data utility. The sample Meta Data Utility JCL is found in the SDJXSAMP member DJXMETAU. See Appendix A of the DataJoiner Classic Connect: Installation, Configuration, and Reference Guide for more information.
2. Supply a valid job card and modify the DJX high-level qualifier.
3. If you are mapping IMS data, modify the IMS high-level qualifier and the DBDLIB DD statement.
4. If you are referring to VSAM files by DD names, add DD statements with the same DD names in the Meta Data utility JCL.
5. The first time that you run the Meta Data utility, you need to create the metadata catalog files. Unlike the Visual Warehouse Host Adapters, both IMS and VSAM metadata can exist in the same catalog.
6. Define the metadata grammar files that were used with the Visual Warehouse Host Adapters as input to the Meta Data utility.
7. Verify execute and access authority for the data sets referred to in the JCL.
8. Submit the Meta Data utility JCL for execution and review the output.
9. If necessary, install and configure the CROSS ACCESS ODBC driver.
10. Adapt the Visual Warehouse Host Adapter setup to use Classic Connect:
    1. Open the Warehouse Source notebook.
    2. From the Warehouse source type list, select IMS or VSAM.
    3. Select the Database tab.
    4. Change the data source name to be the same as the data source name that you used when configuring the CROSS ACCESS ODBC driver.
    5. Close the Warehouse Source notebook.
11. Run a step that uses the modified warehouse source to ensure it runs successfully.