How to fetch data from Teradata database?
I have to connect to a Teradata database and fetch data in UiPath. I know Teradata uses a SQL dialect, but have the following questions:
1. Can we use the existing App Integration > Database activities (part of SQL Activities Pack) to work with Teradata? Do we need to install additional Drivers?
2. If not, is there a separate Package in UiPath for working with Teradata?
Help!!
Thanks
Log in with external accounts
comment Comments
#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.
#1513 Re: How to fetch data from Teradata database?
First, configure the connection to Teradata
If you have not already, first specify connection properties in an ODBC DSN (data source name). This is the last step of the driver installation. You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs.
User: Set this to the username of a Teradata user.
Password: Set this to the password of the Teradata user.
DataSource: Specify the Teradata server name, DBC Name, or TDPID.
Port: Specify the port the server is running on.
Database: Specify the database name. If not specified, the default database is used.
Now connect UiPath Studio
Create Execute Query
With the connection configured, we are ready to query Teradata data in our RPA.
From the Activities navigation, select Execute Query and drop it on the Flowchart.
Double-click the Execute Query activity and set the properties as follows:
ExistingDbConnection : Your Connection variable
SQL : SELECT statement like SELECT ProductId, ProductName FROM NorthwindProducts WHERE CategoryId = 5
DataTable: Create and use a variable with the Type System.Data.DataTable.