Skip to Content
0
Former Member
Aug 18, 2015 at 10:54 PM

OLEDB, ODBC or JDBC?

305 Views

Given a choice of OLEDB, ODBC or JDBC for use in our BI 4.1 environment we are implementing, do you have a particular recommendation for which is better? Traditionally (in our XI 3.1 system), we've used ODBC, but having to maintain the ODBC connections on all the connection servers is not easy, so we were thinking of moving to OLEDB for BI 4.1. But now that OLEDB is not going to be available going forward, we're rethinking that decision.

My environment: BI 4.1 SP6 installed on a clustered Windows Server 2012 R2 environment, and 99% of all databases that it will connect to are SQL Server 2012. Migration to SQL Server 2016 is planned for December 2016/January 2017. We have not yet migrated from our current XI 3.1 system, so I have some time to "make the right choice".