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.
PrerequisitesUsers 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
Within Excel, navigate to your Jet Reports App Settings:
Select Settings Location and Jet Service Tier.
Type the name of the server where the Jet Service Tier is running. It may be necessary to modify the port number.
Click Test Connection
You should receive a success message.
Your data sources will appear and you can begin creating and running reports on any data sources for which you have permissions.
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.