| Author |
Message
|
| kirank |
 Posted: Thu Jan 27, 2011 10:35 am Post subject: FTP Server Configurable Service |
 |
|
Centurion
Joined: 10 Oct 2002
Posts: 136
Location: California
|
Hi,
As I understand I can specify FTP Server Configurable Service Name in the Remote Server and Port property on the FTP tab of the File Output node.
Can we set this configurable service name dynamically in ESQL using Local Environment? I am exploring option to route FTP files dynamically using File Output Node and Configurable Service. I can determine the configurable service name based on a config file or from a database table but I was not sure about the Local Environment to set Configurable service name so the question?
Thanks in Advance
Kiran |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Thu Jan 27, 2011 10:49 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| You can't dynamically choose the FTP destination. In the current product. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Thu Jan 27, 2011 11:34 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Using amsmqget sample code, in an hour or two, you can have a utility that reads from a queue, reads the MQMD.ApplIdentityData and opens an FTP channel to the destination listed in MQMD.ApplIdentityData.
Therefore, to have MQ Broker send an MQ Message to a remote host using FTP, in the Broker have a JCN or ESQL node set the MQMD.ApplIdentityData to the remote host.
Optionally, MQMD.AccountingToken bytes 0 to 15 could contain a user Id for the remote host and MQMD.AccountingToken bytes 16 to 31 could contain a password for said user Id.
Of course, my comrades may appreciate this creative outside the box thinking. Let's hope future product versions would reduce this to inside the box. Seems like a common function that would be used often.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Jan 27, 2011 11:46 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You could also use MQFTE, or any number of other supported file transfer solutions, including Sterling Connect or etc. that are actually designed to provide production caliber file moving solutions.
Or Roger's file mover thingy, or any number of other free and opensource file transfer solutions, at least some of which have MQ interfaces.
I mean, while we're thinking outside the box, let's consider options other than "roll our own solution and relearn hard lessons the hard way". |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Thu Jan 27, 2011 11:49 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Excellent point, mqjeff.
Next time I need soap or toothpaste, I'll check the grocery store first. You look like you’ve got a good message header on your shoulders.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Jan 27, 2011 12:02 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
It happens that I spent three years writing and supporting bespoke software that read data from MQ and packaged it into either email or shipped it over FTP.
This is a significantly harder problem to solve in a production ready manner than it sounds like. When I say there are hard lessons, I mean there are *hard* lessons.
So, pardon me if thinking that whipping something up from amqsget0.c is anything other than  |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Jan 27, 2011 12:25 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqjeff wrote: |
| This is a significantly harder problem to solve in a production ready manner than it sounds like. |
Though it's one of those things that sounds really simple.
But the hidden complexity is one of the reasons people make money selling commercial solutions; the TCO of such things tends to be smaller that home grown solutions.
I speak as an ex-CommerceQuest employee, who spent many happy hours watching the PM4Data developers beating their heads against various hard surfaces.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Thu Jan 27, 2011 12:27 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
To follow from mqjeff's warning, also beware those snake oil salesmen who say,
I can do that in <insert hugely expensive three letter product name here> in less than 5 minutes.
Making something 'Production Quality' takes care & time. Sometimes this is very much at odds in places where PHB's who are into the '5 mniute' solution rule the roost.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
|
|
