Functionality Testing of Teradata v12 with SQL Server 2005 Analysis Services

  • Article

This blog will be a two part series…culminating from my recent internal testing of Analysis Services with Teradata v12.

The first blog entry in this series will be focused on highlighting a sequence of functionality tests that were recently concluded against Teradata version 12 using SQL Server 2005’s Analysis Services (and the latest beta v12 .NET Provider from Teradata.)

The second entry in this series will focus on the benchmarking result efforts (up to 1000 simulated users) of queries against Analysis Services. What was recorded was average response time per SSAS query using a Teradata backend source, comparing response times when Teradata v2R6.2.1.3 is used and v12 is used.

The successfully completed series of functionality tests used an Analysis Services 2005 “Post-SP2” (build 3175) instance connected to Teradata v12 for functionality testing. Using this Post-SP2 build is critical, since this SSAS SP2 doesn’t contain Teradata support. You can find information for this Post-SP2 build here: https://support.microsoft.com/kb/936305/.

The functionality tests included the following areas:

· Ability to create an Analysis Services Data Source View (DSV) against Teradata v12 using the .NET Provider for Teradata v12.

· Ability to process Analysis Services dimensions and cubes which were sourced from Teradata v12 using the .NET Provider for Teradata v12.

· Ability to query Analysis Services ROLAP cubes that are created against Teradata v12 using the .NET Provider for Teradata v12.

· Ability to execute reports from Reporting Services 2005 which have their data source defined against Analysis Services cubes that have Teradata v12 data using the .NET Provider for Teradata v12.

· Ability to execute reports from Reporting Services Report Builder 2005, whereby the Report Model was generated from an Analysis Services 2005 ROLAP cube that has its data source connected to a Teradata v12 database using the .NET Provider for Teradata v12.

I’ll be posting benchmark results during mid-March for those that are interested in seeing comparative Analysis Services query response time numbers between Teradata v2R6.2.1.3 versus Teradata v12 backend data sources.