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