access_time 7 years ago languageEnglish
more_vert

[C#] Connect to Teradata Database via .NET Data Provider

visibility 9,761 comment 3
In this post, I will demonstrate how to connect to Teradata database via .NET Data Provider for Teradata using C#. Install the .NET Data Provider for Teradata from the following link: Teradata Tools and Utilities Windows Installation Package Name it as’' ‘ConsoleApps.Teradata’. Add ...
info Last modified by Raymond 2 years ago
thumb_up 0
comment Comments
18 days ago link more_vert
Z
Zaid
web_assetArticles 0
forumThreads 0
commentComments 2
account_circleProfile
Re: [C#] Connect to Teradata Database via .NET Data Provider

Use the Connection Information dialog box to create, edit, and delete data sources for .Net Data Provider for Teradata. The dialog box is also used to connect to existing Teradata.Net data sources.

Data source definitions are saved to a file named DataSources.config.

This file is located in \Users\<username>\AppData\Teradata\SQL Assistant

1. Open Teradata SQL Assistant.

2. Select Teradata .NET from the provider drop-down list, next to the Connect tool button.

3. Click the Connect icon or go to Tools > Connect.

4. Use the Connection Information dialog box to select a .NET data source.

  • Create a new data source by entering the name and server and other applicable information
  • Delete an existing data source by clicking Delete.
  • Use this dialog box to modify existing sources.

5. Use the Advanced tab to make additional changes to a data source.

Defining a .NET Data Provider for Oracle Data Source

1 Open Teradata SQL Assistant.

2 Select Oracle.NET from the provider drop-down list next to the Connect tool button.

3 Click the Connect icon or select Tools > Connect.

4 Use the Connection Information dialog box to select a .NET data source.

  • Create a new data source by entering the name, server, and other applicable information.
  • Delete an existing data source by clicking Delete.
  • Use this dialog box to modify existing sources.

5 Use the Advanced tab to make additional changes to a data source.

6 years ago link more_vert
account_circle Raymond
Re:[C#] Connect to Teradata Database via .NET Data Provider
@Neuwa Rakgajane There will be no much difference whether you want to query from one table or from multiple. You can refer to ADO.NET to understand all the operations you can do with Teradata .Net Data Provider. https://msdn.microsoft.com/en-us/library/e80y5yhx(v=vs.110).aspx In terms of writing complex SQL query, I was planning to create a serial about querying Teradata but have not completed yet. http://kosmisch.net/Blog/DataAndBusinessIntelligence/Archive/2015/5/3/querying-teradata-and-sql-server-tutorial-1-the-select-statement.html
format_quote

person Neuwa Rakgajane access_time 6 years ago
Re:[C#] Connect to Teradata Database via .NET Data Provider

I have been doing the your tutorial on teradata. Aren't there more tutorial where you query multiple tables at once? I wanted to get a practice on those. Please send me a link if you have such tutorial. I mean more advanced queries, your tutorial were so easy to understand, I need such other complex example urgently.
6 years ago link more_vert
account_circle Neuwa Rakgajane
Re:[C#] Connect to Teradata Database via .NET Data Provider
I have been doing the your tutorial on teradata. Aren't there more tutorial where you query multiple tables at once? I wanted to get a practice on those. Please send me a link if you have such tutorial. I mean more advanced queries, your tutorial were so easy to understand, I need such other complex example urgently.

Forum discussions for column Teradata.