About Accessing Shared Connections from an XML File

You can use private connection information stored in an XML file to connect to supported Oracle Smart View for Office providers, both cloud and on-premises, using a shared connection. You can add entries for:

• Oracle Enterprise Performance Management Cloud data sources, including Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting, and Narrative Reporting
• Oracle Enterprise Performance Management System data sources, including Oracle Hyperion Provider Services (Oracle Essbase), Oracle Hyperion Planning, Oracle Hyperion Financial Management, Oracle Hyperion Reporting and Analysis, Oracle Hyperion Strategic Finance
• Oracle Analytics Cloud - Essbase
• Oracle Business Intelligence Enterprise Edition and Oracle Analytics Cloud

The XML file can exist either locally on each individual Smart View client machine or on a web server. Smart View end users point to this XML file in the Shared Connections URL field of the Options dialog box, and then access the available providers as they would any other shared connection to which they have access.

To connect to an Oracle BI EE or Oracle Analytics Cloud provider from the Shared Connections Panel in Smart View, you must follow the procedures in this topic. However, you may also connect to Oracle BI EE or Oracle Analytics Cloud data sources from the Private Connections Panel using the procedures in Creating Private Connections in the Oracle Smart View for Office User's Guide .

Note:

Only ASCII characters are supported in the XML file. Do not use non-ASCII characters in any of the entries you make in this file.

Caution:

The procedures in this chapter should be completed by the Smart View administrator.