access_time 7y languageEnglish
more_vert

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

visibility 9,918 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 3y
thumb_up 0
comment Comments
3m link more_vert
Z
Zaid
web_assetArticles 0
forumThreads 0
commentComments 2
account_circleProfile
#1510 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.

6y link more_vert
account_circle Raymond
#175 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 6y
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.
6y link more_vert
account_circle Neuwa Rakgajane
#59 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.