Searches only main IDN site
(Does not include forums. Click here for forum search.)
      
Login | Register

 

About IDN
  • About IDN

  • How to Contribute
  • Contact Us
  • Program FAQs
     

    Product Centers
  • PowerCenter
  • Power Exchange
  • Data Quality
  • Data Explorer
     

    Resources
  • Downloads
  • Discussion Forums
  • Webcasts
  • Product Documentation
     

    Member Services
  • Upgrade Membership
  • Update Profile
  • Change Password
  • Opt-in Email
     

    Professional Development
  • Certification Program
  • Product Training
  • User Groups
     

    Corporate Links
  • Informatica Home Page
  • Informatica Products
  • myInformatica
  • Informatica PowerCenter MX SDK Important Notice

    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 ]

    Contact IDN Customer Portal Terms of Use