JDBC or ODBC driver for BusinessObjects WEBI/IDT

[prefer-not-to-say]

Hi

My Organisation has used the UDT and a Oracle OCI Driver on BO 42 SP3

We have recently updated to BO 42 SP8 Patch 7

We are looking to use the IDT to create a Multi Source Universe.

We have a requirement to connect to Oracle 12 and Amazon Redshift to produce some reports.

I am looking to setup the Oracle 12 and Amazon Redshift drivers.

I have the choice of JDBC or ODBC Drivers.

Which should I choose?

Does one perform better than the other, does one have features not available in the other, does one offer features in the WEBI client that the other does not, As long as the Reports come back with the correct data, I don't mind which one I use

On my development system
I have created DSN's for my ODBC Drivers
What would I need to do to correctly configure my JDBC Drivers, if I choose to use them.

Any links to blog posts would be useful,
along with any differences between 32bit client drivers and 64bit server drivers.

Thanks

Clive

[ayman_salem]

1. The 64-bit driver is required when you access the report from the BI server.

2. If your BI server is running on Unix System (Linux, AIX, ...) , you should use JDBC as the ODBC driver is only provided by third parties (buy, ... cost factor, support, ...)

3. ODBC have some limitation that is not by JDBC.

here is a comparison https://www.educba.com/jdbc-vs-odbc/

[prefer-not-to-say]

Hi Ayman

Thanks for the advice, interesting read jdbc-vs-odbc

Running on Windows Server, I am thinking of going JDBC

How do I go about configuring my Server JDBC Drivers?
I have seen .sbo files and <ClassPath>, but not sure what settings I would need to use.

I would need to configure for Oracle 12 and Amazon Redshift.

[ayman_salem]

Simply define a new connection and select the correct driver and enter the required data