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

Creating a Jet Data Warehouse data source with Jet Reports


Help Topics...

Overview

Before you can create a Data Source connection, you must first download and install Jet Reports from the Jet download site.

A Jet Data Warehouse database must have previously been created with the Jet Data Manager.  You will need login permissions for that database.  You may need to contact your system administrator to create that for you.


You’ll also need the following files and information:

  • Your Jet License Activation Code (including a Universal Connector license)
  • Database Information:
    • Server Name or IP Address
    • Authentication Type (Windows or Database)
    • Database Name
    • Database Login Information

Step-by-Step

  1. To create a new  data source connection to your Jet Data Warehouse, start by selecting Data Source Settings from the Jet ribbon.

     

     

  2. On the Data Source Settings window, click the Add button.

     

  3. On the New Data Source window, provide a name for your data source and select "Jet Data Warehouse" for the type.  Click OK.


  4. Next, specify whether your Data Warehosue database is located on a on-premises server or server being accessed through a Jet Remote Data Service.

    dwh_location.png

    Click Add

  5. You will next need to specify what type of Authentication you will use to attach to the database.

    If the server recognizes your Windows login, you can select Windows Authentication.  If you need to use a User Name and Password to access the data, you can select Database Authentication and specify your login credentials.

    dwh_auth.png

     

  6. On the Connection tab, you will provide the name of the server on which your Jet Data Warehouse database resides.

    You can then use the pulldown button to see the databases that are available.  From that list, choose the name of your Jet Data Warehouse database.

    dwh_dbname.png

     

  7. You can then click the Test Connection button and should see the Test Connection Succeeded message.

    dwh_success.png

    Click OK .

If you would like this data source to be the default data source that the Jet Excel add-in will use, click the Set Default button.

Click OK and your Jet Data Warehouse data source is now ready for use with Jet Reports.


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

Comments