• Article

How to: Retrieve Data from a Teradata Data Source (Report Builder 2.0)

To use data from a Teradata relational database in your report, you must define a Teradata data source. When you define the data source, you must specify a connection string and credentials so that you can access the data source from the client computer.

Note

Before you can connect to 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).

You can create an embedded data source definition for use by a single report or a shared data source definition that can be used by multiple reports. The procedures in this topic describe how to create an embedded data source. For more information about shared data sources, see Embedded and Shared Data Sources (Report Builder 2.0)

After you create a Teradata data source definition, you can create one or more datasets. After you create a dataset, the name of the dataset appears in the Report Data pane as a node under its data source.

After you publish your report, you may want 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.

You can also create a report from a report model that has been built from a Teradata relational database. For more information about building a model, see "Creating and Using Teradata-Based Report Models" in the Reporting Services documentation in SQL Server Books Online. For more information about reporting from a model, see Creating Report Datasets for a Report Model (Report Builder 2.0).

To create an embedded data source that uses the .NET Managed Provider for Teradata data processing extension

  1. On the toolbar in the Report Data pane, click New, and then click Data Source.

  2. In the Data Source Properties dialog box, type a name in the Name text box or accept the default name.

  3. Verify that Embedded connection is selected.

  4. From the Type drop-down list, select TERADATA.

  5. Specify a connection string that works with your Teradata data source.

    Note

    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>

  6. Click Credentials.

  7. Set the credentials to use to connect to the data source. For more information, see Specifying Credentials for a Report Data Source (Report Builder 2.0).

  8. Click OK.

    The data source appears in the Report Data pane.

To create a dataset for a Teradata data source

  1. In the Report Data pane, right-click the name of the data source that connects to a Teradata data source, and then click Add Dataset.

  2. In the Query page of the Dataset Properties dialog box, type a name in the Name text box or accept the default name.

  3. In the Data source text box, verify that the name of the data source that you right-clicked in step 1 appears.

  4. Verify that Text is selected in the Query type box. Text is the only mode supported for a Teradata database.

  5. Click Query Designer to open the text-based query designer.

  6. In the Query pane, type a Transact-SQL command.

    Alternatively, you can paste a query, or import an existing Transact-SQL query from a file or from another report. For more information, see Text-based Query Designer User Interface (Report Builder 2.0).

  7. Click Run Query (!) to run the query and see the result set.

  8. Click OK.

    The dataset and its field collection appear in the Report Data pane under the data source node.