Compile SIF using Gateway Direct Connect type to connect with SAP

Question

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 compile my SIF in the Onestream App asks me for the Gateway, but I can't see my direct connect gateway, only shows the Database Gateway
What I'm doing wrong?
&nbsp;
Regards

JC_Hackkett · Answer

Hi&nbsp;ashimoga&nbsp;
&nbsp; It's correct you don't need create a datasource in Local Gateway Connections.
&nbsp; If the gateway is online, you have to review the DLLs installed, you need&nbsp; the librfc32.dll installed too
the link&nbsp;SAP Libraries | Theobald Software Online Help (theobald-software.com)

Steven · Answer

JC_Hackkett&nbsp; - 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.&nbsp; Is this correct?&nbsp; What methods are you using?&nbsp; Can you show a snippet of your SIF code? Did you restart your SIC Connector Gateway after you created the new Gateway?

JC_Hackkett · Answer

Hi&nbsp;Steven&nbsp; Thanks for replying
To compile a SIF type direct connect can only be done through&nbsp;ExecRemoteGatewayBusinessRule right?
I created a gateway&nbsp; 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&nbsp;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&nbsp;&nbsp;'Test2SIFSap 
SIC Gateway called saptest2 with a method called RunOperation
&nbsp;
Whe run the Extensibility , now send me a&nbsp;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 · Answer

Hi, Now It's working,&nbsp;I had to create a&nbsp; 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 · Answer

Hi&nbsp;JC_Hackkett,&nbsp;
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:

Created a Gateway of Database Type Connection.
Added all the DLLs.
Created an SIF which compiles successfully.
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.

Forum Discussion

Compile SIF using Gateway Direct Connect type to connect with SAP

Related Content

Jdbc database connection for SIC

WS Assembly Service Factory Compile Error

Import files from FTP Connection

Direct Connect Loads into OneStream

SIC gateway connection to export OS table to SQL server