About Managing Connection URL Mappings

Connection URL mappings allow you to migrate from one environment to another environment. Administrators configure mappings that replace old connection URLs with new URLs. The mappings can be managed from the Private Connections drop-down menu by selecting the Manage URL Mappings option.

After mapping, private and named connections are immediately migrated to the new URLs when Microsoft Excel is reopened. The new mappings persist even if a mapping is deleted. Any saved workbooks with functions using these private connections will continue to use the new URLs.

Working with Saved Workbook Containing Ad Hoc Grids

• If the mapping is not deleted, workbooks continue to use the new URL.

• If the mapping is deleted and the sheets were not refreshed and saved, then the old URL will be used.

• If you are planning to delete the mapping but still want unnamed connections in the saved sheet to use a new URL then you must activate each sheet and refresh it before saving the workbook. Ideally, a Refresh All and Save of the workbook is recommended.

• In saved ad-hoc sheets you need to do a refresh and save for new URL to persist if the map is deleted, for both named and unnamed connection.

Limitations

• Oracle Business Intelligence Enterprise Edition and Oracle Analytics Cloud are not supported.

• Oracle Hyperion Financial Management will work only if the cluster name and application are same with new and old environment.

• Essbase and Oracle Essbase: Sheets created in the cloud environment do not work in the standalone environment.

• Nested URL mapping is not supported.

• Ensure that you enter the correct URL. URL entries are not validated, so it is possible to enter an incorrect URL entry.

• If you change the mapping in options, then Oracle recommends restarting the Microsoft Excel for mapping to take effect.