Create the streams between the InForm study schema and the Reporting schema, and install the Reporting schema

Previous Topic

Next Topic

Book Contents

Create the streams between the InForm study schema and the Reporting schema, and install the Reporting schema

Note: You only need to perform this step if your InForm study and the Reporting and Analysis module are installed in different database instances.

  1. Configure configdiffdb.sql.

    For more information, see the Installation Guide.

  2. Re-apply any customizations.
    1. If you customized any files using the streams_table_adds variable, or by modifying tabexcludelist.sql or tabincludelist.sql, set the streams_table_adds variable in configdiffdb.sql.

      If these tables already have a prefix of PF*, CT*, or RT*, they will automatically be replicated.

    2. To exclude tables with a prefix of PF*, CT*, or RT* from replication, set the streams_table_exclude variable in configdiffdb.sql.
  3. Open a Command Prompt window.
  4. Navigate to the folder in which the Reporting and Analysis software is located (for example, e:\InForm\Bin\DBOra\Reporting).
  5. Run configandcheckdiffdb.

    For more information, see the Installation Guide.

  6. Run install_reporting_diffdb to install the reporting schema.

    For more information, see the Installation Guide.

Copyright © 2014, 2017 Oracle and/or its affiliates. All rights reserved.