/Logo%202023%20final%20dunkelgrau.png?width=221&height=97&name=Logo%202023%20final%20dunkelgrau.png "logo")
/HP_Hintergrundbild-01-06-2023_paralax-scrolling-Kreis-dunkel_klein.png)
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.
Performance through parallelization
Through parallelization, the data download with the HANA connector reaches up to 9 times the speed compared to the connection with the standard SAP driver. In the upload, even 10 times the speed can be achieved.
Secure authentication
The access to the HANA database by means of the connector is optimally carried out via the authentication by means of the token of the HDBUSERSTORE. There, the connection data of the HANA are securely stored on the client side. An alternative login with username and password is possible, but not necessary.
Full compatibility with Pandas DataFrames
Pandas DataFrames are often used for data manipulation in the context of artificial intelligence. With the HANA connector, data is not only loaded directly into a DataFrame, but also during an upload its data types are matched accordingly to the HANA data types and tables that do not yet exist are created automatically.
Practical functions for the development process
In terms of its functions, the connector is closely aligned with the everyday work of developers. Frequently used SQL statements, such as the output of all tables of a schema, all columns of a table and checking for the existence of a table are integrated into the cursor as easily accessible functions.
The download speed increases up to factor 9.
In addition to automatic data type conversion, the use of parallelization ensures a 10x faster upload.
The NextLytics Python SAP HANA connector is installed as a Python module. Setup of the hdbuserstore is also included in the documentation and a CLI tool simplifies setup and connection management.
We look forward to hearing from you!
Find interesting articles about SAP Connectors in our Blog
More flexibility for processes: Connecting SAP BW and Apache Airflow
Use Google API and ABAP to enrich SAP data with geoinfos
