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 7. Back Up the Rules Metadata

Step 7. Back Up the Rules Metadata

If rules are configured for the
Interactive Data Preparation Service
, back up the rules metadata stored in the Model repository that contains rule objects and metadata.
The rules metadata is stored in projects in the Model repository. Use the Administrator tool to find the Model Repository Service used by the
Interactive Data Preparation Service
. Use the infacmd tools ExportObjects command to export the rule objects, the dictionary content, and the NER and Classifier model files from a project in the Model repository.
The infacmd tools ExportObjects command creates an .xml file that contains the rule objects. The command also creates a .zip file containing the dictionary content as .dic extension flat files and the NER and Classifier models as .ner and .classifer files.
Run the infacmd tools ExportObjects command to export rules metadata from each project that contains rules metadata. When you run the command, you specify the name of a project that contains the rule objects. You also specify the name of the Model Repository Service that manages the Model repository that contains the project. The Model Repository Service must be running when you run the command.
You can create an export control file to filter the objects to export from the Model repository. An export control file is an .xml file that you use with the infacmd tools ExportObjects command. Specify the name of each rule object you want to export in an
<objectList>
element within the export control file.
The following example shows an export control file that filters the rule objects to export from the Model repository:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <exportParams xmlns="http://www.informatica.com/tools/exportControl/9"> <folders> <folder recursive="false" select="all"> <objectList type="Rule" > <object name="validate_address" /> </objectList> <objectList type="Rule" > <object name="validate_USA_zip_code" /> </objectList> <objectList type="Rule" > <object name="validate_Canadian_postal_code" /> </objectList> </folder> </folders> </exportParams>
If you do not use an export control file, the infacmd tools ExportObjects command exports all objects in the specified project.
For more information about creating export control files and using the infacmd tools ExportObjects command, see the
Informatica Command Reference
.
  1. In the Administrator tool, select the
    Services and Nodes
    view.
  2. In the Domain Navigator, select the
    Enterprise Data Preparation Service
    .
  3. In the
    Properties
    view, expand
    Interactive Data Preparation Service
    Properties
    .
  4. Select the
    Interactive Data Preparation Service
    shown.
  5. In the
    Properties
    view, expand
    Model Repository Service Properties
    to identify the Model Repository Service used by the
    Interactive Data Preparation Service
    .
    You must identify each project within the Model repository that contains rules metadata.
  6. If the Model Repository Service is not running, recycle the Model Repository Service.
    For more information, see Step 6. Recycle the Application Services.
  7. Run the following command:
    infacmd tools ExportObjects -dn <domain name> -un <user name> -pd <password> -sdn <security domain> -pn <project name> -rs <Model Repository Service name> -fp <export file> -ow <true|false> -cp <export control file> -oo <options>
    The following table describes infacmd tools ExportObjects options and arguments you might specify to back up the Content Management Service metadata:
    Option
    Argument
    Description
    -DomainName
    -dn
    domain_name
    Name of the Informatica domain.
    -UserName
    -un
    user_name
    User name to connect to the domain. Optional if the domain uses Kerberos authentication.
    -Password
    -pd
    password
    Password for the user name.
    -SecurityDomain
    -sdn
    security_domain
    Name of the security domain to which the domain user belongs.
    -ProjectName
    -pn
    project_name
    Name of the project in the Model repository from which to export the rules metadata.
    -RepositoryService
    -rs
    service_name
    Model Repository Service name.
    -ExportFilePath
    -fp
    export_file_path
    Path and XML file name of the export file that contains the rules metadata. You can specify an absolute path or a relative path to the file name.
    -OverwriteExportFile
    -ow
    true|false
    Set to true to overwrite an existing export file. Default is false.
    -ControlFilePath
    -cp
    control_file_path
    Path and file name of the export control file that filters the exported objects.
    -OtherOptions
    -oo
    options
    Additional options to export the dictionary content and the NER and Classifier models to a zip file. Enter options using the following format:
    rtm:<option_name>=<value>,<option_name>=<value>
    Option names include:
    • codePage. Code page of the reference data.
    • refDataFile. Path and file name of the zip file where you want to export the reference table data.
    The following example exports the rules objects defined in the specified export control file from a project named TEST_PROJECT to the dq_rules_metadata.xml file. The example also exports the dictionary content and the NER and Classifier models from the project named TEST_PROJECT to a dq_rules_artifacts.zip file.
    infacmd tools exportObjects -dn InfaDomain -un Administrator -pd password -sdn native -pn TEST_PROJECT -rs MRS_dev2 -fp "/export/dq_rules_metadata.xml" -ow true -cp "/dq_rules_export.xml" -oo "rtm:codePage=UTF-8,refDataFile="/output/dq_rules_artifacts.zip""