Table of Contents

Search

  1. About the Enterprise Data Preparation Administrator Guide
  2. Introduction to Enterprise Data Preparation Administration
  3. Getting Started
  4. Administration Process
  5. User Account Setup
  6. Search Configuration
  7. Roles, Privileges, and Profiles
  8. Data Asset Access and Publication Management
  9. Masking Sensitive Data
  10. Monitoring Enterprise Data Preparation
  11. Backing Up and Restoring Enterprise Data Preparation
  12. Managing the Data Lakehouse
  13. Schedule Export, Import and Publish Activities
  14. Interactive Data Preparation Service
  15. Enterprise Data Preparation Service

Enterprise Data Preparation Administrator Guide

Enterprise Data Preparation Administrator Guide

Step 4. Restore the Data Preparation Repository

Step 4. Restore the Data Preparation Repository

Restore the Data Preparation repository, and then use the Administrator tool to configure the
Interactive Data Preparation Service
to use the repository schema.
  1. Restore the MySQL database or Oracle database used as the Data Preparation repository.
    For more information, see the MySQL documentation or the Oracle documentation.
  2. In the Administrator tool, select the
    Services and Nodes
    view.
  3. In the Domain Navigator, select the
    Interactive Data Preparation Service
    .
  4. In the
    Properties
    view, expand
    Data Preparation Repository Options
    .
  5. Click the
    Edit
    icon.
  6. Enter the properties required to connect to the Data Preparation repository.
    The following table describes the repository properties:
    Property
    Description
    Database Type
    Type of database to use for the Data Preparation repository.
    Host Name
    Host name of the machine that hosts the Data Preparation repository database. This property appears only if your Database Type is MySQL.
    Database Port Number
    Port number for the database. This property appears only if the Database Type is MySQL.
    Connection String
    Connection used to access the Oracle database.
    Use the following connection string:
    jdbc:informatica:oracle://<host name>:<port>;ServiceName=<database name>
    This field appears if you select Oracle as your Database Type.
    Secure JDBC Parameters
    If the database is secured, information such as TrustStore and TrustStorePassword can be included in this field. It is saved in an encrypted format. Parameters usually configured include the following:
    EncryptionMethod=<encryption method>;HostNameInCertificate=<hostname>;TrustStore=<truststore file with its location>;TrustStorePassword=<truststore password>;KeyStore==<keystore file with its location>;KeyStorePassword=<keystore password>;ValidateServerCertificate=<true /false>
    This field appears if you select Oracle as your Database Type.
    Database User Name
    Database user account to use to connect to the Data Preparation repository.
    Database User Password
    Password for the Data Preparation repository database user account.
    Modify Database User Password
    Select this checkbox to modify the database user password.
    Schema Name
    Schema or database name of the Data Preparation repository database.
    This field appears if you select MySQL as your Database Type.