Editing a data connection

If you have added data to the analysis using a connection to an external data source (e.g., Salesforce or Google Analytics) you might encounter situations when you want to change which columns to fetch, modify the date range to look at, or, in certain cases, add or remove views (data tables) in the data connection. Then, you can use the Data canvas to edit the connection.

Before you begin

You must have some data loaded in the analysis and the analysis must be in Editing mode.

The connection you want to edit must be embedded in the analysis. To edit data connections and data sources that are saved in the library, use Manage Data Connections from the installed client.

Note: More connectors are available for editing when using the installed client. There, you can also perform changes to the data source settings in the connection, such as changing the authentication method, editing timeout settings, or moving from a test database to a production database.

Procedure

On the authoring bar, click Data canvas .
Make sure the data table of interest is selected.
This step is only applicable if you have two or more data tables in the analysis.
In the data canvas, locate the node that represents the data source of interest and click the Edit settings button at the lower part of the node.
Make the desired changes to the data and click OK when you are done.

Note: Some data connections (e.g., data from Salesforce) allow you to edit more than the view you are currently working with if you click Enable full editing of connection. By doing this, your changes may affect other data tables than the one you are currently looking at. You can also add or remove views in the connection. When using the installed client and full editing has been enabled for connections to relational databases, you can edit the data source settings by clicking Edit data source settings.

Results

The analysis is updated with the edited data.

Example: Editing a Salesforce connection

In this example, source data from Salesforce is edited. When clicking the Edit settings button in the data canvas, the Edit data from Salesforce dialog is shown (or Views in Connection in the installed client). It is basically the same dialog as the one used when Accessing data from Salesforce. When opened from this context, the only view available for editing is the one used to add the data used in the selected node:

You can click to add columns that had been previously left out, or clear the check boxes for columns that you no longer want to include in the analysis.

If you want to make bigger changes to the entire Salesforce connection, click Enable editing of full connection.

When the full connection is enabled for editing, you can make changes to other views than the one you started out with. You can also add more views to the connection (which will be added as new data tables in the analysis), or, you can remove views.

While full editing enables Edit Data Source Settings in the installed client, the web client instead enables the Edit login settings button, which gives you the possibility to change the username and password or to use a sandbox URL instead of the regular Salesforce instance.