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.

Note:

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

http(s)://<server>.<domain>:<port>/HyperionPlanning/SmartView

See:

On-premises data sources

Cloud data sources

On-Premises data sources:

Oracle Essbase:

http(s)://<server>.<domain>:<port>/aps/SmartView

Oracle Hyperion Financial Management:

Financial Management 11.1.2.4.x and later:

http://<server>.<domain>:<port>/hfmadf/../hfmadf/officeprovider

Financial Management 11.1.2.3.x and earlier:

http(s)://<server>.<domain>:<port>/hfmofficeprovider/hfmofficeprovider.aspx

Oracle Hyperion Planning:

http(s)://<server>.<domain>:<port>/HyperionPlanning/SmartView

Oracle Hyperion Reporting and Analysis - Release 11.1.2.4.7xx and earlier:
```
http(s)://<server>.<domain>:<port>/raframework/browse/listXML
```

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

http(s)://<server>.<domain>:<port>/hr/modules/com/hyperion/reporting/web/repository/HRRepositoryXML.jsp

Oracle Hyperion Financial Close Management:

http(s)://<server>.<domain>:<port>/fcc/servlets/smartview/fcmsvservlet

Oracle Hyperion Strategic Finance:

http(s)://<server>.<domain>:<port>/StrategicPlanning/SmartView

Oracle Business Intelligence Enterprise Edition:
- Using the Private Connection wizard:
```
http(s)://<server>.<domain>:<port>/analytics/jbips
```
- Using the Quick Connection method:
```
OBI:http(s)://<server>.<domain>:<port>/analytics/jbips
```

Cloud data sources:

Planning, Planning Modules, FreeForm

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
```

Enterprise Profitability and Cost Management

https://<serviceURL>/HyperionPlanning/SmartView

Oracle Sales Planning Cloud:

https://<serviceURL>/HyperionPlanning/SmartView

Tax Reporting

https://<serviceURL>/HyperionPlanning/SmartView

Task Manager extension (used with Planning, Planning Modules, 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
```

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. Use the cloud data connection format for your business process when creating your vanity URL For example:

http(s)://<yourVanityURL>