Is there any way to do a REPLACE instead of an INSERT in the BULK INSERT feature?

Andreu Companys

I'm trying to get a hierarchy directly upload from BOARD to a SQL Server, so this way we have the hierarchy on SQL and we can use it in our Views and Querys.

The way that the BULK INSERT works let's me upload it, but every time I try to upload it again I will get a duplicate. I only want to have one register for every key value (In this case it is the child entity of the hierarchy). This will work if instead of using the INSERT command we use instead the REPLACE command.

Can you use other commands in the BULK INSERT feature other than the INSERT?

Is there any other way to upload this hierarchy to a SQL Server only using BOARD?

Thomas Kreis

Hello Andreu,

unfortunately, the only command allowed in the Bulk Insert procedure step is the INSERT INTO statement. See also here for reference:

https://www.boardmanual.com/2021/summer/whats-new-release-notes/winter-2021-release/main-features/New_Extract_procedures.htm

The only other way I can think of to directly upload it to a SQL may be using ROLAP / RDB Text Cubes. You could try populating these cubes with Dataflows. Probably not as fast as the Bulk Insert, but it may work as well.

Best regards

Thomas