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:
- Start Microsoft Excel.
- Click Smart View and then Panel.
- In Smart View Panel, click the arrow next to
(Switch to), and then select Private Connections.
- Click Create new connection at the bottom of the panel.
- From Smart View, select Smart View HTTP Provider.
- In URL, enter the connection URL. See URL Syntax for Smart View Connections for connection syntax.
- Click Next.
- In Login, enter the user name and password for accessing the service, and then click Sign In.
- In Add Connection - Application/Cube, navigate to the application and cube to work with, select it, and then click Next.
- In Add Connection - Name/Description, enter a name for the connection and an optional description.
- Click Finish.