Re: development tool for oracle and sql server

Microsoft SQL Server 2005 ships with (as part of the price) SQL Server Analysis Services, you can very easily create what is called a UDM which brings data sources together into a repository that can be reported against using Reporting Services (again, as part of the price - ships with SQL Server).

Once you've built your UDM, you can also use MS Office to query and create pivot tables against your multi-dimensional data set.

SSAS also offers proactive caching through query notifications now built into the SQL Server engine.

There are countless number of data sources you can use within your UDM, that includes Oracle.

-- 
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials

<akoutoulakis_at_gmail.com> wrote in message 
news:1145208042.015919.173120_at_j33g2000cwa.googlegroups.com...
>I would want to develop reports, that i use oracle and sqlserver


> simultanesly.Which is the best developmet tool for this?.

> Can anybody to advice me ?

>