Select Page

Configure Informatica Integration Services to Consistently Use the Same Port

Author: Christian Screen | | September 8, 2010

One of the interesting aspects that is often overlooked by Informatica integrators is the fact that each PowerCenter Integration Service actually listens on a single port. When Informatica PowerCenter server is installed it seeks to have the available/usable port range defined by the server administrator. This default range sits in the 6000’s (see the Informatica PC documentation for precise details), but if one is so inclined, one could change the default range.  Ultimately since most people accept the defaults the admin console is accesses on port 6001, etc.  The rub here is that when you create and start an Informatica PC Integration Service by default that service gets assigned a random port to listen on for incoming requests.  Typically the random port isn’t so random and usually the assignment is one of the lower ports on the range selected during the installation. But what if you always want to know the port one should reference for an Integration Service specifically created for single integration?  Don’t worry this is possible.

Many of those involved with Oracle Business Intelligence (OBIEE) know that a setting is configured when setting up the Informatica OEM component for the pre-built analytic applications.  Most of these implementers don’t bother to understand what is being accomplished when setting this specific custom property, ServerPort.  Regardless of the implementation or integration by accessing the Integration Service’s properties, and creating a Custom Property called ServerPort and assigning an available port value, the integration service when it starts up (or restarted after initial creation of this custom property) will be assigned this port value to listen.

Here are a few short steps to follow in order to configure and test so that you can see how it works and use on your next project.

Run Netstat -a -n from a command prompt before configuring the custom property to see the random port your service is listening on.
[simage=123,400,y,center]

Assign the Custom Property and Available Port value and restart the Integration Service by disabling and enabling the Integration Service.
[simage=120,400,y,center]
[simage=121,400,y,center]
[simage=122,400,y,center]

Run netstat -a -n to verify that your Integration Service is listening on the port you’ve configured with the Custom Property value for ServerPort.
[simage=124,400,y,center]

The reasons behind using this Custom Property may vary but the value should be evident. Good Luck.

Oracle BI Publisher (BIP) Tips: Functions, Calculations & More

Check out these BI Publisher tips including functions & calculations so you can understand more about the production and support of BI Publisher reports.

Sherry Milad | January 15, 2018

How to Index a Fact Table – A Best Practice

At the base of any good BI project is a solid data warehouse or data mart.

Christian Screen | March 16, 2010

Qlik vs. Tableau vs. Power BI: Which BI Tool Is Right for You?

Tableau, Power BI, and Qlik each have their benefits. What are they and how do you choose? Read this blog post for a quick analysis.

Tom Hoblitzell | June 6, 2019

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS