How to: Create a Teradata Data Source File for a Report Model Project

New: 17 November 2008

To create a data source file for a Teradata database in Model Designer, you must specify a connection string and credentials that are sufficient to connect to the database server and to retrieve data from the database. You can also specify data dictionary properties for the Teradata data provider to help control the time it takes to retrieve metadata for the database. Note that you can also create a data source file for a Teradata database in Report Manager; however, you can only view data dictionary properties for the data source in Model Designer.

After you create the data source file, you can create a data source view and a model.

To create a data source file for a Teradata database in a report model project

1. Create a new report model project.

   • In Business Intelligence Development Studio, click File, and then New.

   In the Templates pane, click Report Model Project, and then click OK. A new report model project opens. Solution Explorer displays three folders: Data Sources, Data Source Views, and Report Models.

2. In Solution Explorer, right-click Data Sources, and then click Add New Data Source. The Data Source Wizard dialog box opens.

3. Click Next. The Select how to define the connection page opens.

4. Click New. The Connection Manager dialog box opens.

5. In Provider, from the drop-down list, select the .NET Framework Data Provider for Teradata.

6. In Server name, type the IP address for the server.

   Note

   If you do not know the information requested, contact the system administrator.

7. In Login Details, for User name and Password, type the name and password of an account that has access to the specified server.

   Note

   The credentials to use are specified by the system administrator or database owner. For more information about credentials, see Specifying Credential and Connection Information.

8. Click All. The connection properties appear in a grid.

9. In Data Dictionary, enter the following three values:

   1. For Database, type the name of the database.
   2. Set Restrict to Default Database to True.
   3. Set Use X Views to False.

   Note

   These settings restrict data retrieval on the server to the default database. This improves schema discovery and retrieval time. If you do not apply these settings, all schemas that you have permissions to on the server where the database is located are retrieved. For more information about these settings, see the data provider documentation from Teradata.

10. Click OK.

11. On the Select how to define the connection page, click Next.

12. In Data source name, type a name or accept the default.

13. Click Finish.

    The new data source appears in Solution Explorer. You can now create a data source view and a model in Model Designer.

    You can now deploy the data source to a report server, and then generate a model. For more information, see How to: Publish a Report Model [Model Designer] and How to: Create a Report Model with Primary Keys from a Teradata Database.

See Also

Tasks

How to: Create a Report Model Using Model Designer

Concepts

Working with Models
Report Modeling How-to Topics
Creating and Using Teradata-Based Report Models

Help and Information

Getting SQL Server 2005 Assistance