You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@arrow.apache.org by "avhz (via GitHub)" <gi...@apache.org> on 2025/02/20 15:04:56 UTC
[I] Support SAP HANA [arrow-adbc]
avhz opened a new issue, #2542:
URL: https://github.com/apache/arrow-adbc/issues/2542
### What feature or improvement would you like to see?
Bit of a long shot but would there be any interest in supporting SAP HANA in Python/R ?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@arrow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Support SAP HANA [arrow-adbc]
Posted by "ThomasBlauthQC (via GitHub)" <gi...@apache.org>.
ThomasBlauthQC commented on issue #2542:
URL: https://github.com/apache/arrow-adbc/issues/2542#issuecomment-4108917363
>From that documentation it looks like SAP might be creating their own proprietary SQLDBC layer that the ODBC driver and others are built on top of. It might be nice to dive a little deeper into that, but the documentation suggests that is sadly only for internal use
Just for the record: There is a specification of the hana protocol available [here](https://help.sap.com/doc/63cef00e229b4010be06cfa01e1d338b/2.0.03/en-US/SAP_HANA_SQL_Command_Network_Protocol_Reference_en.pdf). Unfortunately, it is incomplete and sometimes inconsistent. But definitely a valuable resource.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Support SAP HANA [arrow-adbc]
Posted by "ianmcook (via GitHub)" <gi...@apache.org>.
ianmcook commented on issue #2542:
URL: https://github.com/apache/arrow-adbc/issues/2542#issuecomment-4103439484
Update: The crew at @columnar-tech built an ADBC driver for SAP HANA, on top of the `SAP/go-hdb` internals. We're planning to pre-release it soon to get feedback from real HANA users. If you're interested in testing it and providing detailed feedback, consider joining the [Columnar community Slack](https://join.slack.com/t/columnar-community/shared_invite/zt-3gt5cb69i-KRjJj~mjUZv5doVmpcVa4w).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Support SAP HANA [arrow-adbc]
Posted by "ianmcook (via GitHub)" <gi...@apache.org>.
ianmcook closed issue #2542: Support SAP HANA
URL: https://github.com/apache/arrow-adbc/issues/2542
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Support SAP HANA [arrow-adbc]
Posted by "avhz (via GitHub)" <gi...@apache.org>.
avhz commented on issue #2542:
URL: https://github.com/apache/arrow-adbc/issues/2542#issuecomment-2685832577
If there is anything that could be done, I would be interested in helping.
I'm not familiar with Arrow internals but I would like to learn.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Support SAP HANA [arrow-adbc]
Posted by "xhochy (via GitHub)" <gi...@apache.org>.
xhochy commented on issue #2542:
URL: https://github.com/apache/arrow-adbc/issues/2542#issuecomment-2697883489
Sadly the ODBC driver has some restrictive license terms (SAP Developer License Agreement) but there is a well-maintained Go driver using the Apache 2.0 license: https://github.com/SAP/go-hdb Building on top of that might be a better approach.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Support SAP HANA [arrow-adbc]
Posted by "lidavidm (via GitHub)" <gi...@apache.org>.
lidavidm commented on issue #2542:
URL: https://github.com/apache/arrow-adbc/issues/2542#issuecomment-2672974602
I've been meaning to start work on an ODBC bridge, just haven't found the time again
For us to test SAP HANA in CI we would need a way to run the database (preferably under Docker) and an appropriate license. Possibly something like this: https://hub.docker.com/r/saplabs/hanaexpress
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Support SAP HANA [arrow-adbc]
Posted by "WillAyd (via GitHub)" <gi...@apache.org>.
WillAyd commented on issue #2542:
URL: https://github.com/apache/arrow-adbc/issues/2542#issuecomment-2671975764
From that documentation it looks like SAP might be creating their own proprietary SQLDBC layer that the ODBC driver and others are built on top of. It might be nice to dive a little deeper into that, but the documentation suggests that is sadly only for internal use
It looks like they also offer a JDBC client, so you could try ADBC over JDBC for Java applications, although that won't solve the specific use case you have in mind
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Support SAP HANA [arrow-adbc]
Posted by "WillAyd (via GitHub)" <gi...@apache.org>.
WillAyd commented on issue #2542:
URL: https://github.com/apache/arrow-adbc/issues/2542#issuecomment-2686147938
Assuming the ODBC bridge is our best option, then it might be worth discussing further how to build that in https://github.com/apache/arrow-adbc/issues/72
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Support SAP HANA [arrow-adbc]
Posted by "ianmcook (via GitHub)" <gi...@apache.org>.
ianmcook commented on issue #2542:
URL: https://github.com/apache/arrow-adbc/issues/2542#issuecomment-4167189560
An ADBC driver for SAP HANA is now available as a pre-release from Columnar's private driver registry. To try it:
1. [Install dbc](https://columnar.tech/dbc/)
2. Run `dbc auth login`
3. Create an account and activate a trial
4. Run `dbc install --pre sap-hana`
The docs are at https://docs.columnar.tech/drivers/sap-hana/.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Support SAP HANA [arrow-adbc]
Posted by "WillAyd (via GitHub)" <gi...@apache.org>.
WillAyd commented on issue #2542:
URL: https://github.com/apache/arrow-adbc/issues/2542#issuecomment-2671802866
I definitely see value in this, although testing and setting it up in CI would be very challenging if not downright impossible.
Do you know what SDKs SAP HANA may make available for us to develop against?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Support SAP HANA [arrow-adbc]
Posted by "avhz (via GitHub)" <gi...@apache.org>.
avhz commented on issue #2542:
URL: https://github.com/apache/arrow-adbc/issues/2542#issuecomment-2671895081
I am not sure about this to be honest.
Possibly (?) helpful link: [SAP HANA Client Interface Programming Reference](https://help.sap.com/docs/SAP_HANA_CLIENT/f1b440ded6144a54ada97ff95dac7adf/ce5509c492af4a9f84ee519d5659f186.html)
The closest solution I have used is: <https://github.com/pacman82/arrow-odbc>
This project provides a Python interface that is used by Polars, which means our fetches are significantly quicker on the Python side, but we are lacking an R option.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org