Sign Up for Training |
Jet Global Company Site
Community
Downloads
Submit a Request
Give Feedback

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

IIS must reside on the same server as SQL Server Analysis Services and the Jet Analytics OLAP database.

Once a secure connection has been enabled between IIS and the OLAP database , Jet Reports can be configured to utilize that connection.

Process

  1. First, you will need to create a Jet Reports Cube data source:

    OLAP0b.png


    Once the General tab is displayed...

    OLAP1b.png

     

    Move to the Connection tab...

    OLAP2b.png

    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

    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

  2. Next, move to the Authentication tab...

    OLAP3b.png

    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.

  3. Next, return to the Connection tab...

    OLAP4b.png

    Use the pulldown arrow in the Database field and select the OLAP database which contains your Jet Analytics Cubes

Once you click the OK button, your data source should now be ready for use by Jet Reports.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments