Teradata Connection Type (SSRS)
To include data from a Teradata relational database in your report, you must have a dataset that is based on a report data source of type Teradata. This built-in data source type is based on the .NET Managed Provider for Teradata data processing extension.
Use the information in this topic to build a data source. For step-by-step instructions, see How to: Add and Verify a Data Connection or Data Source (Report Builder 3.0 and SSRS).
In This Article
Contact your database administrator for connection information and for the credentials to use to connect to the data source. The following connection string example specifies a Teradata database on the server specified with an IP address:
data source=<IP Address>
For more connection string examples, see Data Connections, Data Sources, and Connection Strings in Report Builder 3.0.
Credentials are required to run queries, to preview the report locally, and to preview the report from the report server.
After you publish your report, you may need to change the credentials for the data source so that when the report runs on the report server, the permissions to retrieve the data are valid.
For more information, see Data Connections, Data Sources, and Connection Strings (SSRS) or Specifying Credentials in Report Builder 3.0.
Back to Top
Before you can connect a Teradata data source, the system administrator must have installed the version of the .NET Data Provider for Teradata that supports retrieving data from the Teradata database. This data provider must be installed on the same computer as Report Builder and also on the report server.
Not all report delivery modes are supported by this data provider. Delivering reports through data-driven subscriptions is not supported for this data processing extension. For more information, see Using an External Data Source for Subscriber Data in the Reporting Services documentation in SQL Server Books Online.
Back to Top
To create a dataset from a report model that is based on a Teradata data source, the model must be designed in Model Designer in SQL Server Business Intelligence Development Studio and published on a report server. For more information, see Creating and Using Teradata-Based Report Models in the Reporting Services documentation in SQL Server Books Online.
Back to Top
These sections of the documentation provide in-depth conceptual information about report data, as well as procedural information about how to define, customize, and use parts of a report that are related to data.
Adding Data to a Report (Report Builder 3.0 and SSRS)
Provides an overview of accessing data for your report.
Data Connections, Data Sources, and Connection Strings in Report Builder 3.0
Provides information about data connections and data sources.
Creating and Adding Datasets (Report Builder 3.0 and SSRS)
Provides information about embedded and shared datasets.
Working with Fields in a Report Dataset (Report Builder 3.0 and SSRS)
Provides information about the field collection that is generated by the dataset query.
Data Sources Supported by Reporting Services (SSRS) in the Reporting Services documentation in SQL Server Books Online.
Provides in-depth information about platform and version support for each data extension.
Using SQL Server 2008 Reporting Services with the .NET Framework Data Provider for Teradata
Provides detailed information about working with this data extension.
Back to Top