arrow_back How to fetch data from Teradata database?

11 months ago link more_vert
Raymond Raymond
articleArticles 592
imageDiagrams 41
codeCode 0
chat_bubble_outlineThreads 9
commentComments 229
loyaltyKontext Points 6399
account_circleProfile
#1512 Re: How to fetch data from Teradata database?

Hello, welcome to Kontext!

I have not used UiPath thus will not be able to suggest on that.

However, based on experiences in the past on other tools, it requires a database driver to connect to a database. For example, Teradata connectivity provides different drivers for different programming languages or platforms: https://downloads.teradata.com/download/connectivity.

If you program with Java, you can use JDBC driver; if you use Python, you can use ODBC or Python native driver or even JDBC driver (via JayDeBeAPI), etc.

For ETL tools, they usually work in two ways:

Pre-install the driver for you when you configure/install those tools.

Will need system administrator to install those

For Java-based, it's usually done by including JDBC jar file directly in the distribution thus no system installation is required.

For UiPath, it looks like it is based on .NET which means they could directly include the .NET data provider into the application if they want to (https://www.nuget.org/packages/Teradata.Client.Provider/). Again, as I didn't use UiPath previously, I cannot comment further on this. 

This forum is for general programming, development related discussions.