Configuring a Connection as In-Database or In-Memory Only

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:

1. On the menu bar, select Data > Manage data connections.

2. Locate the data connection of interest and click Edit.

   Comment: You might need to enter the data connection credentials to proceed.

3. In the Data Connection Settings dialog, click Edit....

   Response: The Views in Connection dialog is displayed.

4. 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.

5. Click OK.

6. 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.