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

JC_Hackkett's avatar
JC_Hackkett
New Contributor II
2 years ago

Compile SIF using Gateway Direct Connect type to connect with SAP

I have SIC version 8.2.1 I already created the gateway and is online, is a Direct connect type configured to connect with SAP I already install the SAP dll in the SIC local When I try to compil...
Connectors
Steven's avatar
Steven
Contributor II
2 years ago

JC_Hackkett  - it sounds like you have a couple of gateways setup in SIC and you are trying to use the direct connect gateway , but you can only use the Database Gateway in your Smart Integration Function.  Is this correct?  What methods are you using?  Can you show a snippet of your SIF code? Did you restart your SIC Connector Gateway after you created the new Gateway?

JC_Hackkett's avatar
JC_Hackkett
New Contributor II
2 years ago

Hi Steven  Thanks for replying

To compile a SIF type direct connect can only be done through ExecRemoteGatewayBusinessRule right?

I created a gateway  type = Web API, not for Data Base, I'm trying to connect to SAP, and I already configured the ERPConnectStandard20.dll in Local SIC and import ERPConnect and ERPconnect.Utils

I created a SIF function to run a RFC, in properties from this SIF I specified ERPConnectStandard20.dll

I created an Extensibility Rule this is the code

Dim objRemoteRequestResultDto As RemoteRequestResultDto = BRApi.Utilities.ExecRemoteGatewayBusinessRule(si, "Test2SIFSap", Nothing, "saptest2", "RunOperation",String.Empty, False, 90)
Smart Integration Function called  'Test2SIFSap
SIC Gateway called saptest2 with a method called RunOperation
 
Whe run the Extensibility , now send me a Smart Integration Connector Gateway general error at: 'saptest2 RemoteCodeExec ID
I wonder if I'm calling the SIF right because I don't think it even compiles
Regards
  • JC_Hackkett's avatar
    JC_Hackkett
    New Contributor II
    1 year ago

    Hi, Now It's working, I had to create a  Gateway datasource type and it already allowed me to compile it in SIF with the SAP dll. It can NOW connect me and bring information

    • ashimoga's avatar
      ashimoga
      New Contributor
      1 year ago

      Hi JC_Hackkett, 

      I'm facing a similar issue with an SAP connection. I was informed that a Database Type connection needs to be created for SAP for ERPConnect. We have added all the necessary DLLs to the local SIC gateway server, and the BR compiles successfully. However, it seems that the connection to SAP is not being established. Here's what we did:

      1. Created a Gateway of Database Type Connection.
      2. Added all the DLLs.
      3. Created an SIF which compiles successfully.
      4. When the External BR referencing the SIF BR is run, it does not establish a connection with SAP.

      Can you please help me understand the steps you took to create a data source if you opted for a direct connection? We were informed that creating a data source is not required.

      • JC_Hackkett's avatar
        JC_Hackkett
        New Contributor II
        1 year ago

        Hi ashimoga 

          It's correct you don't need create a datasource in Local Gateway Connections.

          If the gateway is online, you have to review the DLLs installed, you need  the librfc32.dll installed too

        the link https://help.theobald-software.com/en/erpconnect/prerequisites-and-installation/saplibraries