ODBC 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
Administration
Overview
How Do I
Configuration
Reference
Installation
First publish date
2012

The following outlines the data connection and querying process:

  1. On a Windows system, configure an ODBC DSN to create an ODBC Office Data Connection (odc) file which facilitates communication between the repository server—including table definitions (scripts)— and Excel.

  2. The connection libraries on the server (odc files) become accessible in Excel through the TSS 17 ODBC Reporting Adapter.

  3. The user runs a query over the data connection.

  4. The TSS 17 ODBC Reporting Adapter extracts the metadata or results set. 

  5. One or more tables are returned to an Excel worksheet (the ODBC Consumer) based on the query criteria.

Figure 3-1  ODBC Data Connection Flow