How to activated branded ODBC drivers on a Linux environment?

[marco_79]

Dear experts,

Does anyone have experience with activating the branded ODBC drivers on a Linux environment? I've been browsing and trying (trial and error) for a week now and I'm not really making any progress with the configuration. I want to make connections (via Universes) to a SQL Server Db, an IBM Db2 and an Oracle Db, among others. Can someone explain to me in 'simple' steps what exactly to configure/activate and where exactly. This is the first installation I have done on a Linux environment and it is a bit different than on Windows. I misjudged it a bit. Hope someone can help me further.

Thank you in advance!

Regards, Marco

I followed the blog below and several KBA's.

https://blogs.sap.com/2014/09/12/steps-to-configure-data-direct-branded-drivers-in-bi-41-2/

BI version: SAP BusinessObjects BI Platform 4.3 Support Pack 3 Patch 7

OS Environment (application): Red Hat Enterprise Linux 9.3

Connection setup via client: Information Design Tool 4.3 Support Pack 3 Patch 7 (server middleware setup)

[marco_79]

Hi Daya,

Thanks for your comment! The connection to the SQL Server is now successful with the extra parameter setting in the env.sh file. How exactly does it work with the connections to DB2 and Oracle. Can this also be done directly without having to install DB2- or Oracle drivers (via data direct branded drivers)? This is not completely clear to me yet.

Thank you in advance!

Regards, Marco

[DayaJha]

Hi Marco,

Please refer below SAP KBA regarding DSN setup in unix platform

1607125 - How to configure SQL Server connectivity for WebIntelligence from a BI 4.0 & 4.1 UNIX or L...

2049149 - BI 4.x WebI: Which ODBC Drivers Can Be Used with MS SQL Server in Linux?

819829 - Oracle Instant Client Installation and Configuration on Unix or Linux

https://www.ibm.com/support/pages/howto-setup-odbc-application-connectivity-linux

I hope this will help!!!!

Regards,

Daya Jha