Skip to main content
Newcomer
October 28, 2024
Solved

Loading data from External Database to OneStream XFC Data Table

  • October 28, 2024
  • 1 reply
  • 0 views

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.

Best answer by rhankey

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.

1 reply

rhankeyAnswer
Newcomer
October 29, 2024

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.