Configuring Reporting Services for Teradata-based Report Models
New: 17 November 2008
SQL Server 2005 Reporting Services Service Pack 3 (SP3) and later versions include report model support for the .NET Framework Data Provider for Teradata.
Before you can configure a report server or report authoring client to build a report model based on a Teradata database, you must download the .NET Framework Data Provider for Teradata version 12.00.00.01 from Teradata Corporation. This data provider supports retrieving data from Teradata databases running versions 12.0 or 6.20.
After you install the .NET Framework Data Provider for Teradata on the report server and on the report authoring client, follow the steps in this topic to register the data provider and configure Reporting Services so that you can build a report model based on a Teradata database.
Reporting Services supports building report models based on the following Teradata database versions:
- Teradata version 12.0
- Teradata version 6.20
The following operating systems are supported:
- Microsoft Windows Server 2003
- Microsoft XP Professional
- Microsoft Windows 2000 Professional
Configure the Report Server
To configure the report server for Teradata-based models, you must manually change the RSReportServer.config file. After you modify the configuration file, in Report Manager, verify that the Teradata data extension appears in the list of available data source types.
To configure the report server for Teradata-based models
On the report server, open RSReportServer.config. By default, this file is located in <SysDrive>:\Program Files\Microsoft SQL Server\MSSQL.n\Reporting Services\ReportServer.
In the <Data> section, add the following entry. This entry must be on one line with no line breaks.
<Extension Name="TERADATA" Type="Microsoft.ReportingServices.DataExtensions.TeradataConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
This registers the data processing extension on the client that connects to a Teradata database.
In the <SemanticQuery> section, add the following entry. This entry must be on one line with no line breaks.
<Extension Name="TERADATA" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Teradata.TdSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine"> <Configuration> <EnableMathOpCasting>True</EnableMathOpCasting> <ReplaceFunctionName>oREPLACE</ReplaceFunctionName> </Configuration> </Extension>
This registers the model query language for the Teradata data source.
In the <ModelGeneration> section, add the following entry. This entry must be on one line with no line breaks.
<Extension Name="TERADATA" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Teradata.TdSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine" />
Save the file.
Restart Reporting Services on the report server. For more information, see Starting and Stopping the Report Server Windows Service.
To verify the report server configuration
In Report Manager, on the toolbar, click New Data Source.
In Connection type, from the drop-down list, select Teradata.
The data source type Teradata appears only if the Teradata data provider is installed correctly on the report server. If you do not see Teradata, work with the system administrator to verify the configuration changes. For more information, see RSReportServer Configuration File. For troubleshooting information, see Reporting Services Log Files.
To generate a report model from the Teradata data source, see How to: Create a Report Model with Primary Keys from a Teradata Database.
Configure the Report Authoring Client
To configure the report authoring client so that you can build a report model from a Business Intelligence Development Studio report model project, you must install the .NET Framework Data Provider for Teradata on the client machine.
To configure the report authoring client
Close Business Intelligence Development Studio if it is open.
Download and install the .NET Framework Data Provider for Teradata 12.00.00.01 from Teradata.
When you install the .NET Framework Data Provider for Teradata, select the following setup features:
- .NET Framework Data Provider for Teradata
- Microsoft Visual Studio 2005 Integration
- Publisher Policy
For more information, review the Teradata documentation that is included with the data provider.
To verify that the installation was successful, create a Teradata data source in a BI Development Studio report model project. For more information, see How to: Create a Teradata Data Source File for a Report Model Project.