SIC Connect to SAP BW in V8

Forum|Forum|2 years ago
March 22, 2024
6 replies
0 views

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,

Data Integration

N

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

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

K

KKGamerAuthor

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?

N

NicolasArgente

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

K

KKGamerAuthor

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?

N

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.

K

Krishna

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