Data Sources for TIBCO Spotfire Metrics Services

Here you can find connection details and requirements for a number of static and dynamic data sources that TIBCO Spotfire Metrics Services supports.

Source	Connection Details and Requirements
Microsoft SQL Server Analysis Services	Microsoft Analysis Services OLE DB Provider for Microsoft SQL Server 2012. See Installing Microsoft Online Analytical Processor. SQL Server Analysis Services log in credentials.
Microsoft Excel	Microsoft Excel OLE DB Data Provider. See http://www.microsoft.com/en-us/download/details.aspx?id=13255. Note: If the first installation of the OLEDB Data Provider is unsuccessful, see http://www.microsoft.com/en-us/download/details.aspx?id=23734 Spotfire Metrics supports only Microsoft Excel 2007 and later releases, with the file extension .xlsx. Note: A newly added spreadsheet will appear in the Spotfire Metrics Modeler Query tab within 10 minutes, as the default refresh value in the web configuration is set to 10 minutes.
Google Spreadsheet	Google log in credentials.
Oracle	64-bit ODAC 11.2 Release 5 Xcopy for Windows x64. See http://www.oracle.com/us/products/tools/index-090165.html Connection string. See Establishing an Oracle Connection String.
SBDF in the TIBCO Spotfire Server Library	Host server URL for Spotfire Web Player . Path to an SBDF file within the server library. Host=http://webplayerserver.domain.com/SpotfireWeb;Path=MyFolder/mydata;Uid=;Pwd=; Spotfire Server log in credentials. Path w/ authentication: Host=<host>;Path=<path>; Uid=<username>;Pwd=<password>; Path w/o authentication: Host=<host>;Path=<path>; Uid=;Pwd=;
SQL Server 2005 or later	SQL Server credentials or Windowsauthentication. Connection string, specified as follows: Windows Authentication Server=<`server`>;Database=<`database`>; Integrated Security=SSPI; SQL Authentication Server=<`server`>; Database=<`database`>; Uid=<`username`>;Pwd=<`password`>;
Teradata	Teradata OLE DB Provider. See http://downloads.teradata.com/download. Teradata log in credentials.