Teradata is a relational database management system (RDBMS) designed to handle large volumes of data and provide high-performance analytics. Teradata is known for its scalability, parallel processing capabilities, and support for complex queries and data warehousing. Teradata is used to store, manage, and analyze vast amounts of data for business intelligence and decision-making purposes. Follow this link for more information on Teradata.

Follow this link to the Teradata trial website. You can create a demo account for a hands-on experience of the data source.

In this help article, you will find the following information to create a Teradata data source in Wyn Enterprise.

• Considerations

• Steps

• Salient Points

• Provider Sample Code

• Data Type Mapping in Teradata

• Limitations

Considerations

Before creating a Teradata data source, ensure the following,

1. Teradata Vantage connects via the official ADO.Net Provider.

2. The data source functionality level should include functionalities of the dataset and cache models.

Steps

Due to some restrictions of the Teradata data license provider, you need to install the driver to use the Teradata data source by following the below instructions,

1. Download the Teradata.Client.Provider NuGet package with the following version number - Teradata.Client.Provide version: 17.20.7.

2. The package file will be downloaded as a zip file. Unzip the package file - teradata.client.provider.17.20.7.nupkg.

3. Navigate to the decompressed directory /lib/net6.0.

4. Copy the Teradata.Client.Provider.dll and Teradata.Net.Security.Tdgss.dll files to the Wyn DatasetPlugin directory. The default path of the directory is: C:\Program Files\Wyn Enterprise\Plugins\DataSet.

5. Copy the Teradata.Client.Provider.dll and Teradata.Net.Security.Tdgss.dll files to the Wyn CotWorker directory. The default path of the directory is C:\Program Files\Wyn Enterprise\CotWorker.

6. Restart the Wyn Enterprise application.

To use the Teradata data source in Wyn Enterprise, follow the below instructions,

7. Navigate to Admin Portal >> System Management >> Data Providers and select the Teradata option using the checkbox.

   
   

8. Now, navigate to the Resource Portal >> + (Create) >> Create Data Source and select the Teradata option from the left navigation bar or the thumbnails.

   
   

9. On the Teradata Data Source pane, enter the connection details or click the Use Configuration String (Advanced) checkbox and click the Create button.

   
   

Salient Points

1. Teradata provider supports the following Teradata database versions: 17.20, 17.10, 17.00, 16.20, and 16.10.

2. Teradata provider can connect to databases that deploy on Cloud, VMWare,VirtualBox, and UTM.

3. ConnectionString property is used to set specific Teradata session attributes. The required format for the ConnectionString property is: Attribute=Value; Attribute=Value;...

4. An example of a typical valid Teradata connection string is: Data Source=Teradata1; User Id=myName; Password=myPassword;

Some of the commonly used parameters are listed below,

Note: Follow this link for more connection string parameters.

Data Type Mapping in Teradata

The following table lists the Teradata data source compared to the C# data types;

Limitations

1. Teradata data source is not supported in Direct Query Models and Semantic Models.

2. Since the result of the Teradata stored procedures is not a standard table structure, Terada procedures cannot be used in Wyn.