question

Mohan avatar image
Mohan asked

Is SSRS is portable to other Database like Oracle

Does SSRS2008 reports portable to ORACLE DB

ssrsoracle
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Fatherjack avatar image
Fatherjack answered

Yes, SSRS will connect to an Oracle database, along with lots of other sources detailed here: http://msdn.microsoft.com/en-us/library/ms156450.aspx

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image
sp_lock answered

The quick answer is yes (see link below).

One thing that has caught me out in the past is executing SPs within SSRS. See the 2nd link

http://www.developer.com/db/article.php/3524781/Tap-into-Oracle-Databases-with-SQL-Server-Reporting-Services.htm

http://stackoverflow.com/questions/1089692/ssrs-report-from-oracle-db-use-stored-procedure

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.