1. User's Guide
  2. Managing Data Source Connections
  3. Creating Private Connections
  4. Private Connection URL Syntax

Private Connection URL Syntax

This topic lists the syntax that Oracle Smart View for Office requires for creating private connections to on-premises and cloud data sources.

See:

On-premises data sources

Cloud data sources

On-Premises data sources:

  • Oracle Essbase: 

    http(s)://servername:port/aps/SmartView

  • Oracle Hyperion Financial Management:

    • Financial Management 11.1.2.4.x and later: 

      http://servername:port/hfmadf/../hfmadf/officeprovider

    • Financial Management 11.1.2.3.x and earlier: 

      http(s)://servername:port/hfmofficeprovider/hfmofficeprovider.aspx

  • Oracle Hyperion Planning: 

    http(s)://servername:port/HyperionPlanning/SmartView

  • Oracle Hyperion Reporting and Analysis - Release 11.1.2.4.7xx and earlier: 

    http(s)://servername:port/raframework/browse/listXML

  • Oracle Financial Reporting Document Repository - Release 11.1.2.4.9xx and later:

    http(s)://servername:port/hr/modules/com/hyperion/reporting/web/repository/HRRepositoryXML.jsp

  • Oracle Hyperion Financial Close Management: 

    http(s)://servername:port/fcc/servlets/smartview/fcmsvservlet

  • Oracle Hyperion Strategic Finance: 

    http(s)://servername:port/StrategicPlanning/SmartView

  • Oracle Business Intelligence Enterprise Edition:

    • Using the Private Connection wizard:

      http(s)://servername:port/analytics/jbips

    • Using the Quick Connection method:

      OBI:http(s)://servername:port/analytics/jbips

Cloud data sources:

  • Planning 

    https://serviceURL/HyperionPlanning/SmartView

  • Planning Modules 

    https://serviceURL/HyperionPlanning/SmartView

  • Oracle Hyperion Financial Reporting (Reporting Settings / Document Repository): 

    https://serviceURL/hr/modules/com/hyperion/reporting/web/repository/HRRepositoryXML.jsp

  • Narrative Reporting 

    https://serviceURL/epm/SmartView

  • Financial Consolidation and Close 

    https://serviceURL/HyperionPlanning/SmartView

  • Profitability and Cost Management: 

    https://serviceURL/aps/SmartView

  • Oracle Sales Planning Cloud: 

    https://serviceURL/HyperionPlanning/SmartView

  • Tax Reporting 

    https://serviceURL/HyperionPlanning/SmartView

  • Task Manager extension (used with Financial Consolidation and Close and Tax Reporting) 

    https://serviceURL/HyperionPlanning/cm/svp

  • Supplemental Data Manager extension (used with Financial Consolidation and Close and Tax Reporting) 

    https://serviceURL/HyperionPlanning/sdm/svp

  • Strategic Modeling extension 

    https://serviceURL/HyperionPlanning/SmartView

  • Oracle Analytics Cloud:

    • Using the Private Connection wizard:

      https://serviceURL/analytics/jbips

    • Using the Quick Connection method:

      OBI:https://serviceURL/analytics/jbips

  • Oracle Analytics Cloud - Essbase: 

    https://serviceURL/essbase/smartview

Related Topics:

Using the Private Connection Wizard

Using the Quick Connection Method

Saving Shared Connections as Private Connections

Vanity URLs

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 depends on whether you are connecting to an on-premises data source or a cloud business process. For example: 

http(s)://<yourVanityURL>