Question Re: Hana Text Analytics python interface in Technology Q&A

Hana Text Analytics python interface

Former Member — Tue, 18 May 2021 17:28:58 GMT

Tutorials: https://developers.sap.com/tutorials/hana-clients-python.html
--------------------------

Write here what you need help with ...

I want to know if it's possible to do sentiment analysis or entity detection or any other capabilities of Hana Text Analytics through the python interface ?

Re: Hana Text Analytics python interface

Enda — Tue, 18 May 2021 17:29:31 GMT

Welcome and thanks for visiting SAP Community to get answers to your questions. Check out our tutorial to get started in SAP Community: https://developers.sap.com/tutorials/community-start.html By adding a picture to your profile you encourage readers to respond to your question. Learn more about your profile here: https://developers.sap.com/tutorials/community-profile.html

Re: Hana Text Analytics python interface

dvankempen — Tue, 18 May 2021 18:06:16 GMT

Hi Nazanin,

Certainly, although using SAP Data Intelligence might be a more suitable solution, cf.

https://blogs.sap.com/2020/11/30/how-to-deploy-a-natural-language-processing-model-with-tensorflow-on-sap-data-intelligence/

Re: Hana Text Analytics python interface

Vitaliy-R — Tue, 18 May 2021 21:40:56 GMT

Recently sapalex published

Text mining at SAP HANA Cloud with Python

: https://blogs.sap.com/2021/04/26/__trashed-45/

Please check if that’s what you were looking for.

Or are you looking for on-prem HANA 2.0?

Re: Hana Text Analytics python interface

Former Member — Wed, 19 May 2021 06:59:32 GMT

Hi Denys,

Thanks for your response. I went through the link that you sent me, If I'm not wrong it is more related to training a model from the scratch. I don't have any labeled dataset and I'm looking for a pre-trained model. I'm so new in SPA and I was wondering if there is any programmable API for Hana Text Analytics that I can use to extract sentiments and entities of a bunch of texts that I have. I talked with some of the SPA customer operation team, one of them suggested me this link: https://developers.sap.com/tutorials/hana-clients-python.html (connect using the SAP HANA Python Interface). I wanted to use the python interface as suggested in the link to extract sentiments and entities of my texts but I was not sure that if it's possible because I couldn't find any related code for that.

Do you have any information or advice for me?

Thank you 🙂

Re: Hana Text Analytics python interface

dvankempen — Wed, 19 May 2021 08:42:31 GMT

Hi Nazanin,

The technology behind Text Analysis used in the SAP HANA platform (on-premises) goes back to BusinessObjects, InXight, and Xerox.

https://blogs.sap.com/2019/11/02/advanced-analytics-sap-hana-2.0-an-introduction/

Most functionality is no longer included in SAP HANA Cloud

https://help.sap.com/viewer/3c53bc7b58934a9795b6dd8c7e28cf05/hanacloud/en-US/eeffc091d9704d5bae57b6943f1d31d6.html

Hence my reference to Data Intelligence for sentiment analysis for a more recent implementation.

The SAP HANA client supports all common languages, ODBC/JDBC, .NET, Go, Python, etc. but these libraries provide database client functionality (connection management, cursor handling, failover, etc.).

In other words, you could use a platform database feature (Text Analysis) for sentiment analysis and entity extraction, and access this in a client application using Python database client libraries, but there is no SAP HANA Text Analysis API as such. For SAP HANA Cloud, there is limited support in this domain.

Answers your question?