What is Teradata OLAP Connector? - Teradata Schema Workbench

Teradata Schema Workbench User Guide

Product
Teradata Schema Workbench
Release Number
16.20
16.10
15.10
Published
June 2015
Language
English (United States)
Last Update
2018-05-25
dita:mapPath
gvf1512702977003.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-4106
Product Category
Teradata Tools and Utilities

Teradata OLAP Connector provides MDX query language services. It is an MDX provider, similar to a database driver for OLAP cubes. Teradata OLAP Connector supports the ODBO standard interface that Microsoft Excel and many other OLAP clients use to interact with an OLAP cube.

The following figure shows how the OLAP Connector sits between BI client applications, such as Microsoft Excel, and Teradata Database. It interprets MDX queries (using cube metadata in the Teradata BI Model Repository) and sends Teradata-optimized SQL to Teradata Database.

Teradata OLAP Connector Architecture