topic Re: SAP Business Object(BO) Integration with Databricks in Data Engineering

SAP Business Object(BO) Integration with Databricks

Mutharasu — Mon, 22 Jan 2024 08:48:49 GMT

Hi Team,

We are doing an analysis on SAP Business object to connect with databricks and built a report on top of the data in the data lakehouse. In our current architecture we have delta tables on top of S3 storage. Please let us know any connectors/drivers can be used by SAP business object to connect with databricks and pull the data for reporting.

Re: SAP Business Object(BO) Integration with Databricks

-werners- — Mon, 22 Jan 2024 14:43:21 GMT

If you can install the odbc drivers for databricks, you can create an odbc connection to the tables.
We do this with an old tool like SSRS, so I am pretty sure BO is also able to pull this off.

Re: SAP Business Object(BO) Integration with Databricks

Mutharasu — Thu, 25 Jan 2024 11:54:49 GMT

Thank you for the response. Look like my on-shore team(USA) contacted Databricks tech team and they have planned for a demo.

Re: SAP Business Object(BO) Integration with Databricks

swapnil2919 — Mon, 11 Mar 2024 19:31:23 GMT

Just a friendly reminder to post any updates on this thread. We are trying to connect SAP BO to Azure Databricks and notable to do it using JDBS/ODBA, hence the enquiry.

Re: SAP Business Object(BO) Integration with Databricks

HB83 — Thu, 21 Mar 2024 21:41:59 GMT

Hi @Mutharasu - Yes we have worked on this and able to successfully establish connectivity between BO and databricks using ODBC DSN connection. Simba Spark drivers needs to be installed. You need Auth token and Azure data source details like HTTP Path, Host, Port, to create DSN connection.

Re: SAP Business Object(BO) Integration with Databricks

bharat4880 — Tue, 16 Apr 2024 03:10:08 GMT

Hi @HB83 , Can I know which version of BO are you using? We have a similar requirement.

Re: SAP Business Object(BO) Integration with Databricks

cheenamalai — Tue, 10 Sep 2024 21:01:21 GMT

Could you please share the screenshot of the settings or process of setting this up? We are using BOBJ 4.2 SP9.