Skip to main content

Connect to the Jet Service Tier using Jet Reports

Overview

When the Jet Service Tier is deployed within an an organization, users can easily connect to their company databases without having to define data source connections on each individual computer.

Prerequisites

Users must be using Jet Reports (version 2013 or higher).

  • The Jet Service Tier must be installed and running *
  • You must be granted access to at least one data source connection in the Service Database *
  • You must know the name of the server and port on which the Jet Service Tier is running. The default number of the port is 7090, however this can be modified by the administrator during installation *

* If in doubt, your database administrator should be able to confirm these items.

Accessing the Jet Service Tier from the Jet Excel add-in

  1. Within Excel, navigate to your Jet ReportsSettings > App Settings.

  2. Select Settings Location and Jet Service Tier

    app_settings_set_loc.png

  3. Type the name of the server where the Jet Service Tier is running. It may be necessary to modify the port number.
  4. Click Test Connection.

    You should receive a success message.

    Select OK.

    Your data sources will appear and you can begin creating and running reports on any data sources for which you have permissions.

    data_source_list.png

Please note that when connecting to a database requiring an ODBC or OLE driver, that driver must be installed on each individual user's computer.

Was this article helpful?

We're sorry to hear that.