Share via


Defining Report Datasets from a Teradata Database (Report Builder 2.0)

Report Builder 2.0 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 Example Connections (Report Builder 2.0).

To create a dataset query, you can import an existing query from a .sql file or .rdl file, or create your own query in the text-based query designer. You can type query text that contains SQL statements, a macro name, or the name of a stored procedure. For more information, see Text-based Query Designer User Interface (Report Builder 2.0). 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 (Report Builder 2.0).

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 Business Intelligence Development Studio and published on a report server. This feature is available with SQL Server 2008 Reporting Services. For more information, see "Creating and Using Teradata-Based Report Models" in the Reporting Services documentation in SQL Server Books Online.

Using Query Parameters

If your query contains parameters, report parameters are automatically created in the report definition when you run 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 (Report Builder 2.0).

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. Output parameters for stored procedures are not supported.