cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

SAP Business Object(BO) Integration with Databricks

Mutharasu
New Contributor II

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. 

6 REPLIES 6

-werners-
Esteemed Contributor III

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.

Kaniz
Community Manager
Community Manager

Thank you for posting your concern on Community! To expedite your request, please list your concerns on our ticketing portal. Our support staff would be able to act faster on the resolution (our standard resolution time is 24-48 hours).

Mutharasu
New Contributor II

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

swapnil2919
New Contributor II

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.

HB83
New Contributor II

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. 

bharat4880
New Contributor II

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

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!