You can change a connection for an existing dataset from the dataset edit page: My datasets>edit dataset>Connection Details. Below are the settings you can change on a connection. Note that any changes on the connection will affect other datasets that were set using the same connection.
|Connection Name||Enter the connection name.|
|Host Name/ IP||Enter the host server url or ip address.|
|Port||Enter the Port number to access your DB.|
|Database||Enter the Database name.|
|User Name||Enter the User Name with at least read permission to the table you would like to connect to.|
|Password||Enter the Password. This will be encrypted and saved to be used for future data loads.|