Table of Contents

Search

  1. Preface
  2. mmcmd
  3. mmLineageMigrator
  4. mmRepoCmd
  5. mmXConPluginUtil
  6. rcfmu
  7. rmu

Metadata Manager Command Reference

Metadata Manager Command Reference

rcfmu Options

rcfmu Options

rcfmu uses the following options:
<<-dt>>
Database type for the original Metadata Manager repository database.
Specify one of the following types:
  • DB2
  • Oracle
  • "Microsoft SQL Server"
<<-u>>
Database user name for the original Metadata Manager repository database.
<<-rn>>
Name of the new resource. If the name contains spaces, enclose it in double quotes.
[<-ep>]
Required to specify an encrypted password. Encrypted password flag. Use with the password option to indicate that the password for the database user name is encrypted.
<<-smv>>
Metadata Manager source version.
Specify one of the following versions:
  • 9.1.0
  • 9.1.0.HF1-SNAPSHOT
  • 9.1.0.HF2-SNAPSHOT
  • 9.1.0.HF3-SNAPSHOT
  • 9.1.0.HF4-SNAPSHOT
  • 9.1.0.HF5-SNAPSHOT
  • 9.1.0.HF6-SNAPSHOT
  • 9.5.0
  • 9.5.1
  • 9.5.1.HF1
  • 9.5.1.HF2
  • 9.5.1.HF3
  • 9.5.1.HF4
  • 9.6.0
  • 9.6.1
  • 9.6.1.HF1
  • 9.6.1.HF2
  • 9.6.1.HF3
  • 9.6.1.HF4
  • 10.0.0
  • 10.1.0
  • 10.1.1
  • 10.1.1HotFix1
  • 10.1.1HotFix2
  • 10.2.0
  • 10.2.0HotFix1
  • 10.2.0HotFix2
To get the Metadata Manager source version number, run the mmcmd version command in the original Metadata Manager version.
<<-rcf>>
File path and file name of the resource configuration file that you want to migrate.
[<-src>]
File path of metadata source files for the original resource. Required for Embarcadero ERStudio, MicroStrategy, and SAP PowerDesigner resources.
<<-pw>>
Password for the database user name.
<<-durl>>
JDBC URL for the original Metadata Manager repository database.
The syntax depends on the repository database type:
  • For IBM DB2, use the following syntax:
    "jdbc:informatica:db2://[host name]:[port];DatabaseName=[database name]"
  • For Microsoft SQL Server, use the following syntax:
    "jdbc:informatica:sqlserver://[host name]:[port];SelectMethod=cursor;DatabaseName=[database name]"
    To authenticate the database user credentials using Windows authentication and establish a trusted connection to a Microsoft SQL Server repository, append
    ;AuthenticationMethod=ntlm
    to the URL.
    When you use a trusted connection to connect to a Microsoft SQL Server database, the Metadata Manager Service connects to the repository with the credentials of the user logged in to the machine on which the service is running.
    If you run the program from a machine on which Informatica is not installed, configure the PATH variable to point to the location of the DDJDBCAuth04.dll file.
  • For Oracle, use the following syntax:
    "jdbc:informatica:oracle://[host name]:[port];SID=[sid]"
    You can enter the SID or use the full service name. For example:
    "jdbc:informatica:oracle://[host name]:[port];ServiceName=[service name]"
    If the Oracle database is clustered, use the following syntax:
    "jdbc:informatica:oracle://[host1]:[port];ServiceName=[service name];AlternateServers = ([host2]:[port]);LoadBalancing=true"
    If the Oracle database uses the Advanced Security Option, use the following syntax:
    "jdbc:informatica:oracle://[host name]:[port];SID=[SID];EncryptionLevel=[encryption level];EncryptionTypes=[encryption types];DataIntegrityLevel=[data integrity level];DataIntegrityTypes=[data integrity types]"
If secure communication is enabled for the Metadata Manager repository database, you must append additional JDBC parameters to the JDBC URL.
<<-connection_assignment>>
Specifies whether to retain connection assignments in the new resource configuration file.
Enter one of the following arguments:
  • Retain
    . rcfmu migrates connection assignments to the new resource configuration file. If a connection name changed, you must reassign the connection in the new resource.
  • Discard
    . rcfmu does not migrate any connection assignment. However, Metadata Manager automatically configures connection assignments for the new resource when you load it.
[<-nrd>]
File path for the new resource configuration file. If you do not specify a file path, rcfmu creates the new resource configuration file in the directory where you run it.

0 COMMENTS

We’d like to hear from you!