Write back entire Spotfire table to an Oracle database

[Uwe Mueller 2]

I would like to write back an entire Spotfire table into an Oracle databse with an insert or bulkinsert statemnt.

So far I have been able to update my database with data from Sporfire via a stored procedure and using infromation links and some IronPython script to update a few rows in my databse depending on the table rows selected with some additional input (document properties)in Spotfire.

Now what I'm looking for is a bulk insert of the entire Spotfire table in the fastest and most efficient way. Can I do this with a stored procedure and how do I avoid writing back one row at a time

[Sayali Patil]

Hello,

One way to do it can be a R data function where you can pass the entire table can be an input to the script and use the library like RODBCExt to do bulk insert.

 

Reference -

https://stackoverflow.com/questions/44502558/insert-multiple-rows-from-r-dataframe-into-oracle-database

https://cran.rstudio.com/web/packages/RODBCext/vignettes/Parameterized_SQL_queries.html

[James Laurenzano]

Can you share how you did the write back with multiple rows  I'm trying to design a solution for this, but am struggling with how this will work.