|
PowerCenter MX SDK is not supported from 8.5 onwards. MX SDK was primarily used to browse the PowerCenter repository content using a Windows COM based API. MXSDK also allowed you to write back Source and Target objects to the repository. However, MXSDK had limitations since it ran only on Windows and not on Unix or Linux. Also, it did not allow updating of objects other than Source and Target definition.
If you have applications written using MXSDK prior to 8.5, then in 8.5 these applications need to be changed to work with one or more of the following alternate methods:
- PMREP : Repository command line function that provides several Repository administration functions including the ability to browse objects in the repository and import and export all objects via XML.
- MX Views: Set of published SQL based database views that allow you to query the repository content.
- Java Mapping Framework: A java based API that allows reading and writing various repository objects.
Refer to the Repository Guide for more details on PMREP and MX Views. Samples for the Java Mapping Framework is provided with the SDK install.
Example:
The following are example PMREP commands one can use to browse the repository content. You can use this method instead of MX SDK:
a) Connect to the repository
pmrep connect
-r
{-d |
{-h
-o }}
[-n
[-s ]
[-x |
-X ]]
[-t ]
b) List names of objects such as folders, or sources in a folder, workflows in folder etc
pmrep listobjects
-o
[-t ]
[-f ]
[-c ]
[-r ]
[-l ]
[-b (verbose)]
c) List details of one or more objects such as source, target, mappings etc. The details are exported in a PowerCenter export XML format.
pmrep 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 ]
|