Forum Discussion

JC_Hackkett's avatar
JC_Hackkett
New Contributor II
7 months 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
JC_Hackkett's avatar
JC_Hackkett
New Contributor II

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
6 months 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.

    • ashimoga's avatar
      ashimoga
      New Contributor
      6 months ago

      Thanks JC_Hackkett . Do we need to buy ERPConnect license for this?

      • JC_Hackkett's avatar
        JC_Hackkett
        New Contributor II
        6 months ago

        I was also validating this topic. No, it is not necessary
        Download the dll from the OneStream marketplace according to the SIC manual, once you copy it into the local SIC configuration xml, automatically add the license.

        Validate with the Basic or ABAP people that your login request is being received and the request, whether it is to read a table or request an RFC.
        I had to take the error that calls you back

        This is an example of how to take the error message that comes to you directly from SAP, use some standard RFC and give access to your SAP connection user.

            Dim r3Conn As New R3Connection(host, systemnumber, username, password, language, client)
            r3Conn.Protocol = ClientProtocol.NWRFC
            r3Conn.Open()
         
            If r3Conn.IsOpen Then
                Dim r3Func As RFCFunction = r3Conn.CreateFunction("BAPI_GL_ACC_GETBALANCE")  
                r3Func.Exports("COMPANYCODE").ParamValue = "XXXX"
                r3Func.Exports("GLACCT").ParamValue = "XXXXXXXXX" 
                r3Func.Exports("FISCALYEAR").ParamValue = "XXXX"
                r3Func.Exports("CURRENCYTYPE").ParamValue = "XX"
                r3Func.Execute()
                Dim balanceDetail As RFCStructure = r3Func.Imports("ACCOUNT_BALANCE").ToStructure()
                Dim returnStruct As RfcStructure = r3Func.Imports("RETURN").ToStructure()
                'This message is from SAP
                Dim message As String = returnStruct("MESSAGE").ToString()
        End If