cancel
Showing results for 
Search instead for 
Did you mean: 

Pushing dataframes from Azure databricks to SAP HANA

mayank_gupta01
Employee
Employee

Hello,

I using this blog as a base for this question "https://blogs.sap.com/2019/10/24/your-sap-on-azure-part-22-read-sap-hana-data-from-azure-databricks/"

I am able to access HANA data in databricks via JDBC connector i.e. ngdbc.jar, now I am trying to push processed data back to HANA.

I tried using the same jdbc connector to push/write but it didn't worked so far for me.

can anyone help me here please.

Accepted Solutions (0)

Answers (1)

Answers (1)

dvankempen
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Mayank,

What exactly is the question?

What is the objective?What steps have been performed? What works, what doesn't? Print screens, code samples, etc.

I understand you have created a connection between SAP HANA Cloud using JDBC (from the blog post comment).

This connection works for read but not for writes?

mayank_gupta01
Employee
Employee

Hi Denys,

I wanted to connect from Databricks to HANA using JDBC and push the data frames as table in Hana instance.

I am able to read tables in databricks using JDBC, but not able to push the data or create tables back to Hana instance.

Vitaliy-R
Developer Advocate
Developer Advocate

mayank.gupta01 , Pandas dataframes can be persisted in SAP HANA using `hana_ml` Python library: https://help.sap.com/doc/1d0ebfe5e8dd44d09606814d83308d4b/2.0.05/en-US/html/hana_ml.dataframe.html#h...