Oracle Stored Procedure with Spotfire

Question

I need a step by step example to create a simple Oracle Stored Procedure and link it to Spotfire and get the prompt values of the data of Procedure in Spotfire and get the output data.

Answer 1

While I agree with @niko, since this is an old post I'll help out.

First, if you don't know how to create a procedure in Oracle you should really take come courses on it, and Oracle database structure in general. It isn't something you want to just create at random without understanding the potential implications. But, start here:

https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_6009.htm

Once you have done that, here are the steps to connect it to your analysis.

• Add a data source: Tools > Information Designer > Data Sources > New (Data Source

https://docs.tibco.com/pub/api-exchange-gateway/2.2.0/doc/html/GUID-3E01F47C-C6A0-49AB-80D4-2D1A3F600FA3.html

• Add your procedure as a data element by expanding your new Data Source and finding your Stored Procedure. Then Right click and select Create Procedure
• Next navigate to where you saved this procedure in your library. Right click on it and select Create Information Link. Save this information link
• Lastly, in the professional client, add your information link to your analysis.

There are multiple ways to handle the parameters of your procedure, but one of the easiest ways is to create a document property which will take a user input for your parameter, making your data source an On Demand data source.

If you need help with that, research, and then post a question for any clarification that you need.

Cheers!