Configuring a Private Connection

See "Using Quick Connection Method" in Oracle Smart View for Office User's Guide for an alternate way to create a private connection.

To configure a private connection using the Private Connection Wizard:

  1. Start Microsoft Excel.
  2. Click Smart View and then Panel.
  3. In Smart View Panel, click the arrow next to Switch to button (Switch to), and then select Private Connections.
  4. Click Create new connection at the bottom of the panel.
  5. From Smart View, select Smart View HTTP Provider.
  6. In URL, enter the connection URL. See URL Syntax for Smart View Connections for connection syntax.
  7. Click Next.
  8. In Login, enter the user name and password for accessing the service, and then click Sign In.
  9. In Add Connection - Application/Cube, navigate to the application and cube to work with, select it, and then click Next.
  10. In Add Connection - Name/Description, enter a name for the connection and an optional description.
  11. Click Finish.