Oracle Bi Solutions

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Friday, 5 April 2013

Configure Informatica Integration Services to Consistently Use the Same Port

Posted on 07:43 by Unknown

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.
Assign the Custom Property and Available Port value and restart the Integration Service by disabling and enabling the Integration Service.
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.
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Posted in Informatica | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • Upper Function
    In Oracle/PLSQL, the  upper function  converts all letters in the specified string to uppercase. If there are characters in the string that ...
  • OBIEE 11g Hide/Show Sections based on Dashboard Prompt
    allow a user’s interaction to hide/show certain sections of a dashboard. In this particular case the user wanted to choose either ‘Quarterly...
  • [OBIEE11g] - OBIEE Dashboard for Informatica Metadata Reporting
    The metadata that Informatica Power Center 8 retains in its repository can be exposed via OBIEE reports and dashboards. This metadata includ...
  • [ODI] - Frequently Asked Questions (FAQ)
    Here is a list of FAQs about Oracle Data Integrator 1) What is Oracle Data Integrator (ODI)? 2) What is E-LT? 3) What components make up Ora...
  • OBIEE 11g not showing new dashboard in the drop down menu
    When creating New dashboard in  OBIEE 11g, I have faced with issue that dashboard name did not show up in drop down dashboard menu. 1. When ...
  • Data Modeling: Schema Generation Issue with ERwin Data Modeler 7.3
    We are using Computer Associate’s ERwin Data Modeler 7.3 for data modeling. In one of our engagements, we are pushing data model changes to ...
  • Installation Informatica Powercenter 9.1 on Oracle Enterprise Linux 5.6
    Ingredients: Program Version Filename Oracle Express 11G 11.2.0 oracle-xe-11.2.0-0.5.x86_64.rpm SQL Developer 3.0 sqldeveloper-3.0.04.34-1.n...
  • Informatica Powercenter Workflow Manager Repository Navigator docking float issue
    In case you’re also experiencing where your Repository Navigator is not dock or attached and it seems just floating within Workflow Manager ...
  • [OBIEE11g] - Creating Dashboard Traversing Through Graph
    The general requirement asked for by customers is that they want to Click on the Main Dashboard Page’s Graph and be transferred to the other...
  • OBIEE 11g - Query Limit
    Query limit and number of minutes a query can run per physical layer database connection, follow the below steps. > Login to Repository u...

Categories

  • BI Publisher
  • DAC
  • DataWarehouse
  • Hyperion
  • Informatica
  • OBIEE
  • ODI
  • Oracle Applications EBS 12.1.3
  • Oracle Database
  • PL/SQL
  • SQL
  • Unix/Linux

Blog Archive

  • ▼  2013 (500)
    • ►  November (8)
    • ►  October (1)
    • ►  July (4)
    • ►  June (9)
    • ►  May (15)
    • ▼  April (24)
      • OBIEE 11g - Migration steps in OBIEE11g
      • Column Indent Background Color Changing in Pivot T...
      • Oracle Data Integrator 11.1.1.7 installation on Linux
      • OBIEE 11g -- Daily Catalog Backup Script Linux
      • Disabling Right Click on OBIEE with javascript
      • DAC Error Message – No Physical folder information...
      • Informatica PowerCenter Server Status URL
      • Informatica Error Calling PMREP or PMCMD – Librari...
      • Configure Informatica Integration Services to Cons...
      • OBIEE 11g Pre-Requisites Kernel Failure
      • OBIEE 11g on DHCP Assigned Network
      • OBIEE 11g - Linux User and Groups Setup for OBI11g...
      • OBIEE 11g - MDS or BIPLATFORM Schema Password Chan...
      • OBI 11g - Linux Start Up Best Practice
      • SQL Fiscal Calendar Build Script
      • Hyperion - Desable (UAC) Before Installing Oracle...
      • OBIEE 11g - Upgrade RPD to Latest Oracle BI 11g Ve...
      • OBIEE 11g - Stopping Oracle BI 11g on Windows with...
      • OBIEE 11g - Known issues
      • OBIEE 11g - In-place upgrade of a scaled-out BI do...
      • OBIEE 11g - In-place upgrade from 11.1.1.6 to 11.1...
      • OBIEE 11.1.1.7 New Features
      • OBIEE 11.1.1.7 - Where are all my Right Click opti...
      • OBIEE 11.1.1.7 is available
    • ►  March (43)
    • ►  February (73)
    • ►  January (323)
Powered by Blogger.

About Me

Unknown
View my complete profile