Hello,
I'm having a lot of difficulties in trying to connect to my local gateway to execute a business rule that would insert values from a datatable into a local sql table. The examples providing in the documentation look incomplete or contain errors.
- My gateway is called : abc_gateway and redirect to my local machine which is online
- I have a custom database server connection which is redirected towards my local machine 'abc_local'
My business rule that will invoke the BR on my local machine (this business rule currently sits in a workspace assembly) :
Dim GatewayName As String = "abc_gateway" ' Name of the Gateway
Dim SICFunctionName As String = "SIC_Functions" ' Name of the SIC Function to run
Dim RemoteMethodName As String = "RunOperation" ' Name of the method inside the SIC Function that will be called.
Dim resultdatatable = BRApi.Utilities.ExecRemoteGatewayBusinessRule(si, SICFunctionName, Nothing, GatewayName, RemoteMethodName)
Then I have a smart integration function in business rule :
Imports System
Imports System.Collections.Generic
Imports System.Data
Imports System.Data.Common
Imports System.Globalization
Imports System.IO
Imports System.Linq
Imports System.Data.SqlClient
Imports OneStreamGatewayService
Namespace OneStream.BusinessRule.SmartIntegrationFunction.SIC_Functions
Public Class MainClass
Public Function RunOperation() As DataTable
Dim datatableresults = New DataTable()
Dim connectionString As String = APILibrary.GetRemoteDataSourceConnection("MyTests") '<-- my local sql database
Using Connection = New SqlConnection(connectionString)
connection.open()
Dim sql As String = "select * from test" '<-- query to the test sql table of my local sql datatabase
Dim cmd As SqlCommand = New SqlCommand(sql, connection)
Dim dbreader = cmd.ExecuteReader()
dataTableResults.Load(dbreader)
Return dataTableResults
End Using
End Function
End Class
End Namespace
This is my local SQL database and my local sql table. I can indeed connect to it in a data adapter but can't seem to execute a remote business rule :
I just constantly keep the message : "The ConnectionString property has not been initialized." I tried changing the APILibrary.GetRemoteDataSourceConnection to either the custom database connexion name, the gateway name ... but can't work this out.
Regards,
