Is it possible to connect to Teradata from Excel without installing Teradata drivers?

Connectivity

Is it possible to connect to Teradata from Excel without installing Teradata drivers?

I'm trying to build an Excel self-service tool front end for a Teradata database, but the end users will not have any Teradata drivers installed on their machines.  Is it possible to use a generic ODBC connection, and if so, does someone know what connect string to use for an ADODB recordset?

Thanks

Tags (3)
10 REPLIES
Senior Apprentice

Re: Is it possible to connect to Teradata from Excel without installing Teradata drivers?

If there's no Teradata ODBC driver there's no connection. 

Teradata Employee

Re: Is it possible to connect to Teradata from Excel without installing Teradata drivers?

It depends on the definition of "without installing Teradata Drivers."

You can build an office application or an office add-in with the .NET Data Provider for Teradata. You can add the .NET Data Provider assemblies (two DLLs) to your application binaries and deploy your application without "installing" the Teradata Drivers.

Re: Is it possible to connect to Teradata from Excel without installing Teradata drivers?

That sounds like something someone should have already written - a simple, basic Excel add-in that would provide the capability of connecting to Teradata (or Oracle, or other databases).  I'm sure lots of organizations want to be able to deploy spreadsheets that pull data from that kind of organization but don't install those drivers on everyone's machines...

Teradata Employee

Re: Is it possible to connect to Teradata from Excel without installing Teradata drivers?

Software to access a database is neither "simple" or "basic".

Enthusiast

Re: Is it possible to connect to Teradata from Excel without installing Teradata drivers?

No, one needs to have odbc connection to connect to TD either through sql assist or excel (as diether mentioned). I have developed one tool using excel and automated a report in excel that connect to TD and i am using it. I am sure if you have users conneting to TD now, they would have some tool to do so..

--Samir

Enthusiast

Re: Is it possible to connect to Teradata from Excel without installing Teradata drivers?

what tool is it ? can we use it

Re: Is it possible to connect to Teradata from Excel without installing Teradata drivers?

Hi Sleipner,

Were you able to arrive at solution for this problem?

I am also looking for similar solution.. your guidance is highly appreciative.

Thanks

Srinivas

Teradata Employee

Re: Is it possible to connect to Teradata from Excel without installing Teradata drivers?

Are you writing an Excel Add-in with C# or VB.NET? if yes, then you can use the .NET Data Provider for Teradata for connectivity to the Teradata Database; and privately deploy the two Assemblies (Teradata.Client.Provider.dll and Teradata.Net.Security.Tdgss.dll) with you Add-in as though they are part of your add-in. You do not need to install the .NET Data Provider package on every desktop.

Teradata Employee

Re: Is it possible to connect to Teradata from Excel without installing Teradata drivers?

Have you looked at Teradata REST Services (http://www.teradatamagazine.com/v15n01/Tech2Tech/Driverless-Connectivity/)? This solution will still requires Teradata REST services to be configured and running, but no per-user installation of Teradata drivers are required. I haven't used REST API and EXCEL combination myself so can't promise success, but if you search on internet, there are references to people using Excel and REST API in general to retrieve data.