Skip navigation

Log In

Forgot your password?
Don’t have an account? Sign Up

Sign Up

Access our rich network of apps, trials, and services.

Start the registration process by entering your email address below.

Already have an account? Log In

PowerCenter: Script to Import Objects

Free download

Posted by: Jeff Kinzer

Script using pmrep command to automate the import of all or selected objects into Informatica PowerCenter folder.

Overview

Here’s the companion script for the listing “PowerCenter : Script to Export Folder Objects” article. Use this script to import objects into PowerCenter.


One use for scripting an import would be to schedule it during off hours, for example, moving development code to production during off hours.

Overview of ObjectImport

Here is the basic object import syntax:


pmrep objectimport -i m_mapping_name.xml  -c import_Infa_Objects_Control.txt


The pmrep objectimport function is easy to use, it is a little different, however, in that you are required to use a “control file”, designated by the "-c", to define what PowerCenter folder and repository the objects will be imported into. There is an example Control File in the demo tab with important sections highlighted.


You must also use the control file to specify how to resolve conflicts, “Replace”, “Reuse”, etc., (see the RESOLVECONFLICT section). You can choose the option to generically “replace” all objects or you can specify Replace or Reuse by object type as defined in the TYPEOBJECT keyword, for example, in the control file in the demo tab, I choose to replace workflows but reuse schedulers.


Optionally, using the keyword TYPEFILTER, you can use the control file to filter which object types will get imported (applicable if you have a folder with many objects and various object types but only need to import a subset of those).


Script

This script has two import options, one to import a single object and the other option will loop over a folder containing multiple objects to import, you can use either one depending on your requirement, just comment out the object import you don't need.

 

You can download this listing as part of the PowerCenter : Useful Script files bundle.

Specifications

  • PowerCenter version 9.1 and 9.5

Seller

I work in Technology for a U.S. company. I have over 20 years experience working in information technology. I currently work with Informatica PowerCenter and Informatica Data Quality in an SAP, Unix, DB2 environment.

Resources

Comments Comments (2)

Related