Hi all.

I would like to know if anyone has any experience integrating Salesforce with SAP for Business One.

I tested Lightning connect in a dev org to connect with SAP and it's working fine. despite the expensive price of $4000 per month (It's too much for a small org), In one way it's fine to use this Salesforce feature as I read, it will create external objects in Salesforce and this works for us if I'm taking about accounts or pricing. But for Invoices we don't want to use it as external objects as invoices won't change to often and we see not useful to go to SAP when we should have that info inside Salesforce (mostly for report purposes).

Does anyone knows or can recommend me how to achieve this? to keep some SAP data inside Salesforce as an object and not as an external object or best practices to integrate Salesforce with SAP without buying an expensive middlewate?

Any advice will be really appreciate it.
Thanks everyone.