Connection mapping

Review an example of the XML file

• Matches cube connections to the Development server and replaces them with connections to the Production server
• Matches the AdventureWorksDW SQL connection to the WSAMZN-RI8SHC08 server and replaces it with the AdventureWorksDW SQL connection on the localhost server
  • You can have multiple match elements for an SQL connection. If so, all must match
• Note that the database and cube names you map to are case-sensitive.

<?xml version="1.0" encoding="utf-8"?> <connectionmapper> <connectionmap> <from> <connection id="0" name=""> <type>AnalysisServices</type> <variable type="String" name="server"><value>DEVELOPMENT</value></variable> <variable type="String" name="database"><value>Demo Database</value></variable> <variable type="String" name="cube"><value>Demo Cube</value></variable> </connection> </from> <to> <connection id="0" name=""> <type>AnalysisServices</type> <variable type="String" name="server"><value>PRODUCTION</value></variable> <variable type="String" name="database"><value>Demo Database</value></variable> <variable type="String" name="cube"><value>Demo Cube</value></variable> <variable type="Boolean" name="requirespassword"><value>0</value></variable> <props /> </connection> </to> </connectionmap> <sqlconnectionmap> <match>.*Data Source=WSAMZN-RI8SHC08.*</match> <match>.*Initial Catalog=AdventureWorksDW.*</match> <connectionstring>Provider=SQLOLEDB;Data Source=localhost\MSSQLSERVER02;Initial Catalog=AdventureWorksDW;Trusted_Connection=Yes</connectionstring> </sqlconnectionmap> </connectionmapper>

You can control whether the connection mapping is undone when downloaded as Live using a setting in the web.config file, UnmapConnectionsOnExport. If true, the connections are restored to their original values. If false, then the connection mapping is saved in the downloaded file.

For more information, review Customizing web config.