ReportServer Forum

Neube

Member

Registered: 2019-06-12

Oracle Datasource Requirements

Hello Admin,

I am new in using Reportserver and planning to introduce it in our company to use it as a tool for our reporting. We are using a Oracle Database may i seek for your help on how to connect it and where to diwnload those necessary requirements.

I hope you can help me in this is very useful to us.

Thank you and God bless

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Oracle Datasource Requirements

Hi Neube,

for oracle, you have to download the drivers from the oracle website. The driver versions depend on your specific oracle version. Here you can find a compatibility matrix: https://www.oracle.com/technetwork/topi … 90281.html

Then you can download the reportserver software from our homepage. You can place the downloaded drivers in your WEB-INF/lib directory and then configure your persistence.properties file:

https://reportserver.net/en/guides/conf … roperties/

If you have a new version of oracle, you may need to write:
Oracle12cDialect

instead of
Oracle10gDialect

Regards,
Eduardo

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Oracle Datasource Requirements

Hi Neube,

the persistence.properties file has to be changed only if you need to install reportserver on oracle. If you only want to access your oracle database from withing reportserver, you can dowload the drivers, place them into the lib directory, and then create a new (relational) datasource that points to your oracle db: https://reportserver.net/en/guides/admi … tasources/

Regards,
Eduardo