03-22-2024 08:24 AM
Hi Guys,
We are upgraded to V8 and now need to update our integration to SAP BW as well.
As of now, the ERPConnectStandard20.dll has added in the assembly folder under the gateway server folder.
And per the SIC guide, only the smart integration function business rule can used to call ERPConnect function, so we believe the steps should be:
1)Build smart integration function business rule to extract data from SAP BW
2)Using connector business rule to call the above function for processing in the Import step
But we didn't found any sample for this. Appreciate if any input or sample code on this.
Thanks,
03-22-2024 01:17 PM
Hey @KKGamer
You need a connector BR and a Smart Integration Function SIF BR.
The connector BR is calling the SIF BR. The SIF calls sap, makes a datatable for example, and return it to the ConnectorBR.
After that it is a normal process.
Look in the latest documentation dedicated to Connectors as you will find some samples of the BR used.
Cheers
03-22-2024 01:20 PM
03-22-2024 01:21 PM
Note that the AddCriteria is outdated and wont work using ERP dlls. So the documentation is not up to date.
03-24-2024 07:53 AM
Thanks Nicolas. This is helpful.
It there any function can be used to replace AddCriteria?
Also I know CreateSAPConnection is not work now, Is R3Connection the only option?
Do you know where can I get more details about which functions are available when using ERPConnectStandard20.dll?
03-24-2024 10:43 AM
https://kb.theobald-software.com/release-notes/ERPConnect-6.1.0.html
Please use the WhereClause property instead.
@onestream, please update the documentation
03-24-2024 11:52 PM
Got it. Thanks Nicolas.
I have got the host and account details for connection.Is it required to create a data source in the Local Server gateway? Or we can using R3Connection from SIF business rule directly?
03-25-2024 02:43 AM
@KKGamer No need for the datasource. But did you add the Dlls on the gateway and reference it in the BR? Hope so... read the doc about it please.
03-28-2024 05:09 PM
You can try the new marketplace solution SAP Connector. You should be in Version 8