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. Back Up the Enterprise Data Preparation Connections

Step 4. Back Up the
Enterprise Data Preparation
Connections

Back up the connection objects for the HDFS, Hive, and Hadoop connections used by the
Enterprise Data Preparation Service
.
Use the infacmd isp ExportDomainObjects command to export the connection object for each connection to an .xml file.
You can create an export control file to filter the objects to export from the domain. An export control file is an .xml file that you use with the infacmd isp ExportDomainObjects command. Specify the name of each connection 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 connection objects for the HDFS, Hive, and Hadoop connections used by the
Enterprise Data Preparation Service
:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <exportParams xmlns="http://www.informatica.com/tools/exportControl/9"> <objectList type="connection" > <object name="HDFS_CCO" /> </objectList> <objectList type="connection" > <object name="HIVE_CCO" /> </objectList> <objectList type="connection" > <object name="HADOOP_CCO" /> </objectList> </exportParams>
If you use an export control file, use the Administrator tool to find the name of each connection used by the
Enterprise Data Preparation Service
. If you do not use an export control file, the infacmd isp ExportDomainObjects command exports all native users, native groups, roles, connections, and cluster configurations from the Informatica domain.
For more information about creating export control files and using the infacmd isp ExportDomainObjects 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
    Data Lake Options
    .
  4. Copy the values for the
    HDFS Connection
    ,
    Hive Connection
    and
    Hadoop Connection
    properties.
  5. Expand
    Event Logging Options
    .
  6. Create an export control file to filter the objects that the infacmd isp ExportDomainObjects command exports.
    Specify the name of each connection object you want to export in an
    <objectList>
    element within the file.
  7. Run the following command:
    infacmd isp ExportDomainObjects -dn <domain name> -un <user name> -pd <password> -sdn <security domain> -fp <export file> -cp <export control file> -rp <true|false>
    The following table describes the infacmd isp ExportDomainObjects command options and arguments you might specify to export connection objects for the HDFS, Hive, and Hadoop connections:
    Option
    Argument
    Description
    -DomainName
    -dn
    domain_name
    Required. Name of the Informatica domain.
    -UserName
    -un
    user_name
    Required if the domain uses Native or LDAP authentication. User name to connect to the domain.
    Optional if the domain uses Kerberos authentication. To run the command with single sign-on, do not set the user name. If you set the user name, the command runs without single sign-on.
    -Password
    -pd
    password
    Required if you specify the user name.
    -SecurityDomain
    -sdn
    security_domain
    Required if the domain uses LDAP authentication. Optional if the domain uses native authentication or Kerberos authentication. Name of the security domain to which the domain user belongs.
    If the domain uses native or LDAP authentication, the default is Native. If the domain uses Kerberos authentication, the default is the LDAP security domain created during installation.
    -ExportFile
    -fp
    export_file_name
    Required. Path and file name of the export file.
    If you do not specify the file path, infacmd creates the file in the directory where you run infacmd.
    -ExportControlFile
    -cp
    export_control_file
    Optional. Name and path of the export control file that filters the objects to export.
    -RetainPassword
    -rp
    true|false
    Optional. Set to true to retain encrypted passwords for users and connections in the exported file. When set to false, user and connection passwords are exported as empty strings. Default is false.
    The following example exports the connection objects for the HDFS, Hive, and Hadoop connections defined in the specified export control file:
    infacmd isp ExportDomainObjects -dn InfaDomain -un Administrator -pd password -fp "/backup/idl_connections.xml" -cp "/backup/idl_exportControl.xml" -rp true