Forum Discussion
Hi Nicholas
Sorry, I made some confusion. Below is what I want to achieve.
1. Extract data by fdx and copy to a datatable variable finalTable
2. Tried to set up a connection in Extensibility BR to our company sql database through SIC (SIC = "DWH_AWS1DNA01")
3. Save Data in finalTable to a Sql table dbo.OneStream_Table
I have successfully put data in the finalTable, but cannot save data to sql table. The codes I used are
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_cartel2 years agoNew Contributor II
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
Related Content
- 4 months ago
- 7 months ago
- 3 years ago
- 10 months ago