Forum Discussion

zwc's avatar
zwc
New Contributor
2 years ago

SIC gateway connection to export OS table to SQL server

Hi Can anyone advice how to push OS data back to SQL server by using SIC gateway? We setup the SIC to import data from SQL servers to OS successfully in SIC business rule, but no idea how to push b...
Data Integration
mathieu_cartel's avatar
mathieu_cartel
Icon for OneStream Employee rankOneStream Employee
2 years ago

Hi zwc

Here is the code I use and it works:

Using dbConn As DbConnInfo = BRApi.Database.CreateDbConnInfo(si, DbLocation.External,"[[your SIC Connection name]]")
'.CreateCustomExternalDbConnInfo(si, DbProviderType.Gateway, "GRDWDB")
dt = BRApi.Database.ExecuteSql(dbConn, insertStatement, False)

End Using

The insertStatement variable is a string that contains an insert statement. But your problem, I believe, is the dbConnInfo.

Cheers!

mathieu_cartel's avatar
mathieu_cartel
Icon for OneStream Employee rankOneStream Employee
2 years ago

I tried with SaveCustomDataTable and received a message saying it is not compatible with SIC. So for now, my best answer is with the insert statement which will only work with a small number of records