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.
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.
