The following outlines the data connection and querying process:
-
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.
-
The user runs a query over a data connection.
-
The TSS 17 OLE DB Reporting Adapter extracts the metadata or data results set.
-
One or more tables are returned to an Excel worksheet (the OLE DB Consumer) based on the query criteria.
