Hi jkim,
I just did that today. I'm not using the Remote BR, which probably explains the poor performances! But it's a first step:
' my own function that creates an insert statement string from a dataTable variable dt.
Dim insertStatement As String = CreateInsertStatement(si, dt)
BRApi.ErrorLog.LogError(si, XFErrorLevel.Information, insertStatement)
Using dbConn As DbConnInfo = BRApi.Database.CreateDbConnInfo(si, DbLocation.External,"YOUR SIC CONNECTION NAME")
dt = BRApi.Database.ExecuteSql(dbConn, insertStatement, False)
End Using
Fairly straight forward. Test with a small number of records and increase...
Could you please provide the insert statement? My requirement is to read from an external db and insert into a table in OneStream.
Thank you,
Indu
