Increasing data volumes and rapid changes in everyday business require that analyses also adapt to the prevailing speed of the data. The Python programming language with its flexible, extensive libraries in the data science area and the high-performance in-memory database management system SAP HANA are an unbeatable combination for fast data analyses. However, the possibilities are slowed down by the traditional database connection. Data can be accessed in real time in HANA, but is only transferred gradually via the Hana Database Client (hdbcli) driver. In addition, the upload of data is complicated by the relational database schema, which must be defined in advance, as opposed to NoSQL database types, and the connection data is not infrequently included in clear form in the code.
By further developing the database connection between the SAP HANA and Python with state-of-the-art parallelization and user-friendly standardization steps of data download and upload, the development process gains speed and simplicity.
The NLY SAP HANA Python Connector is designed as a Python module to establish a high-performance, secure connection to the SAP HANA database via the Open Database Connectivity (ODBC) interface. The technologies PyArrow, Turbodbc and the secure user store (hdbuserstore) provide an up-to-date data connection especially for the data engineering and data science area:
Flexible data manipulation of data is quickly realized in Python with the HANA Connector and executable with a speed advantage. Productive systems additionally benefit from the failover support provided by the HDBUSERSTORE. Efficient storage formats greatly reduce the amount of memory required for data retrieval.
NextLytics is always at your side as an experienced project partner. We help you to effectively solve your data problems from data integration to the use of machine learning models. Use the form below to ask your question and we will get back to you as soon as possible.
We look forward to hearing from you!