Knime add/update the data in SAP Business One (SAP B1, SQL version)

KNIME Analytics Platform
1

Hi Experts, has anyone tried using KNIME to add or update data in SAP Business One (SAP B1, SQL version)?

2

Hello @ericcheung,

Welcome to the community!

I am not too familiar with SAP B1, but if they provide a JDBC driver and url you should be able to connect to it using the DB Connector Node or the Microsoft SQL Server Connector.

Alternatively I looked it up briefly and they do offer an API that you can perform several manipulations on the db including sending a POST request for a query.

If you choose the API route, you can use the ‘POST Request’ node.

Hope this helps,
TL

3 Likes