Is it possible to integrate a c-library into a SAP HANA database procedure?

[marco_fischer2]

Dear SAP-Community,

in our project we have the requirement to integrate an external pseudonymization algorithm into a data preparation in a BW on HANA system, which is made available via a C-library.

Is there a way to use this C-library via HANA-native artifacts like a HANA database procedure in order to pseudonymize the necessary data fields in the data records?

That would be great, because then we could call this HANA database procedure from an AMDP, since our data preparation takes place in transformations within the BW.

Unfortunately, we have not yet found a solution using the search function of the community.

It would be great if we could find help here.

Kind regards,

Marco

[lbreddemann]

Yes, it is possible to integrate external C/C++-libraries into an on-premise SAP HANA system.

SAP provides the Application Function Library SDK for SAP HANA (SAP HANA AFL SDK) to develop extension libraries.

Note, that developing and maintaining such an AFL library is a rather involved task and requires a very different skill-set than that of a data/integration/analytics engineer. You need a developer that is competent and very comfortable with current C++ development practices.