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:

On-Premises data sources: 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

Vanity URLs

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:

Cloud EPM sources:

Planning, Planning Modules

https://<serviceURL>/HyperionPlanning/SmartView

Enterprise Journals extension

https://<serviceURL>/HyperionPlanning/ej/svp

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

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

Sales Planning:

https://<serviceURL>/HyperionPlanning/SmartView

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

Strategic Workforce Planning

https://<serviceURL>/HyperionPlanning/SmartView

Task Manager extension (used with Planning, Planning Modules, Financial Consolidation and Close and Tax Reporting)
```
https://<serviceURL>/HyperionPlanning/cm/svp
```

Tax Reporting

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