DataStage with WBI

mydsworld · Post by **mydsworld** » Fri Mar 07, 2008 11:43 am

Is there any way to read/write data from WBI using DataStage.

Thanks

lstsaur · Post by **lstsaur** » Fri Mar 07, 2008 11:45 am

What's WBI?

ArndW · Post by **ArndW** » Fri Mar 07, 2008 11:55 am

I searched in Google and only found "Web Business Intelligence" but no specific database or data format so I am at a loss as well.

yserrano · Post by **yserrano** » Fri Mar 07, 2008 12:47 pm

Probably IBM WebSphere Business Integrator, an old version of WebSphere MQ Broker.

mydsworld · Post by **mydsworld** » Fri Mar 07, 2008 3:47 pm

Yes,by WBI I meant, WebSphere Business Integrator, can DataStage read/write data from it.

Thanks

yserrano · Post by **yserrano** » Sat Mar 08, 2008 10:55 am

can DataStage read/write data from it.

I am afraid I don't quite understand your question:
WBI is not a repository of data of any kind. It works as a router and reformatter of data but it does not storage it.

Your questions is a little vague, so I can only guess what you are trying to accomplish:
If you are looking for a DataStage Job Node to be included in a WBI Message Flow, it does not exist.
If what you need is a WBI Msg Flow Stage to use within a DataStage Job, it does not exist either.

But, you can try using WMQ queues as a mediator between both products.

Hope this helps

ray.wurlod · Post by **ray.wurlod** » Sat Mar 08, 2008 5:00 pm

You may be able to interface using an External Filter (or External Source or External Target) stage but, of course, what happens "inside" this stage actually happens outside of DataStage.