Metadata Manager Command Reference

10.5.1
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.2
- 10.5
- 10.4.0

Back Next

mmLineageMigrator Options

mmLineageMigrator uses the following options:

<<-dt>>: Database type for the Metadata Manager repository database.

Specify one of the following types:

DB2

ORACLE

SQLSERVER

<<-du>>: Database user name for the Metadata Manager repository database.

<<-gd>>: Directory where the program creates the graph database files. Must match the Metadata Manager lineage graph location that you configure for the Metadata Manager Service in the Administrator tool. If the directory contains spaces, enclose it in double quotes.

<<-dp>>: Password for the Metadata Manager repository database user.

<<-url>>: JDBC URL for the 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.

[-h]: Displays help for the mmLineageMigrator command line program. The help option lists the mmLineageMigrator options and arguments.

Rename Saved Search

Table of Contents

Metadata Manager Command Reference

Metadata Manager Command Reference

mmLineageMigrator Options

mmLineageMigrator Options