| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Informatica Powercenter Integration with MQ |
« View previous topic :: View next topic » |
| Author |
Message
|
| skrv |
 Posted: Tue Sep 06, 2016 9:39 am Post subject: Informatica Powercenter Integration with MQ |
 |
|
Centurion
Joined: 26 Oct 2012
Posts: 118
|
Hi,
We have MQ 7.5 on a z-linux server and it also hosts Informatica powercenter client.
we want to integrate both.
From the Informatica documentation it seems they need either client connection channel or svrconn channels to connect to MQ. I also see it specify about below environment variable
MQSERVER=channel_name/TCP/'hostname(port)'
My Question: Since both MQ server and Informatcia powercenter client is installed on same server, why do they need client channel? is there any other way to configure this setup?
thanks |
|
| Back to top |
|
 |
| bruce2359 |
| Posted: Tue Sep 06, 2016 10:31 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
I'm going to guess that the Informatica client component is bound to MQs client library, rather than MQs server-bindings library.
Contact Infirmatica to see if they can provide a server-bindings version of the same program
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| exerk |
| Posted: Tue Sep 06, 2016 11:24 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
Also, if it can't use MQ server bindings and can only use the MQ client libraries, have Informatica clarify whether it can use either an MQ client ini file or can use MQCONNX to build its end of the client channel because you can't use SSL/TLS to secure the channel.
I'm reasonably sure that PowerCentre can use a Java client so can access a jks key store etc., but as being wrong most of the time is my default state, don't quote me on that! 
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| skrv |
| Posted: Tue Sep 06, 2016 11:30 am Post subject: |
|
|
Centurion
Joined: 26 Oct 2012
Posts: 118
|
| so If Informatica cant use MQ server bindings then we have to create a SVRCONN channel for them and then use MQSERVER environment variable to setup the connectivity? |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Tue Sep 06, 2016 1:23 pm Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
Yes.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| exerk |
| Posted: Tue Sep 06, 2016 1:27 pm Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
| skrv wrote: |
| so If Informatica cant use MQ server bindings then we have to create a SVRCONN channel for them and then use MQSERVER environment variable to setup the connectivity? |
Yes, you will have to create a SVRCONN channel, but do not use the MQSERVER environment variable method if there is an alternative to doing so, e.g. mqclient.ini file, or the other MQ-related variables that can be used.
Take a look at THIS, and THIS, and possibly THIS (which contains a YouTube video how-to, albeit using the MQSERVER variable), but I refer you back to my previous statement about the Java client - which should have read JMS (sorry!).
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
