Creating Shared Connections

You create a shared connection using a connection URL provided to you by your Oracle Smart View for Office administrator, or a vanity URL.

When you have the connection URL information, you can complete the procedure in this topic.

Note:

When specifying the <server> parameter, always include the domain name parameter, <domain>. For example:

http(s)://<server>.<domain>:<port>/workspace/SmartViewProviders

To create a shared connection in Smart View:

  1. From the Smart View ribbon ribbon, click Options.
  2. In the Options dialog box, select the Advanced tab.
  3. In the Shared Connections URL text box, enter the connection URL provided to you by your Smart View administrator.

    The URL syntax for on-premises connections is:

    http(s)://<server>.<domain>:<port>/workspace/SmartViewProviders

    The URL syntax for a cloud connection to a single cloud business process is:

    http(s)://<serviceURL>/workspace/SmartViewProviders

    The URL syntax for a cloud connection to multiple Oracle Enterprise Performance Management Cloud business processes on the same domain is:

    http(s)://<serviceURL>/HyperionPlanning/SmartView

    Note:

    EPM Cloud Service Administrators: See Administering Planning, Connecting Environments in EPM Cloud for information on setting up multiple providers on a single shared connection.

    Starting in release 20.200, for vanity URLs (also referred to as custom URLs), using the syntax above, enter the URL you have configured with your third-party link shortening vendor. The syntax you use in your configuration depends on whether you are connecting to an on-premises data source, a single cloud business process, or multiple cloud business processes on the same domain. For example:

    http(s)://<yourVanityURL>
  4. Click OK to close the Options dialog box.
  5. Connect by following the procedure in Connecting to Data Sources.