Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Before You Begin
  4. Pre-Installation Tasks
  5. Data Integration Hub Installation
  6. Post-Installation Tasks
  7. Upgrading Data Integration Hub
  8. Starting and Stopping Data Integration Hub
  9. Optional Data Integration Hub Configuration
  10. Installing and Configuring the Data Integration Hub Accelerator for Data Archive
  11. Troubleshooting the Data Integration Hub Installation
  12. Uninstallation

Installation and Configuration Guide

Installation and Configuration Guide

Replacing the Operational Data Store Loader Workflow

Replacing the Operational Data Store Loader Workflow

If you installed the Dashboard and Reports component for the first time, import the operational data store (ODS) loader workflow. If the Dashboard and Reports component was installed in the previous version of
Data Integration Hub
and you are upgrading to the current version from a version earlier than 9.6.2, replace the existing workflow.
If the Dashboard and Reports component was installed in the previous version of
Data Integration Hub
, you must have unscheduled the
Data Integration Hub
ODS loader workflow before you upgraded
Data Integration Hub
to the current version. For more information, see GUID-8BD86874-0566-47F6-99C8-16427FA8E887.
  1. In PowerCenter Repository Manager, run the
    Import Wizard
    .
  2. Select the
    Data Integration Hub
    ODS loader workflow file. The name of the workflow file depends on the type of database on which the ODS is installed:
    Database Type
    Workflow Location and Name
    Oracle
    <
    DIH
    InstallationDir>\powercenter\ETL\DX_ETL.xml
    Microsoft SQL Server
    <
    DIH
    InstallationDir>\powercenter\ETL\DX_ETL_SQLSERVER.xml
  3. If the Dashboard and Reports component was installed in the previous version of
    Data Integration Hub
    and you are upgrading to the current version from version 9.6.1, select the PowerCenter repository folder that contains the
    Data Integration Hub
    ODS loader workflow from the previous version as the import folder target.
  4. If the Dashboard and Reports component was installed in the previous version of
    Data Integration Hub
    , in the
    Conflict Resolution Wizard
    , select
    Replace
    . In the
    Apply this resolution to
    list, select
    All Conflicts
    . Click
    Next
    .
  5. In the Global Copy Options area select the options
    Retain Sequence Generator, Normalizer, or XML key current values
    and
    Retain Persistent Mapping Variable Values
    .
  6. Follow the instructions in the
    Import Wizard
    to complete the import of the workflow.

0 COMMENTS

We’d like to hear from you!