Private Connection URL Syntax

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

See:

On-Premises Data Sources

Note:

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

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

Oracle Essbase on-premises:
- Essbase 21c and later:
```
https://<server>.<domain>/essbase/smartview
```
- Essbase 11.1.2.4 and earlier:
```
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

Cloud EPM:

Enterprise Profitability and Cost Management

https://<serviceURL>/HyperionPlanning/SmartView

Financial Consolidation and Close

https://<serviceURL>/HyperionPlanning/SmartView

Oracle Hyperion Financial Reporting (Reporting Settings / Document Repository):
```
https://<serviceURL>/hr/modules/com/hyperion/reporting/web/repository/HRRepositoryXML.jsp
```

FreeForm

https://<serviceURL>/HyperionPlanning/SmartView

Planning, Planning Modules

https://<serviceURL>/HyperionPlanning/SmartView

Profitability and Cost Management:
```
https://<serviceURL>/aps/SmartView
```

Sales Planning:

https://<serviceURL>/HyperionPlanning/SmartView

Strategic Workforce Planning

https://<serviceURL>/HyperionPlanning/SmartView

Tax Reporting

https://<serviceURL>/HyperionPlanning/SmartView

Cloud EPM extensions:
- Admin Extension
```
https://<serviceURL>/HyperionPlanning/SmartView
```
- Enterprise Journals extension
```
https://<serviceURL>/HyperionPlanning/ej/svp
```
- Narrative Reporting extension
```
https://<serviceURL>/epm/SmartView
```
- Reconciliation Compliance extension
```
https://<serviceURL>/arm/arcs/svp
```
- Strategic Modeling extension
```
https://<serviceURL>/HyperionPlanning/SmartView
```
- Supplemental Data Manager extension (used with Financial Consolidation and Close and Tax Reporting)
```
https://<serviceURL>/HyperionPlanning/sdm/svp
```
- Task Manager extension (used with Planning, Planning Modules, Financial Consolidation and Close and Tax Reporting)
```
https://<serviceURL>/HyperionPlanning/cm/svp
```
Oracle Analytics Cloud:
- Using the Private Connection wizard:
```
https://<serviceURL>/analytics/jbips
```
- Using the Quick Connection method:
```
OBI:https://<serviceURL>/analytics/jbips
```
Oracle Essbase Cloud:
```
https://<serviceURL>/essbase/smartview
```

Vanity URLs (Cloud Data Sources Only)

In Smart View 20.200 and later, 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>