Share via


Defining Report Datasets from a Teradata Database (Reporting Services)

Reporting Services provides a data processing extension that supports report data retrieval from a Teradata relational data source. After you have connected to a Teradata data source, you can create a report dataset that defines the data that you want in your report.

Note

Before you can connect a Teradata data source, the system administrator must have installed the correct version of the .NET Data Provider for Teradata on your report authoring client and on the report server. For more information, see Connecting to a Data Source (Reporting Services).

To create a dataset query, you can create an SQL query, use a macro, or select a stored procedure from a drop-down list. You can also specify dataset properties and define report parameters and query parameters. For more information, see How to: Retrieve Data from a Teradata Data Source.

There are two types of query designers: a text-based query designer and a graphical query designer. The text-based query designer opens by default and accepts non-standard query syntax (for example, expressions in the connection string). The graphical query designer displays tables and views that you can use to help design a query. For more information, see Text-based Query Designer User Interface and Graphical Query Designer User Interface.

You can also create a model from a Teradata data source. For more information, see Creating and Using Teradata-Based Report Models.

Using Query Parameters

If your query contains parameters, Report Designer automatically creates corresponding report parameters in the report definition when you type the query. When the report runs, values for the report parameters are passed to the query parameters. If you use multivalue parameters, you might need to change the syntax of the query. For more information, see Adding Parameters to Your Report and How to: Associate a Query Parameter with a Report Parameter.

Using Macros

You can use macros to return data in a dataset. To do this, in the Command Type text box, select Text, and then specify the name of the macro and its input parameters in an EXECUTE statement.

Using Stored Procedures

You can use stored procedures to return data in a dataset. To do this, in the Command Type text box, select StoredProcedure, and then provide the name of the stored procedure. Reporting Services does not support output parameters for stored procedures.