Spotfire information designer data source. The data sources that are used to make up a final data table are easy to overview in spotfires source view. A plug in minimizes the number of times one has to log into the tibco spotfire environment leaving it up to the plug in to deliver the data source credentials. An information link is a database query specifying the columns to be loaded and any filters needed to narrow down the data table prior to creating visualizations in tibco spotfire. Without a plug in users will have to supply their data source credentials in a prompt.
Spotfire data source reference missing while moving library data source from 55 to 65 server 0 spotfire 7 add odata connection to standard data connections from plugin. Connecting spotfire to data sources with information designer. In the example above we have combined data from three data sources into a final spotfire data table. For mysql database example values are shown as follows.
The information designer is a tool for setting up data sources and creating and opening information links. Information links can include limiting options aggregation methods data transformations and filtering options to help control the size and specificity of the data set. In addition data source credentials are also cached on the tibco spotfire server. Credentials can be cached in the data source so that users are prompted only once for each session.
Data source you have selected you need to specify a different number of settings. Within tibco spotfire professional open the information designer from the menu bar as. Input the data source fields as appropriate. Tibco spotfire accesses data in virtually any odbc compliant data source.
Information designer in the tibco spotfire user manual. Spotfire odbc data sources. Information links are methods to communicate with a database and retrieve a specific set of data which is then loaded directly intospotfire. For a description of the different options.
In information designer information links are created from building blocks such as columns and filters using joins calculations and aggregations. Data sources can represent data from files data connections information links data functions and odbc connections. Provide the requested information connect to the data source select a database and click ok. Database vendors like simba progress and cdata offer odbc drivers to a wide range of data sources and combined with spotfires odbc support data can be analyzed in data sources such as mongodb cassandra dynamodb hbase google bigquery twitter facebook linkedin and many more.
Click the setup data source link.