Stored procedure linking from Postgres to Spotfire.

[Harsha Jha]

I want to -

Accept the input(s) in text box(es) from Spotfire Dashboard. And link it with stored procedure written in Postgres db to be able to update two columns, based on inputs.

I am very new to Spotfire. Please help with the steps.

[Stina Larsson]

Hi,

 

There a a few things that need to be created in order to set this up.

They are created in Information Designer:

1. Create a data source connecting to your Postgres db.

2. Create necessary columns.

3. Create a procedure and link the procedure from your db.

4. Create an information link using prompts, where the input values can be inserted. The created procedure can be added to the information link.

You can read more about Information Designer if you from within Spotfire Analyst go to Information Designer (Tools menu for version 7.14 and earlier, Data menufor version 10 and forward) and click Help button.

It is difficult to give more explicit information as I do not know you exact scenario.

Should you run into issues when performing the above, I recommend that you open a case with us!

 

Kind regards

Stina