Report Builder and Oracle Database?

Hi,
I'm trying to use the report builder for the first time.
Is there a way to create an Oracle datasource in a report model project
?
Thanks,
PannaHi Panna,
AFAIK, Oracle is not supported currently, although it may be supported in a
future.
You can try linking the Oracle server to SQL Server using the Linked Servers
option in SQL Server. However, I've not tried this and I'm not sure if it
will work, actually. I'm not sure all the T-SQL syntax generated by the
Semantic Engine is available for linked servers.
HTH, however.
Jordi Rambla
MVP SQL Server (Reporting Services)
Solid Quality Learning (http://www.solidqualitylearning.com)
<panna_balaji@.yahoo.com> escribió en el mensaje
news:1157572466.694987.75740@.m79g2000cwm.googlegroups.com...
> Hi,
> I'm trying to use the report builder for the first time.
> Is there a way to create an Oracle datasource in a report model project
> ?
> Thanks,
> Panna
>|||you could created linked views in SQL Server and then use a tool like Access
Data Projects.
-Aaron
"Jordi Rambla" <jrambla@.hotmail.com> wrote in message
news:ezBi8Hm0GHA.3464@.TK2MSFTNGP03.phx.gbl...
> Hi Panna,
> AFAIK, Oracle is not supported currently, although it may be supported in
> a future.
> You can try linking the Oracle server to SQL Server using the Linked
> Servers option in SQL Server. However, I've not tried this and I'm not
> sure if it will work, actually. I'm not sure all the T-SQL syntax
> generated by the Semantic Engine is available for linked servers.
> HTH, however.
> Jordi Rambla
> MVP SQL Server (Reporting Services)
> Solid Quality Learning (http://www.solidqualitylearning.com)
> <panna_balaji@.yahoo.com> escribió en el mensaje
> news:1157572466.694987.75740@.m79g2000cwm.googlegroups.com...
>> Hi,
>> I'm trying to use the report builder for the first time.
>> Is there a way to create an Oracle datasource in a report model project
>> ?
>> Thanks,
>> Panna
>