SIC Connect to SAP BW in V8

[KKGamer]

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,

[NicolasArgente]

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

[NicolasArgente]

[NicolasArgente]

Note that the AddCriteria is outdated and wont work using ERP dlls. So the documentation is not up to date.

[KKGamer]

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?

[NicolasArgente]

https://kb.theobald-software.com/release-notes/ERPConnect-6.1.0.html
Please use the WhereClause property instead. 
@onestream, please update the documentation

[KKGamer]

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?

[NicolasArgente]

@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. 

[Krishna]

You can try the new marketplace solution SAP Connector.  You should be in Version 8