Create an Internet-based OLAP Cube data source with Jet Reports
Overview
There are particular cases in which an organization will want users not currently on the same network as the SQL Services Analysis Services database to be able to connect to their Jet Analytics cubes. Some examples of this include remote employees or employees in satellite offices that are not constantly attached to the corporate network. Enabling a VPN connection will typically resolve this but in some cases this is not desirable.
In these cases, Microsoft Internet Information Services can be configured to provide access to SQL Server Analysis Services.
Prerequisites
Once a secure connection has been enabled between IIS and the OLAP database, Jet Reports can be configured to utilize that connection.
IIS must reside on the same server as SQL Server Analysis Services and the Jet Analytics OLAP database.
Process
-
First, you will need to create a Jet ReportsCube data source:
-
Once the General tab is displayed...
Go to the Connection tab.
Enter in the Fully Qualified Domain Name as was specified when the secure connection was created in IIS. Be sure to include the HTTPS prefix to identify this server name as a valid Internet URL. For example, https://jetreporting.cloudapp.net.
If you are a Jet Reports user, you may need to get this information from your system administrator. For now, leave the Database field blank.
-
Next, move to the Authentication tab...
Select Windows authentication (Other user) and then provide the full domain name and the credentials that have been established for you on that domain (again, you may need to get this information from your system administrator).
Please note that the HTTPS prefix is *not* used here.
-
Next, go to the Connection tab.
Use the pulldown arrow in the Database field and select the OLAP database which contains your Jet Analytics cubes.
-
Last, select Test Connection.
After the the successful dialog box appears, click the OK button, your data source should now be ready for use by Jet Reports.