How to Uninstall Teradata and Install Again

Past:   |   Updated: 2014-x-17   |   Comments (6)   |   Related: More > Integration Services Development

Free MSSQLTips Webinar: Solving Issues Caused past Bad Address Data Quality

Address data is a critical piece of data captured by organizations beyond the globe. Incomplete or incorrect addresses outcome in unnecessary and burdensome costs to a business when shipments are sent to the wrong location or returned to sender, and driver�southward waste time and fuel going to locations that don�t exist. For companies using Microsoft Dynamics 365 (CRM) or Ability Apps to shop addresses (accounts, customers, contacts, etc), there is no way to make certain addresses are authentic. In add-on to that, capturing each data field is a manual process that is time consuming and fault prone.

Problem

The company where I work migrated their information warehousing environment to Teradata. The requirement is to download and install the Teradata Client utilities to access the newly built information warehouse and to extract information from Teradata to SQL Server using SQL Server Integration Services.

Solution

Teradata is one of top notch data warehouse DBMS products available in the market today and it's built by consolidating data from different sources like whatsoever other data warehouse. The data stored tin be used to drive analytics like tracking sales of an organization and measuring functioning of a product or customer experience.

To access information stored in Teradata we demand to install the Teradata Tools and Utilities (their client side production) and the .Cyberspace Data Provider for Teradata (an extension built on Microsoft's ADO.Cyberspace platform).  This enables the states to connect to a Teradata database and to load or retrieve data using SSIS in BIDS/Visual Studio.

Installation of Teradata Client Side Tools

Go to the Teradata Tools and Utilities page and download the TTU 15.0 Installer File.

This is a zero file which y'all will demand to extract. Run the TTU_Base.exe file from the extracted folder.

The Installation Magician will popular-up.  Select the linguistic communication as English and click Next.

Past default Teradata volition desire to install in your C:\Programme Files\Teradata\Client\15.0 folder. If you want to change the location, change information technology at this step.

Select the features yous want to install. I would suggest selecting all features to avert whatsoever later installation process and then click Install.

The installation process begins.

It will give a confirmation when the installation is consummate.

You can run across the list of Teradata products installed in your automobile from the Windows > All Programs menu every bit shown below. These will match the features selected in the installation process.

Open the SQL Assistant which is similar to Microsoft's SSMS from Windows > All Programs > Teradata SQL Assistant or from C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Teradata Client 15.00\Teradata SQL Assistant. This is Teradata's equivalent of Microsoft SQL Server Management Studio.

Change the Data Provider to Teradata.Net and click the Connect push institute in the top left corner (as shown below) of the screen to plant a connection.

Enter the credentials provided by your Teradata DBA in the Connection Data screen.

Cheque the Apply Integrated Security box if your Teradata username and password is same as your Windows network login and password.

If y'all are connecting by LDAP/SPNEGO/TD2, select the advisable option from the Mechanism dropdown and click OK.

Now y'all volition be able to connect to the Teradata database and can query whatsoever tables.

Connecting to Teradata from SQL Server Integration Services

Annotation we take too installed the .NET Data Provider for Teradata as role of our client side tools which we will utilize to connect to Teradata from Visual Studio/BIDS.

At present open an Integration Services Project in Visual Studio. I have used Visual Studio 2013 for this demo. Right click the Connection Manager and click New ADO.Cyberspace Connexion and open a new connexion.

In the Configure ADO.NET Connection Director Window, enter the Teradata server credentials used to connect to Teradata through SQLAssistant. Examination the connexion and click OK.

Drag a information flow task to the Designer and add together an ADO.NET Source and OLEDB/SQL Server Destination chore. Connect the ADO.NET Source to the new Teradata Connection Director created and the Destination to the SQL Server Connection Manager and select the appropriate source and destination tables.

Run the Information Catamenia Task, the source table from Teradata will be extracted to SQL Server destination.

We are done with our solution to excerpt a Teradata table to our SQL Server database.

Query Timeout Result in SSIS

Yous may run into a Query Time out Fault for the ADO.Internet Source task when it tries to connect to the Teradata server. Right click the ADO.Net Source job and open its Backdrop. By default your command timeout will be 30 seconds. Gear up it to 100 seconds or more to eliminate a connection timeout effect.

Next Steps

• The aforementioned process could be washed using the ODBC Connection for which y'all will add together an ODBC source with Teradata credentials.  The necessary ODBC driver needed to connect with Teradata has already been installed during the above installation process. Try it out and allow us know which performs faster. I bet the .NET data provider using Teradata will be faster than ODBC every bit information technology'south specially designed to piece of work with Teradata.

Related Manufactures

Popular Articles

About the writer

Junaith Haja is a Senior Business Intelligence Consultant with Browse Info Solutions, Inc and leads a Microsoft SQL Server and BI squad.

View all my tips

Article Final Updated: 2014-ten-17

gonzaleshatuars.blogspot.com

Source: https://www.mssqltips.com/sqlservertip/3363/installing-teradata-client-tools-to-use-with-sql-server-integration-services/

Share this post