Configuring Reporting Services for Teradata-based Report Models
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.
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.
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.
In Report Manager, on the toolbar, click New Data Source.
In Connection type, from the drop-down list, select Teradata.
Note: 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.
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.
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
For more information, review the Teradata documentation that is included with the data provider.
- .NET Framework Data Provider for Teradata
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.