XLCubed Web Proxy

XLCubed Excel and Web editions can connect to the XLCubed Web Proxy (Enterprise Plus customers only). This allows a set of cube and relational connections to be published to XLCubed clients.

Setup

• Run the setup program while logged onto the server with administrator permissions.
• This will create a new web application in IIS (XLCubedWebProxy, by default).
• You will need to install the prerequisites as for XLCubed Web Edition.

Security Configuration

Select the XLCubedWebProxy directory and open the "Authentication" section.

Enable the desired authentication options, and ensure that the others are disabled.

If you do not have these options you must add them from Control Panel -> Programs -> Turn Windows features on or off

Web.config

Windows Authentication

Authentication	Using HTTPS	web.config: on all bindings
Windows	Yes	<security mode="Transport"> <transport clientCredentialType="Windows"/> </security>
Windows	No	<security mode="TransportCredentialOnly"> <transport clientCredentialType="Windows"/> </security>

Basic Authentication

Authentication	Using HTTPS?	web.config – on all bindings
Basic	Yes	<security mode="Transport"> <transport clientCredentialType="Basic"/> </security>
Basic	No	<security mode="TransportCredentialOnly"> <transport clientCredentialType="Basic"/> </security>

Single Sign-on

To set up Single sign-on configurations for the XLCubed Web Proxy, place the provider metadata XML file in the Auth folder (usually at C:\inetpub\wwwroot\XLCubedWebProxy\Xml\Auth), renaming it to authidentity.xml. The folder may need to be created it if it doesn't exist).

The following keys should be defined in the web.config, underneath the <configuration><appSettings> element:

AuthServiceProviderLogin

true to use Single Sign-on, or false otherwise (the default)

AuthServicePostBack (optional)

The authentication service requires a postback instead of a redirect

AuthValidationProc (optional)

A custom stored procedure to execute in the SQL Repository to validate the identity.

For example, the following would enable the authidentity.xml file that you had installed, but no include the custom postback or validation procedure.

 <configuration>
   <appSettings>
     <add key="AuthServiceProviderLogin" value="true" />
   </appSettings>
 </configuration>

Proxy Configuration

In the bin folder in the installation directory (usually at C:\inetpub\wwwroot\XLCubedWebProxy\bin will be the proxy configuration file, XLCubed.Data.Proxy.xml.

This will contain a <config> XML element, containing one multidimensionalserver or relationalserver for each connection that should be made available through the proxy. Examples are given below.

Multi-dimensional connections

 <multidimensionalserver>
   <databases>
     <database name="proxy database">
       <cubes>
         <cube name="my cube">
           <connection id="1" name="">
             <type>AnalysisServices</type>
             <variable type="String" name="server">
               <value>realServerName</value>
             </variable>
             <variable type="String" name="database">
               <value>realDatabaseName</value>
             </variable>
             <variable type="String" name="cube">
               <value>realCubeName</value>
             </variable>
             <writebacktype>AnalysisServices</writebacktype>
             <writebacksetting />
             <nodummyrelationalwriteback>0</nodummyrelationalwriteback>
             <variable type="Boolean" name="requirespassword">
               <value>0</value>
             </variable>
             <lastconnected>0001-01-01T00:00:00</lastconnected>
             <savepassword>False</savepassword>
             <props>
               <prop name="MDXMissingMemberMode" value="Error" />
             </props>
           </connection>
         </cube>
       </cubes>
     </database>
   </databases>
 </multidimensionalserver>

Relational connections

 <relationalserver>
   <databases>
     <database name="proxy database">
       <sqlconnection id="1" connectiontype="0">
         <lastconnected>2016-11-16T14:53:24</lastconnected>
         <promptcredentials>False</promptcredentials>
         <variable type="String" name="connectionstring">
           <value>Provider=SQLOLEDB;Data Source=myRealServer;Initial Catalog=myRealDatabase;User Id=connectionUser;Password=SecurePassword</value>
         </variable>
         <authtype>0</authtype>
         <resolvertype>0</resolvertype>
       </sqlconnection>
     </database>
   </databases>
 </relationalserver>