首页 » 编程开发 » Informatica » 正文

Informatica中workflow导入导出工具pmrep使用方法

pmrep是Informatica自带的workflow管理控制工具,它主要是对元数据进行操作,比如知识库用户、组、密码的管理,权限管理和数据库连接串的管理,元数据的备份导入导出等等。另外它还可以创建、修改、删除文件夹。它跟pmcmd命令一样都是经常会用到的workflow管理控制工具,关于pmcmd命令的介绍,可以参见之前的文章《Informatica中命令调用workflow的工具pmcmd使用方法》
pmrep命令我们一般用的最多的是它的导入和导出功能,本文主要对这两个命令介绍下。导入和导出功能可以让用户将元数据导出至其它业务智能工具或从其它业务智能工具导入元数据,例如 Cognos Report Net 和 Business Object。
导入命令格式:

pmrep>objectimport -help
Usage: objectimport
-i
-c
[-l ]
[-p (retain persistent value)]

相关参数解释:
1、-i input_xml_file_name,要导入的object(通常是xml格式)文件名称。
2、-c control_file_name,控制文件名。
3、-l log_file_name ,日志文件名称。

导入命令示例:

pmrep objectimport -i wf_IMPORT_TEST.XML -c test.xml -l wf_test.log

导出命令格式:

pmrep>objectexport -h
Usage: objectexport
{{-n
-o
[-t ]
[-v ]
[-f ]} |
-i }
[-m (export pk-fk dependency)]
[-s (export objects referred by shortcut)]
[-b (export non-reusable dependents)]
[-r (export reusable dependents)]
-u
[-l ]

相关参数解释:
1、-n object_name,需要导出的workflow名称。
2、-o object_type,导出的object类型,可以是”workflow”。
3、-f folder_name ,需要导出的workflow的存放文件夹。
4、-s -b -r:这三个参数可以使导出的workflow中包含所有map的信息。
5、-u xml_output_file_name,要导出的workflow保存文件名。

导入命令示例:

pmrep objectexport -n wf_name -o workflow -f folder_name -s -b -r -u exportfilename

以上就是pmrep导出和导入的简单命令介绍,下面附上pmrep语法规范:

$ pmrep -help

Informatica(r) PMREP, version [8.6.0 HotFix9], build [392.0525], AIX 64-bit
Copyright (c) Informatica Corporation 1994 – 2009
All Rights Reserved.
This Software may be protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775; 6,850,947; 6,895,471; 7,254,590 and other U.S. Patents Pending.

Invoked at Wed Dec 30 17:17:09 2015

Usage: pmrep run
-f
[-o ]
[-e (echo commands)]
[-s (stop at first error)]
[-u (UTF-8 encoded script file and output file)]

Usage: pmrep connect
-r
{-d |
{-h -o }}
[-n
[-s ]
[-x |
-X ]]
[-t ]

Usage: pmrep create
-u
[-s ]
[-p |
-P ]
[-g (create global repository)]
[-v (enable object versioning)]

Usage: pmrep delete
[-x |
-X ]
[-f (forceful delete: unregisters local repositories and deletes)]

Usage: pmrep upgrade
[-x |
-X ]

Usage: pmrep restore
-u
[-s ]
[-p |
-P ]
-i
[-g (create global repository)]
[-y (enable object versioning)]
[-b (skip workflow and session logs)]
[-j (skip deployment group history)]
[-q (skip MX data)]
[-f (skip task statistics)]
[-a (as new repository)]
[-e (exit if domain name in the binary file is different from current domain name)]

Usage: pmrep backup
-o
[-d ]
[-f (overwrite existing output file)]
[-b (skip workflow and session logs)]
[-j (skip deploy group history)]
[-q (skip MX data)]
[-v (skip task statistics)]

Usage: pmrep registerplugin
-i
[-e (update plug-in)]
[-l
[-w |
-W ]
[-k (CRC check on security library)]]
[-N (is native plug-in)]

Usage: pmrep unregisterplugin
-v
-l [-s (is security module)
[-g (remove user-name-login mapping)]
{-w |
-W }]

Usage: pmrep updatestatistics

Usage: pmrep updateemailaddr
-d
-s
-u
-f

Usage: pmrep updatetargprefix
-f
-s [.]
[-t ]
-p [-n (use target instance name; not using -n gives old, deprecated behavior)]

Usage: pmrep updatesrcprefix
-f
-s [.]
[-t ]
-p [-n (use source instance name; not using -n gives old, deprecated behavior)]

Usage: pmrep updateseqgenvals
-f
[-m ]
-t
[-s ]
[-e ]
[-i ]
[-c ]

Usage: pmrep listobjects
-o
[-t ]
[-f ]
[-c ]
[-r ]
[-l ]
[-b (verbose)]

Usage: pmrep listtablesbysess
-f
-s [.]
-t (source or target)

Usage: pmrep createconnection
-s
-n
-u
[-p |
-P ]
[-c (required for Oracle, Informix, DB2 and ODBC)]
-l
[-r (valid for Oracle connection only)]
[-e ]
[-f ]
[-z (valid for Sybase ASE and MS SQL Server connection)]
[-b (valid for Sybase ASE, Teradata and MS SQL Server connection)]
[-v (valid for Sybase ASE and MS SQL Server connection)]
[-d (valid for MS SQL Server connection only)]
[-t (enable trusted connection, valid for MS SQL Server connection only)]
[-a (valid for Teradata connection only)]
[-x (enable advanced security, lets users give Read, Write and Execute permissions only for themselves.)]
[-k (attributes have the format name=value;name=value; and so on)]

Usage: pmrep switchconnection
-o -n

Usage: pmrep deleteconnection
-n
[-f (force delete)]
[ -s ]

Usage: pmrep listconnections
[-t (output includes connection subtype)]

Usage: pmrep getconnectiondetails
-n
-t

发表评论