Skip to main content

Data Source Connections Credentials

Copied from spotfire help manuals 

Details on Data Source Settings – Credentials

  • To reach the Data Source Settings dialog:
  1. Select Edit > Data Connection Properties and click on Settings... or edit a data connection from within the Manage Data Connections tool.
    2. Response: The Data Connection Settings dialog is displayed.
  2. On the Data Source tab, click on Settings....
  3. Click on Credentials to go to this tab.
Option
Description
Save to Library
[Only available for embedded data sources.]
Allows you to publish an embedded data source to the library, so that it may be reused in other analyses or by other people.
Embed in Connection
[Only available for data sources shared in library.]
In order to make any changes to the data source settings when you are within the context of a data connection, the data source must first be embedded in the connection. Click on this button to embed the data source. (The shared instance of the connection data source will still remain in the library.)
Once a data source has become embedded it can be edited and then re-saved to the library using either the same name or a different one.
Replace
Allows you to replace the current data source with another one from the library.
Note that data sources cannot be replaced by data sources of a different type. If the database system on your company has been switched out, you should instead replace the entire data connection.
Data source state
Shows the current state of the data source. Either it is Embedded in connection which means it is available for editing or it is Shared in library.
Save credentials in with the connection data source

   No, do not save any credentials
Use this option if you do not want to save any credentials with the connection data source. If the connection data source uses database authentication, all users of the data source will be prompted for username and password to the database when this data source (or a data connection using it) is opened.
   No, but save credentials profile (may be used when opening in TIBCO Spotfire Web Player or running TIBCO Spotfire Automation Services jobs)
   
Use this option if you want to save a credentials profile instead of saving the actual credentials with the connection data source.
A credentials profile consists of a profile name, a username, and a password (only the profile name is saved with the connection data source). It can be used for logging in to the database when opening analyses including data connections in TIBCO Spotfire Web Player, or when running jobs in TIBCO Spotfire Automation Services.
Specify the name of the credentials profile you want to use in the text field.
Opening analyses in the Web Player:
To use this option when opening analyses in the Web Player, specify a profile name in the text field, and make sure a matching profile has been defined in the Web.config file. The username and password defined in that credentials profile in the Web.config file will be used to log in to the database when the analysis is opened in the Web Player. This means that the user will not be prompted for username and password to the connection when opening the analysis in the Web Player. See TIBCO Spotfire Web Player – Installation and Configuration Manual for a detailed description of how to set up the Web.config file.
Including analyses in Automation Services jobs:
To use this option when including an analysis using this data source in Automation Services jobs, specify a profile name in the text field, and make sure a matching profile is defined in the Set Credentials for External Connection task in Automation Services. The username and password specified in the task will be used for logging in to the database when the job runs. See TIBCO Spotfire Automation Services – User's Manual for more information on Automation Services jobs.
Note: This option is only useful if the analysis is going to be opened in the Web Player, or if it will be included in jobs run in Automation Services. When opening the analysis in TIBCO Spotfire Professional, the behavior will be the same as when using the option No, do not save any credentials.
   Yes, save credentials with the connection data source
Select this check box if you want the connection data source to remember the specified username and password. This means that users will not be prompted for credentials when opening a data connection which uses this data source or an analysis which includes such a data connection. This option can only be used if the connection data source is set to use database authentication.
Note: Use this option carefully, since it may be a security risk to save credentials with the connection data source.

Comments

Post a Comment

Popular posts from this blog

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 http://spotfire.tibco.com/qrt/UBSAN/presentation.html?pcode=100044   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</
5 comments
Read more

Calendar Chart in Spotfire

I recently had a colleague asking me to show him the data in a calendar format.. Something like this I basically used a scatterplot for this.  You can check out the original DXP here  http://bit.ly/spotcalendar Some key settings to make it a calendar. Please note Order date is the date of interest here These expressions are out of the box expressions, no need to handcode them, but select them in the axis value  X Axis    <BinByDateTime([Order Date],"DayOfWeek",0)> Y Axis    Week([Order Date]) Trellis into panels   <BinByDateTime([Order Date],"Year.Quarter.Month",2)> Manual layout 4 X 3 Labels  UniqueConcatenate(DayOfMonth([Order Date])) Shape Tiled Markers Marker by   <UniqueConcatenate([Order Date])> Happy plotting your calendar!!!
7 comments
Read more

Spotfire Auto Save for recovery

This is an extension I build to auto save local copies of currently open DXP every 15 minutes.. I have tested briefly and it seems to be doing its job, please please please try and test it if you can access a server and deploy.. Key Notes - This add-on will Auto Save Files while only in Spotfire Analyst Client. The save time is hard coded for every 15 minutes. Files are saved only if they are changed or user has done some actions like marking, filtering etc. The Files are saved in temporary location of the system, generally which will be like C:\Users\<username>\AppData\Local\Temp\Spotfire AutoSave If a Library file is opened it will be saved on your local machine under the temp path C:\Users\<username>\AppData\Local\Temp\Spotfire AutoSave\Library Content\ Library path will be replicated in this autosave location. e.g. C:\Users\<username> \Local\Temp\Spotfire AutoSave\LibraryContent\mylibraryfolder\mylibraryfilename_mmddyyyy_HH
4 comments
Read more