IT Employment

Ask something
Question Locked

Exposing Data in datawarehouse as web services

0 helpful
3 replies

by kohli.vikram1982

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi All,

We have a requirement of exposing the data in our data warehouse as Web services to external clients. Data is in millions(say 20 million). What could be the possible solution for this requirement.

We are working with Oracle 10g.

~Vikram

3 replies

by robo_dev

There are many reporting solutions out there (e.g. Crystal Reports, Actuate) that are pretty simple to implement.

if you need interactive database access, then it gets more complicated. There's actually a very powerful and cheap web-app developer tool called ASP Maker. There is also a PHP, .Net, and Java version of the same tool. You point this at the database and it can create fully functional web pages with various types of query capability. www.hkvstore.com

by kohli.vikram1982

Thanks robo for reply.
Well, we have various input conditions on whihc we will generate a dynamic query, based on which we will fetch up the data from warehouse.

As per requirment ,we have to implement it as web service. Calling application will invoke the relevent web service. Which will return the relevent data.

But the problem here is that, data volumne is two high(more then 5 millions).

Now how I can achieve it?

Regards,
Vikram

This discussion is closed to new replies.