No Queries Available - trillium_discovery - trillium_quality - Latest

Trillium Reporting Adapter for Excel Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Reporting Adapter for Excel Guide
Copyright
2024
First publish date
2012
Last updated
2024-10-18
Published on
2024-10-18T15:31:00.219841

Problem

You create a connection to the data source but no queries display in the Data Connection Wizard.

Solution

Ensure the following:

  • You have permission to access the files.
  • (ODBC only) The properties and connection information for the DSN you are using is accurate. If a value was entered incorrectly then the DSN is invalid.
  • Your Trillium License Server Configuration File includes the proper reporting option depending on which reporting adapter you use (for example, license {feature REPORTING OLEDB} 2020-09-24 {}).

Do one of the following:

  • On the Trillium server system:
    1. Navigate to C:\Program Files\Trillium Software\MBSW\trillium_version\etc.
    2. Open the license.txt file.
    3. Check if it contains one of the following sections:
      • license {feature REPORTING ODBC} and a valid date range, such as 2015-11-08 2020-11-08.
      • license {feature REPORTING OLEDB} and a valid date range, such as 2015-11-08 2020-11-08.
  • On your client system:
    1. Log on to the Control Center and the repository you are running the queries against.
    2. Click the Help icon on the ribbon and select About. The About Trillium Control Center window opens.
    3. In the Licenses held field, scroll through the list and check if a data reporting license is listed with a valid expiration date.