Lot of time users need to write back to a database.
Spotfire provides different ways to do this, Without going thru the code I am going to talk thru the different options available. But if you need detailed instructions, please leave some comments and will try to provide one
1) Stored Procedures.
Advantages : Complex logic is easy to encapuslate in procedures. Also you are not storing username/passwords anywhere
Spotfire can execute stored procedures and these procedures could be fetching data, or can be procedures that can be run Pre or Post running a query. You can then use procedures that basically update your database table or even inserts new rows in tables.
When using Spotfire information model it allows you to use these procedures which you can repurpose for updating your database.
Spotfire also understands inputs to a procedure and they can be mapped to your marked rows/filtered rows/ properties/constants etc from your analytics.
Spotfire Information Links and the entire Information Modelling layer in
Spotfire is a great way to democratize your data. Information links become great
starting point for your users to build their analytics without even knowing SQL or where the server is, what table to use and how are they joined and all the geeky stuff. In a typical instance
there is a high likelihood that some of the information links are shared
between different reports. With new versions of Spotfire now there is an option available
to cache Individual Information links. The data behind the information link is
cached at the Spotfire Server level. The cache is a Spotfire specific binary
file which is stored on the Hard Drive of your Spotfire server. So you need to
ensure that if you are caching there is enough space. The cache itself is self cleaning
depending on timeouts and validation query. Also a Spotfire server Restart
would clear up the cache, so you need to accommodate for that in your planning. Caching is ge…
Here is the html behind the text area : Please note that Spotfire controls are automatically created when you add text area controls, like filters, drop down lists etc. <DIV id="myaccordion"> <H3>Analysis Details</H3> <DIV> Author : John Doe <BR&g…