Connecting to Multiple Oracle Analytics Cloud Data Sources
You connect to Oracle Analytics Cloud data sources using private connections.
See Creating Private Connections.
To connect using shared connections, the shared connection information must be stored in a file, as described in Accessing Shared Connections from an XML File in the Oracle Smart View for Office Installation and Configuration Guide.
Additionally, Oracle Smart View for Office supports multiple Oracle Analytics Cloud private connections on one Office worksheet, slide, or document.
For example, in one worksheet, you may insert two graphs from two different Oracle BI Presentation Catalogs and refresh the sheet. Each graph will be updated with the latest data from the two different servers.
When connected to multiple Oracle Analytics Cloud servers:
-
Users can switch between those connections in the Smart View Panel and browse the respective catalogs.
-
Users can insert views from the different connections into the same Office document.
-
If View Designer is launched from the Smart View ribbon and no Oracle Analytics Cloud view is selected, then View Designer will be connected to the Oracle Analytics Cloud server that was last used.
-
If Paste is invoked from the Smart View ribbon to paste content from Oracle Analytics Cloud, the paste action will use the Oracle Analytics Cloud connection that was last used.
-
When refreshing a document containing views from different connections, the views will be refreshed against the servers from which they were inserted.
-
There can be only one Excel pivot table view per Excel worksheet. Additionally, Excel pivot table views are always inserted onto a new worksheet. This is the expected behavior, whether you are working with a single data source connection or with multiple connections.
To connect to multiple Oracle Analytics Cloud private connections: