# Retrieving Data From An Existing Spotfire Data Connection

The Spotfire Data Connection workspace node provides the ability to reuse existing Spotfire Data Connections that are centrally defined and stored as data resources in TIBCO Spotfire Library.

The Spotfire Data Connection workspace node can be accessed from the Feature Finder, the ribbon bar, or the Node Browser.

You can import data in the form of SBDF stream from an existing Spotfire data file (.sbdf), Information Link, or Data Connection stored in the TIBCO Spotfire library and convert it to Statistica Spreadsheet.

Workspace node can accessed using the following path: Home > New > Workspace.

## Procedure

1. Open a workspace.
2. To add a node to the workspace, select Data tab. In the Import/Export group, click Import Data, and select Spotfire Data Connection from the menu.
3. To open the Spotfire Data Connection dialog box, double-click the node.
4. In the Server field, enter the Spotfire Server URL. The default URL is https://spotfire.cloud.tibco.com
5. (Optional) Provide credentials (user name and password) for the Spotfire Server.
   Note: If no credentials are specified, Windows Integrated Authentication method is used. Integrated authentication mode must be enabled in the server to use this capability.
6. Specify the Spotfire Library Path of an existing supported item (.sbdf, Information Link, Data Connection) in the Spotfire Library.
7. Specify the Data Connection view name in the View Name field.
   Note: This field is only required if the library item mentioned in Step 6 has more than one view associated.
8. Specify the Key or Value pairs for the selected view in the View Parameters field. The parameters must be specified in YAML format.

   Following example explains how different types of parameters are entered and how they are passed:

   In YAML format, comments can be added by using # as a prefix.

   #year: 2000 #single value

   #year: [2000, 2005, 2010] #multiple values or

   #year: #multiple values or

   # - 2000

   # - 2005

   # - 2010

   #year: #multiple values or

   # - 2000

   # - [2005,2010]

   In Spotfire Data Connections workspace node, ranges can be represented by using the following convention:
   parameter_name: lower_limit - upper_limit

   #year: 2000~2010 #ranges

   Note: View Parameters are used when retrieving data by using information links or data connections.
   Note: In YAML special characters like [ ] { } > | * & ! % # ` @ , . cannot be used as the first character of an unquoted parameter value. Example, use name: "@id" instead of name: @id to specify the view parameter.
9. (Optional) To generate a report, select the Generate Report check box under Reporting Document group box.
   Note: This report contains information regarding the specified library item and the list of specified view parameters.
10. To generate a downstream Statistica spreadsheet containing the data returned by the Spotfire Server for the selected Spotfire Library item, click OK.

Copyright © TIBCO Software Inc. All rights reserved.