| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| ICS Question - Can I use it for file to DB mappings??-Urgent |
« View previous topic :: View next topic » |
| Author |
Message
|
| WBIMaestro |
 Posted: Sun May 15, 2005 7:55 pm Post subject: ICS Question - Can I use it for file to DB mappings??-Urgent |
 |
|
Acolyte
Joined: 18 Feb 2005
Posts: 53
|
Hi All,
we have a legacy system, where about 49 different systems send in their data in their specific file formats to varoius folders. right now we have a bunch of shell scripts, cron jobs and utilities that read these files and update a central database store.
This process,as you can see has a lot of cutomisation and I would like to know if we could say, implement InterChange server to handle this transformation, say by creating mappings between the the various file formats and the Informix database tables. Also, does implementing ICS implicitly mean I have to have MQ (as in the case of WBI MB).
If there is any other product capable of handling this kind of work well also, please let me know ASAP.
Thanks,
Sailesh |
|
| Back to top |
|
 |
| vennela |
| Posted: Mon May 16, 2005 9:15 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
You can use ICS as the broker and JText adapter to handle files and JDBC adapter to handle DB calls on either side of ICS.
For this kind of solutions ICS is a very good fit. |
|
| Back to top |
|
|
| WBIMaestro |
| Posted: Mon May 16, 2005 9:54 am Post subject: |
|
|
Acolyte
Joined: 18 Feb 2005
Posts: 53
|
just one thing though. The file feeds that we receive in the respective folders will have a specific index/maser file that will have information about the rest of the files, from which data will have to be uploaded to the DB's. Would this kind of thing be possible with ICS.
Also, if you know of any online case studies redbooks etc...that i can use that would be great.
Thanks |
|
| 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
|
|
|
|
