How to extract data from SAP HANA(for SAP Business One) database

Hello experts, I would like to ask you if it is possible to extract information from a SAP Business One (SAP HANA) database (obdc connection)? Can you give me an example of how I can run a query please?

In case it is not possible to extract the information directly, is it possible to run a python script and handle the results of the connection to SAP HANA? in what form should I return the information from python to n8n? json, txt, etc …

best regards

Hi LordAchury,
yes this can be done.
As you pointed out, there are different options (obdc, API, possibly more). We are currently doing a project for SAP CRM C4C creating a node and a workflow for the API interface. SAP products are complex and I suggest we speak about details of your requirement to get you exactly the solution you are looking for. PM

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.