As a data modeler, you might want to control how data should be loaded from a data connection. Either, you can determine that data must be imported into the Spotfire data engine, or that data must be kept external, to be used in-database only.
By default, a person using a connection can choose how a database table should be loaded. This is done when adding the connection from the Files and data flyout . If you have configured a database table to allow only a specific load method, the other option will be disabled.
Note: Forcing data to be used in-database only can ensure that the user is working with current data. It can also be a good option for sensitive data in a connection, if you want to make sure that only users who are authorized to log into a database can access data from it.
However, certain features in Spotfire are not available when working with in-database data. For this reason you might want to force data to be used in-memory only.
To configure the load method of a data connection:
On the menu bar, select Data > Manage data connections.
Locate the data connection of interest and click Edit.
Comment: You might need to enter the data connection credentials to proceed.
In the Data Connection Settings dialog, click Edit....
Response: The Views in Connection dialog is displayed.
In the Views in connection list, right-click the table you want to configure. Select Load Method
and choose the desired option.Comment: Selecting External Data Only will force the user to load the data in-database. Selecting Imported Data Only will force the user to load the data in-memory.
Click OK.
Click Save.
Note: You can also configure the load method of a data connection, from the Views in Connection dialog, when adding a data connection.
See also:
Adding Data Connections to an Analysis
How to Work with Data Connections and their Data Sources in the Library