Requirement
There are two URL`s which needs to be used and connected as shared connection in excel smartview.
Users don`t have to enter the URL manually when they want to connect to that environment.
Rather they want an option where if they click on Shared connection and click on the drop down it should list those two required URL`s
Create a XML file in the below format, Save and name that file as "SharedConnection"
<?xml version="1.0" encoding="UTF-8"?>
<res_GetProvisionedDataSources>
<Product id="HP" name="name" displayVersion="version">
<Server name="ENVIRONMENT 1" context="https://<URL>/SmartView"></Server>
</Product>
<Product id="HP1" name="name" displayVersion="version">
<Server name="ENVIRONMENT 2" context="https://<URL>/SmartView"></Server>
</Product>
</res_GetProvisionedDataSources>
Save the file to the location where smartview is installed "C:\Oracle"
Then Close Excel and reopen - You will find those two URL as shown below
