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

Bundle: PowerCenter Script Files

Free download

Posted by: Informatica Marketplace

Informatica Marketplace PowerCenter Scripts help you decrease your implementation time. Download your free bundle of PowerCenter Scripts today!


The bundle contains the following set of listings. Visit individual listings for details.


1.  VBScript to combine XLSX files into a single file

This script will combine two Excels files into one workbook and can be used in a PowerCenter post-session task.


2.  Script : Repository Connection list & Attributes

A useful shell script to generate list and attributes of Database connections defined in PowerCenter repository.


3.  VBScript to Convert CSV to XLS

A reusable Visual Basic Script that will convert a CSV file generated by Informatica PowerCenter into a nicely formatted native Excel file.


4.  PowerCenter : Script to Export Folder Objects

Script using pmrep command to export all or selected objects from Informatica PowerCenter folder by using Query functionality.


5.  PowerCenter : Script to assign Object permissions

Script using pmrep command to assign permissions to PowerCenter folders, connections and query objects.


6.  PowerCenter : Script For Repository Backups

An example PowerCenter backup script and the visual basic script to delete files based on age.


7.  PowerCenter : Script to Unschedule All Workflows

A technique to unschedule all PowerCenter workflows automatically using MX views and pmcmd.


8.  PMREP Admin Scripts : Repository Management

Set of useful shell scripts for Informatica Administrators: Take backup of Multiple repositories, delete unwanted connection objects.


9.  PowerCenter : Unix Script to Create Multiple Users

Solution to create multiple users with help of MS Excel and Unix Shell Script.


10. Script to Analyze Session Log

This listing provides ability to read the session logs to capture the load statistics.


11. Script to Clean Up of Versioned Repositories

This script allows for cleaning up of older versions of repositories.


12. PMREP Admin Scripts : Repository Object Management

Set of useful shell scripts for Informatica Administrators: Export, Delete Multiple PowerCenter Repository Objects.


13. PMREP Admin Scripts : Folder Management

Set of useful shell scripts for Informatica Administrators: Create and Backup Multiple Repository Folders.


14. VB Script to convert multiple Excel files to CSV

A simple VB Script to convert your multiple Excel (xls) files to CSV format quickly.


15. Script : Identify and Abort Suspended Workflow

A Shell script template that lets you monitor workflow for suspended state and aborts it.


16. PowerCenter Startup Script with Database Check

A script that checks and verifies the database connections before starting Informatica PowerCenter.


17. Script to Create DI Service and Repository

Python script to create DI service and repository.


18. PowerCenter : Script to Import Objects

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


19. PowerCenter Script : Validate Folder Objects

PowerCenter scripts using pmrep commands to do bulk validation of PowerCenter objects in a folder.


20. Informatica Script – Check Service Status

Checks status of services running on Informatica server.


21. PowerCenter Flatfile source XML from Excel- Script

Automate the creation of source in PowerCenter Designer based on information provide in csv file.


22. Generate PMREP Script : Update Sequence Generator

Synchronize sequence generator transformations between PowerCenter environments by automatically generating PMREP scripts.


23. Pearl Script : Adding Newline Characters to Files

Perl script that converts the end-of-record delimiter in a flat file source to end-of-record followed by a new line character that can be run as a pre-session command.


24. SleepSavers : Smart Workflow Restart Tool

SleepSavers is a set of Python wrapper scripts designed to intelligently start and—if failure is detected—restart Informatica workflows to avoid nuisance production support and night time wake up calls for simple connectivity issues.


25. Excel Macro : Merge All Your Excel Files In To One

A very handy Excel Macro that allows you to merge data of all your excel files from the selected folders in to one.


  • Informatica PowerCenter 9.5.
  • Visit individual listings for more details.
Comments Comments (11)