Forum Discussion

myasa25's avatar
myasa25
New Contributor
7 months ago
Solved

Loading data from External Database to OneStream XFC Data Table

I am trying to copy data from external database to OneStream SQL table. I am trying to achieve this by using Extensibility Rule. Can someone help me with the rule to save data into Onestream table.
rhankey's avatar
rhankey
Contributor II
7 months ago

Assuming you have accumulated the external data into a VB DataTable, I then write the DataTable to a SQL table using BRApi.Database.SaveCustomDataTable(), which does an efficient bulk insert.  You have to pre-delete any offending rows in the destination table first.