Skip to main content

Personalized in-db connectors for version 6.5 onwards

Personalized in-db connectors for version 6.5 and further

Go to File >> Add Data Tables >>

Select Connection to
"SQL Server" (This could be any database type that supports custom queries)
In the next dialog, provide server authentication method, username password as required.
Hit the connect button

If connection is successfull you should be able to select a database

Select a database and in the "Views in Connection" windows select Custom Query >> New Custom Query

In the Query window, add a query name, then at the bottom hit the parameters tab and check the box at the bottom "User parameters for personalized Queries"
Then write in the query, you can use parameters like ?current_user, ?current_group or ?current_domain.
These values are filled up by spotfire at run time based on User login information and can be used to restrict data based on user access.

Add caption


  1. I have been reading out a lot of your articles and that i ought to say pretty nice stuff.
    I will certainly bookmark this website.neha
    spotfire online training


Post a Comment

Popular posts from this blog

Spotfire Writing back to a database

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.

Steps to do that would be
1)Create a procedure …

Spotfire Information Link caching & Scheduled updates caching

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…

Using Accordions in Spotfire Text Areas

Spotfire 6.0 provides great tools for quickly building your dashboard, but here we will learn to spice up things with the help of new 6.0 text area. If you are not aware the new 6.0 Text area supports HTML, Javascript and CSS.
This opens up possibilities for doing a lot more with the text area.
Some of the basic stuff can be seen here
One of the cool things you can do is build an accordion panel in the text area for better utilization of the valuable screen real estate and helping the overall experience.(Watch the 0:15 second video below to see how accordion works - Sorry for the jitter in the video. The screen recorder does not record fast enough)

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…