Use this dialog to add one or more data tables to your analysis. For some data sources you can also apply one or more transformation steps before adding the new data table.
Option |
Description |
Data
tables |
Lists all data tables that you have selected to add to the analysis, along with information about their origin and any transformations. |
Add |
Opens a drop-down list where you can select the source to add a data table from. At the top of the list you can enter a phrase to search for and limit the number of shown options in the list. The search is not context-sensitive. Different types of sources are grouped under headers as described below. |
File... |
Allows you to add data tables from one or more files. |
Information
Link... |
Allows you to add data tables from one or more information links. |
Data
from Library... |
Allows you to add a data table from an SBDF file located in the library. |
Data Connection in Library... |
Allows you to add data tables from a saved connection in the library. By default, all views in the connection will be included as data tables in your analysis. To exclude a data table based on a connection view from your analysis, clear the check box for the table in the Data tables list. |
Data Source in Library... |
Allows you to connect to a saved data source in the library. See Views in Connection or, for cube data sources, Data Selection in Connection for more information about selecting what data to include in a connection to a data source. |
Clipboard |
Allows you to add a data table from the clipboard. |
Data
Function... |
Allows you to add a data table from a data function. |
Connection
To |
Use one of the data connection options to add data tables from an external data source. It can be particularly useful when you are analyzing massive amounts of data and you want to keep the aggregation of data in the database (in-db) rather than bringing the data into Spotfire's internal data engine. However, data tables from connections can also be imported. When a data connection is added to the analysis, all views in the connection will be available within the analysis until the connection or a view is removed using Edit > Data Connection Properties, regardless of whether the view is added as a data table or not. Therefore, you should use the option From Current Analysis (see below) to add more views from an already used connection rather than adding another connection to the same source. See What is a Data Connection? for more information. Note: If a connector is listed in gray text under Unavailable Connectors, it means you must install a data source driver on your computer to use that connector. See Getting Started with Connectors for more information on installing data source drivers. Note that the available connection types depend on which licenses and drivers you have access to. See Connectors Overview for more information. |
From
Current Analysis |
Allows you to add a data table from the current analysis. For example, you may want to pivot or otherwise transform the data in an already existing data table, but you also want to keep the original data in the analysis. This option is also the preferred option if you decide to add a data table based on a view from a previously added data connection. See What is a Data Connection? for more information. |
Other |
Allows you to add data from other data sources that might be available to you. For example, you can add a data table from a database and bring the data into Spotfire's internal data engine (in-memory analysis). |
Remove |
Removes the selected data table from the Data tables list. Note: It is not possible to remove single data tables originating from a data connection using this button. Data connections are edited by selecting Edit > Data Connection Properties, or by clicking on the data source node in the Source view of the expanded Data panel. However, you can exclude a data table from a data connection you do not have permission to edit by clearing the check box of the table in the Data tables list. |
Edit... |
[Only applicable when working with data tables based on data connections that you are allowed to edit.] Opens the Views in Connection dialog (for data connections from relational data sources) or the Data Selection in Connection dialog (for cube data sources). |
Name |
Allows you to change the name of the selected data table. |
Load
method |
[The option to change the load method is only applicable when working with data from connections to external systems.] Note: When you are adding data from data connections, the views in a connection may have been restricted to only allow a certain load method. This is specified when setting up the data connection in the Views in Connection or Data Selection in Connection dialog. Data connections based on stored procedures or SAP HANA Information views only support the Import data option. |
Import
data |
Select this option to bring the data in the selected data table into Spotfire's internal data engine (in-memory analysis). |
Keep
data external |
Select this option if you want the data in the selected data table to remain in-database. |
Load on demand |
[Only applicable when working with data tables based on information links or data tables in connections to external systems.] |
Settings... |
Opens the On-Demand Settings dialog where you specify what will control the loading of data. |
Show
transformations |
Expands the dialog and allows you to apply transformations on the data table you want to add. For more information, see Details on Show Transformations. Note: You cannot apply transformations when loading data from a data connection. If you have selected to import the data table, you can apply transformations after loading the data, by selecting Insert > Transformations. |
Manage
Relations |
Opens the Manage Relations dialog where you can specify how the new data tables are related to each other or any previously loaded data tables in your analysis. When working with in-database data tables you must add the data tables to the analysis before you can add any relations. Open this dialog via the Data Table Properties dialog at a later stage instead. |