Difference between revisions of "XLCubed Web Proxy"

(Single Sign-on)
Line 54: Line 54:
  
 
====Single Sign-on====
 
====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 {{Code|C:\inetpub\wwwroot\XLCubedWebProxy\Xml\Auth}}. The folder may need to be created it if it doesn't exist).
+
To set up [[Single sign-on]] configurations for the XLCubed Web Proxy, place the provider metadata XML file in the Auth folder (usually at {{Code|C:\inetpub\wwwroot\XLCubedWebProxy\Xml\Auth}}), renaming it to {{Code|authidentity.xml}}. 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:
+
The following keys should be defined in the web.config, underneath the <configuration><appSettings> element:
; AuthServicePostBack
+
; AuthServiceProviderLogin
 +
: true to use Single Sign-on, or false otherwise (the default)
 +
; AuthServicePostBack (optional)
 
: The authentication service requires a postback instead of a redirect
 
: The authentication service requires a postback instead of a redirect
; AuthValidationProc
+
; AuthValidationProc (optional)
 
: A custom stored procedure to execute in the SQL Repository to validate the identity.
 
: 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==
 
==Proxy Configuration==

Revision as of 13:52, 26 September 2019

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.

XLCubedWebConfigIIS6Authentication.png

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

XLCubedWebConfigIIS6AuthenticationWindows.png

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>