How to update database server information on existing data connections

How to update database server information on existing data connections

Sometimes it is preferred to update an existing data connection, rather than creating a new one.
A scenario can be when only the data source information has changed, but the tables and columns from where the data is fetched remain the same.
For example this can be the case when moving from a test to a production environment where the database is only stored on different servers, but contain identical tables and columns.

Please note: it is crucial that the table names and column names are identical in the old and new database environment, for the data connection to work after updating data source information. Depending on how the data connection has been created, you can update the connection in the following ways:

If you connected to the database via "Add tables" then you can change database server by following these steps:

For version 7.14 and earlier:
1. Go to Edit - Data Connection Properties
2. Highlight the connection and click Settings
3. A Data Connection Settings window opens
4. Go to tab Data Source and click Settings
5. In tab Login, click Edit and you will receive the window where you can edit the data source information.

For version 10.0 and higher:
1. Go to Data - Data connection properties
2. Highlight the connection and click Settings
3. A Data Connection Settings window opens
4. Go to tab Data Source and click Settings
5. In tab Login, click Edit and you will receive the window where you can edit the data source information.


If the data connection is saved in library you can change database server by following these steps:

For version 7.14 and earlier:
1. Go to Tools > Manage Data Connections
2. Browse to the data connection
3. Highlight and click Edit OR right-click - Edit Data Connection
4. Logon the data source if required
5. A Data Connection Settings window opens
6. Go to tab Data Source and click Settings
7. In tab Login, click Edit and you will receive the window where you can edit the data source information.

For version 10.0 and higher:
1. Go to Data > Manage data connections
2. Browse to the data connection
3. Highlight and click Edit OR right-click - Edit Data Connection
4. Logon the data source if required
5. A Data Connection Settings window opens
6. Go to tab Data Source and click Settings
7. In tab Login, click Edit and you will receive the window where you can edit the data source information. Keywords: update , data connection , dataconnection