Can Spotfire write back to database?

Can Spotfire write back to database?

One of the unique features of Spotfire is its writeback functionality. Writeback means we can insert data into database from Spotfire. Here I am explaining how we can implement write-back functionality using Stored Procedure.

How do I create a procedure in Spotfire?

To Create a Query procedure:

1. Click New and select Procedure.
2. In the Data Sources tree, click on the database procedure you wish to use.
3. Click Select.
4. Select the Procedure type: Query.
5. In the Description field, type your own description of the procedure.

How do you access data in Spotfire?

You can load data into the internal TIBCO Spotfire engine from a number of different sources: by pasting from the clipboard, by dragging and dropping or opening simple text files, Microsoft Excel files, SAS files, or a database or an information link (a predefined connection to a shared data source).

How do I create a parameter in Spotfire?

On the Parameters tab, make sure that all parameters that you use in the query have been specified. Comment: Click New… to specify a new parameter and enter a Name, Spotfire data type and a Value type for the parameter. Click OK to close the Custom Query dialog when done.

How do you call a stored procedure in Spotfire?

In the Views in Connection dialog, select the procedures you want to work with in Spotfire in the Available tables in database list, then click Add >. Response: The Stored Procedures dialog opens. In the Stored Procedures dialog, define the result columns to retrieve for each of the stored procedures.

How do I use procedures in Spotfire?

Where is data source in Spotfire?

Select Tools > Manage Data Connections. Select Add New > Data Source and choose the selected data source type from the list. Depending on which type of data source you have selected you need to specify a different number of settings.

How do I add a data source in Spotfire?

Setting up a Spotfire Data source

1. Within TIBCO Spotfire Professional, open the Information Designer from the menu bar as: Tools -Information Designer.
2. Click the Setup Data Source link.
3. Click Save.
4. Click Save again, if pop window appears.

How do you query in Spotfire?

Using TIBCO Spotfire Analyst version 7.14 and lower:

1. Open your Analyst client.
2. Go to File – Add data tables.
3. Click the “Add” button, go to the section “Connection to” and add your preferred data connection.
4. Logon to your data source.
5. In the “Views in Connection” window, click the “Custom query” button.
6. Add your query.

What is data Connection in Spotfire?

A data connection is used when you are analyzing massive amounts of data and you need to keep the underlying data in the database (in-db) rather than bringing it into Spotfire’s internal data engine. One or more data tables which may or may not be used by the analysis.

How do I embed data in Spotfire?

Data tables can be embedded through (Edit > Data Table Properties > Embedded in Analysis) Data tables can also store data through “Save As > File/Library Item > Review Data Loading Settings” or in expanded Data Panel > Select any data table > Source View.