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(s)://servername:port/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 (also referred to as Close Manager extension, used with Financial Consolidation and Close and Tax Reporting)

  https://serviceURL/HyperionPlanning/cm/svp

• Supplemental Data 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