OLE DB Data Connection and Querying Process - trillium_discovery - trillium_quality - 17.1

Trillium Reporting Adapter for Excel Guide
Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Reporting Adapter for Excel Guide
Topic type
Overview
Administration
Configuration
Installation
Reference
How Do I
First publish date
2012

The following outlines the data connection and querying process:

  1. A connection between the repository query table definitions (scripts) and the client system is established and the connection libraries on the client system (defined as Office Data Connection (odc) files) become accessible through the TSS 17 OLE DB Reporting Adapter.

  2. The user runs a query over a data connection.

  3. The TSS 17 OLE DB Reporting Adapter extracts the metadata or data results set.

  4. One or more tables are returned to an Excel worksheet (the OLE DB Consumer) based on the query criteria.