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. The folder may need to be created it if it doesn't exist).

It is also possible to set up the following keys in your web.config:

AuthServicePostBack

The authentication service requires a postback instead of a redirect

AuthValidationProc

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

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>