Editing a Data Connection

You can modify an existing data connection's properties, including its name, whether or not it requires authentication each time it is used, and whether it should fetch the database schema.

Implementation:

  1. Switch to the Definition tab.
  2. Click .
  3. Switch to the Your Connections panel.
  4. Select the intended connection.
  5. Click Edit.

If the chosen connection is being used by any data sources in the model, a warning dialog will appear and you will need to complete steps 6-7 before you can continue. Otherwise, the Data Source Connection dialog will open, and you should proceed straight to step 8.

  1. (Optional) Click the Copy Old Settings to the Clipboard button to copy the connection's settings, then paste them into a text document or similar in case you need to re-create them later.
  2. To proceed with editing the connection, click Yes. This will open the Data Source Connection dialog. Clicking No will end this process.
  3. Use the dialog to modify the connection's properties. This interface and the options it contains will differ depending on whether you are creating an external data connection or an SQL server connection.
  4. Click Save to confirm your changes.