We are under construction!
You may experience downtime, errors or visual oddities, but we anticipate all will be resolved by the end of the day.
Forum Discussion
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.
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.