You can connect to only one data source per worksheet with these exceptions:
Essbase—You can connect to multiple Essbase databases on a single worksheet, as described in Changing Connections in Multiple-Grid Worksheets
Oracle Business Intelligence Enterprise Edition—You can connect to multiple Oracle Business Intelligence catalogs on a single sheet, as described in Connecting to Multiple Oracle BI EE Data Sources
To connect to a data source:
From Smart View Home or from the menu displayed when you click the arrow next to
, do one of the following:Select Shared Connections to open the Shared Connections panel, where you select a data source from the drop-down menu. Connections available for the selected data source are displayed in a tree list.
Note:
If you are accessing Oracle Planning and Budgeting Cloud Service, the EPM Workspace login screen is displayed. Enter your Oracle Cloud Identity Service Domain credentials and identity domain, and then select a data source from the drop-down menu. Proceed to step 4.
Click Private Connections to open the Private Connections panel, where you select a connection from the drop-down menu.
Click Private Connections. Enter a URL in the field and press Enter. For examples of the URL syntax to use, see Creating Private Connections.
Click a connection name under Recently Used. You can click
to pin items to this list.
In Connect to Data Source, enter your user name and password for the data source.
In the Smart View Panel tree list, double-click the item—form, ad hoc grid, Smart Slice, task list, or catalog—that you want to open.
After the item is opened on the grid, you can easily locate it in the tree view. Click the arrow next to
and select Locate Worksheet Connection.
Related Topics:
Shared Connections and Private Connections
Disconnecting from Data Sources