1. User's Guide
  2. Data Source Connections
  3. Disconnecting from Data Sources

Disconnecting from Data Sources

You can disconnect from the current connection or from all connections.

To disconnect only from the current connection:

  1. From the Smart View Panel, select the connection that is currently open in the tree list.

  2. Optional: To find this connection quickly, click the arrow next to Go button and select Locate Worksheet Connection.

  3. Right-click and select Disconnect.

    Disconnecting from the current connection does not invalidate single-sign on (SSO).

To disconnect from all connected shared connections and private connections:

  1. From the Smart View Panel, click Home button.

  2. Select Disconnect All.

    This selection invalidates SSO, and you must log in again the next time you connect.

Note:

If you are using WebView2 and have issues with Disconnect All not working or Excel failing during a Disconnect All, try adding the registry flag, PreserveThirdPartyCookies, and set it to "0". For more information, see WebView2 and Disconnect Issues in Oracle Smart View for Office Installation and Configuration Guide.