This topic has been locked.
2 replies Latest Post - 2009-12-27T17:14:15Z by Bromium
Pinned topic Distributed Platforms
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Has anyone used DataStage to integrate data across distributed platforms? Currently we use DataStage in corporate environments, where we are data warehousing, or integrating across tightly-coupled LAN systems. However, we are exploring using DataStage to push data down to our vast network of stores and were wondering if anyone else has successfully used DataStage (particularly USS) to accomplish anything like this? If so, do you have any observations, best practices, insights into making this work?
Updated on 2009-12-27T17:14:15Z at 2009-12-27T17:14:15Z by Bromium
Bromium 2700026WU23 PostsACCEPTED ANSWER
Re: Distributed Platforms2009-12-27T17:11:11Z in response to SystemAdminDataStage is an expensive tool if you want to use it for your file distribution mechanism.
Might I suggest that you keep it as your ETL process, and craft a different approach to update all of your stores. If you have a "vast network" then you know that some stores will be down from time to time. You'll need a re-transmit approach. You should also farm off that process onto a dedicated file server. I'm a DS Admin, if I saw one of my developers use DS in this way I'd have to step in and suggest a different approach.
Not sure what your company network is like in order to push new content to your stores, but that process should already be in place. You can push your Data Base update as a flat file to the store and trigger a local load process there. Optionally you might want to have your stores do a PULL rather than a PUSH out to them. This would help your multiple time zone issue in regards to hammering your file server on a nightly basis.