ADELE is a Java based tool for data analysis and comes with an SAP integration for exporting SAP data into ADELE. This is already published and known.
Starting from version 0.31.x data can be exported to SAP too. Export and import of data use RFC-enabled function modules with a very simple interface. Even ABAP newbies can implement this in minutes.
Here is an example for an RFC-enabled function module for export (programming language is ABAP):
FUNCTION Z_ADELE_EXPORT_SFNF.
*”———————————————————————-
*”*”Local Interface:
*” IMPORTING
*” VALUE(IV_MAX) TYPE SYTABIX OPTIONAL
*” TABLES
*” ET_DATA STRUCTURE SFLIGHT
*” EXCEPTIONS
*” WRONG_INTERFACE
*” WRONG_SQL
*” ERRORS_OCCURED
*”———————————————————————-
* ——– include ADELE interface
INCLUDE ZADELE_EXPORT_API_INCLUDE.
TRY.
* ———— process
ade_datadef.
ade_process_select sflight.
* ———— process errors
CATCH cx_sy_dynamic_osql_semantics.
RAISE wrong_sql.
ENDTRY.
ENDFUNCTION.
The API supports filters and OLAP specific operations too. ADELE supports some OLAP specific operations like get statistical information for a data field, see the value distribution or build an in memory OLAP cube of flat adhoc data.
The API is fit for SAP HANA. This means espescially tables with column based storage will export the data faster than a normal table with row based storage (if filters on dimension fields are present). In a test scenario a subset of 60.000.000 records was extracted in less than 1 second for 20.000 result rows.
A documentation for developers is available as “SAP Integration Guide” and can be downloaded here. You will find a current version of ADELE and the current API includes at the project site: https://sourceforge.net/projects/adele.