| Author |
Message
|
| EternalLearner |
 Posted: Thu Aug 09, 2012 2:18 am Post subject: Doing FTP Once Everyday At A Fixed Time |
 |
|
Novice
Joined: 20 Jul 2012
Posts: 16
|
Hi,
I'm having a requirement where need to pick up a file from a remote server once everyday at 8 AM and process it.
However it seems this reading from remote server can't be triggered and rather it can only scan at specified intervals.I assume this because FileRead node doesn't have FTP option.
Can you suggest if anyway FTP can be triggered and any idea why FTP facility hasn't been provided with FileRead node.
On a separate note can MB transfer a file in some way to a remote destination which doesn't have MQ, FTP,TCP/IP nething. In other words copying a file to a remote destination without any standard protocols. I'm assuming the answer is 'No' but still happy to be suggested.
Thanks. |
|
| Back to top |
|
 |
| Vitor |
| Posted: Thu Aug 09, 2012 2:30 am Post subject: Re: Doing FTP Once Everyday At A Fixed Time |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| EternalLearner wrote: |
| Can you suggest if anyway FTP can be triggered and any idea why FTP facility hasn't been provided with FileRead node. |
To your first point, there are any number of discussions on this forum about scheduling a flow to run at a specific time; you can review these & see if any are appropriate to your situation. Using these, you can trigger a flow with a FileInput node at 8am & that can ftp the file.
An alternative is to ask why the file can't be ftp'd onto the WMB server at 8am, i.e. pushed not pulled. Or copied from some staging directory into the directory the FileInput node is scanning at 8am.
As to the second point, it's not a common use case for the FileRead node. Doing an ftp is time consuming so you do it once at the start or the end of your processing. A FileRead is intended for look up on the broker machine. There's a link for requesting enhancements you can use to suggest it's added which you''ll also find discussed in here.
| EternalLearner wrote: |
| On a separate note can MB transfer a file in some way to a remote destination which doesn't have MQ, FTP,TCP/IP nething. In other words copying a file to a remote destination without any standard protocols. I'm assuming the answer is 'No' but still happy to be suggested. |
What kind of destination doesn't support TCP/IP? This implies it doesn't have a network connection and is a standalone box! 
On the face of your question then if there's no way to reach this remote destination then obviously you can't transfer a file to it. Presumably this destination is at present actually used for something and hence data does indeed flow on and off it. WMB can use this method. As a minimum you can mount one of this machine's drives and avoid a protocol transfer.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| marko.pitkanen |
| Posted: Thu Aug 09, 2012 2:36 am Post subject: |
|
|
Chevalier
Joined: 23 Jul 2008
Posts: 440
Location: Jamsa, Finland
|
Hi EternalLearner,
If there is no built-in functionality, you can perhaps consider to implement it with java ( or in v8 also with .Net).
To trigger something happen in particular time / date use external job scheduler like unix cron etc.
--
Marko |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Aug 09, 2012 2:58 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You should use MQ FTE for scheduled transfers.
You certainly can't use Broker to transfer a file to a server that has no access from external systems.
You can certainly use Broker to write a file to a locally-accessible file share, regardless of where that fileshare actually lives. |
|
| Back to top |
|
|
| zpat |
| Posted: Thu Aug 09, 2012 3:01 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
Use a scheduler on the origin system to place the file in the directory that is scanned by a fileinput node, at the desired time.
Or just rename the file to match the scanned pattern, at the desired time.
Use cron if nothing better is available. |
|
| Back to top |
|
|
| EternalLearner |
| Posted: Thu Aug 09, 2012 6:44 am Post subject: |
|
|
Novice
Joined: 20 Jul 2012
Posts: 16
|
Thanks all for the suggestions. I've got the technical aspects available for this. However following are the project decisions which I've to abide by.
1. Can't use MQFTE. Need to use Broker
2. The flow will run all the time.
3. The production environment is windows.
So based on these and your suggestions and also not to complicate the solution I believe I'll just let the FileInput node to scan the remote server at 20-30 mins interval(Though most of these scanning are of no use) but it shouldn't miss the entire interval beetween 8 Am and 9 AM.
On the second point of transferrring a file to a remote location without FTP etc, I wronglyy mentioned about TCP/IP as well but following is what project management want to do and I feel laughing about it.
1. FTP the file to a location.
2. Somebody will manually transfer it to another remote location which doesn't have FTP at 9 AM.
Locally accessible fileshare is an option I see and let me try to put this across to management.
Thanks again guys. |
|
| Back to top |
|
|
|
|
