The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

KKGamer's avatar
KKGamer
New Contributor III
2 years ago

SIC Connect to SAP BW in V8

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

8 Replies

  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor
    2 years ago

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

    • KKGamer's avatar
      KKGamer
      New Contributor III
      2 years ago

      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's avatar
    NicolasArgente
    Valued Contributor
    2 years ago

    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's avatar
    Krishna
    Valued Contributor
    2 years ago

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

     
     
  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor
    2 years ago

    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's avatar
    NicolasArgente
    Valued Contributor
    2 years ago

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

    • KKGamer's avatar
      KKGamer
      New Contributor III
      2 years ago

      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?