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.
Before you can create a data source file in Model Designer, the system administrator must have installed and configured the .NET Framework Data Provider for Teradata, version 12.00.00.01, on your report authoring client and on the report server. Teradata database versions 12.00 and 6.20 are supported. For more information, see Configuring Reporting Services for Teradata-based Report Models.
After you create the data source file, you can create a data source view and a model.
By default, when you create a data source view from a data source file by using Model Designer, the data source view does not contain primary keys for tables and views. Primary keys are required to create a model. After you create the data source view, you can set primary keys manually on each table or view. For more information, see Working with Data Source Views How-to Topics (SSAS). To generate the primary keys automatically, you must publish the data source file from Model Designer to a report server, and then generate the model file by using Report Manager. The model file (.smdl) includes both the data source view and the model. For more information, see How to: Create a Report Model with Primary Keys from a Teradata Database.
To create a data source file for a Teradata database in a report model project
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.
In Solution Explorer, right-click Data Sources, and then click Add New Data Source. The Data Source Wizard dialog box opens.
Click Next. The Select how to define the connection page opens.
Click New. The Connection Manager dialog box opens.
In Provider, from the drop-down list, select the .NET Framework Data Provider for Teradata.
In Server name, type the IP address for the server.
If you do not know the information requested, contact the system administrator.
In Login Details, for User name and Password, type the name and password of an account that has access to the specified server.
The credentials to use are specified by the system administrator or database owner. For more information about credentials, see Specifying Credential and Connection Information.
Click All. The connection properties appear in a grid.
In Data Dictionary, enter the following three values:
- For Database, type the name of the database.
- Set Restrict to Default Database to True.
- Set Use X Views to False.
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.
On the Select how to define the connection page, click Next.
In Data source name, type a name or accept the default.
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.