topic Re: Unable to find telapi.dll in Alteryx Designer Desktop Discussions

Unable to find telapi.dll

MPullela — Thu, 24 May 2018 01:28:29 GMT

Issue With Alteryx.

I have been trying to Move data from an Excel File into Teradata Table using the Teradata Bulk Load Connector. I saw the following issue “Unable to find telapi.dll” – I am guessing this is related to configuration - can some one please guide me as to how to solve this issue?

I am using Alteryx Designer 64 bit.

Re: Unable to find telapi.dll

danielbrun2 — Thu, 29 Oct 2015 18:38:25 GMT

Hi,

I am 95% sure this is a driver issue. There are two (or maybe more) Teradata install sets and I guess you did not get the right one - like me the first time.

In short the BULK actions need "Teradata Parallel Transporter" TPT to perform its actions. This is also the installation that gives you the telapi.dll file. If you do not have this folder or something with a similar path, I would guess that installing TPT will solve the issue.

Here is a link for the full Teradata toolkit:

https://downloads.teradata.com/download/tools/teradata-tools-and-utilities-windows-installation-package

Please let me know whether this helps.

All the best,

Daniel

Re: Unable to find telapi.dll

RodL — Thu, 29 Oct 2015 20:23:06 GMT

@danielbrun2 is correct. For the Teradata Bulk Loader to work, it requires you to have certain Teradata APIs installed.

Please see the Help article on this for the complete list...Teradata Bulk Loader

Re: Unable to find telapi.dll

MPullela — Thu, 29 Oct 2015 21:10:55 GMT

Thank you RodL and @danieldrun ... I have a similar instance on my colleague's machine which worked, but not working on my machine.

My oraganization has the same Teradata Setup across the company and we both have the same setup .. Not sure what is the difference, I tried re-installing the TD but with no luck !!!! :)

Re: Unable to find telapi.dll

danielbrun2 — Thu, 29 Oct 2015 21:36:56 GMT

You are very welcome. It is not a server side issue but client based.

If you would like it, I can do a Skype session with you tomorrow. I am sure
we can fix it!

Best,
Daniel

--
Daniel Brun
+45 21 25 61 20 <++45+21+25+61+20>

a.Flæsketorvet 68, 1711 København Ve.daniel@inviso.dkt.@DanielPBrun
l.linkedin.com/in/danielbrunw.inviso.dk
Prøv Tableaueller Alteryxgratis i dag

Re: Unable to find telapi.dll

MPullela — Thu, 29 Oct 2015 23:37:53 GMT

danielbrun - Thank you for extending the help - but this is a Company machine and I cannot install Skype or any other communication software..

Re: Unable to find telapi.dll

danielbrun2 — Fri, 30 Oct 2015 08:23:11 GMT

Okay - that maked it a little more difficult. Could you check whether you
have this folder: C:\Program Files\Teradata\Client\15.00\Teradata Parallel
Transporter?

And does your colleague have it?

--
Daniel Brun
+45 21 25 61 20 <++45+21+25+61+20>

a.Flæsketorvet 68, 1711 København Ve.daniel@inviso.dkt.@DanielPBrun
l.linkedin.com/in/danielbrunw.inviso.dk
Prøv Tableaueller Alteryxgratis i dag

Re: Unable to find telapi.dll

MPullela — Fri, 30 Oct 2015 13:32:06 GMT

Daniel - I do have the folder and found the file Telapi.dll in the bin64 folder.. and my colleague has the folder too.

Re: Unable to find telapi.dll

danielbrun2 — Fri, 30 Oct 2015 13:39:49 GMT

Okay - could you send me a screenshot of the ODBC configuration. Seems like everything is installed correctly, but something might differ.

Re: Unable to find telapi.dll

MPullela — Fri, 30 Oct 2015 14:07:55 GMT

I had to replace the Database name with XXXXXXXX (Company Policy).

I noticed one more thing, I deliberately set the process to fail, like gave the name of an existing table in the output configuration - to check if Teradata connection works and Alteryx reported a failure message saying the table exists - it does prove that I am able to connect to TD but just cannot use Bulk load.

Re: Unable to find telapi.dll

danielbrun2 — Fri, 30 Oct 2015 14:21:49 GMT

Could you try to recreate the ODBC souce in the system DNS and make sure that the platform column say "64-bit"? It could be some confusion between 64-bit and 32-bit drivers.

Daniel

Re: Unable to find telapi.dll

MPullela — Fri, 30 Oct 2015 15:15:02 GMT

Daniel,

Thank you for all your help !!! I figured out the solution for my problem - ofcourse with your help. The ODBC Connection manager I was using was a 64 bit and looks like Teradata (Version 15.0) does not like the 64 bit Bulk Loader process... I located the 32 bit Conection manager (located in C:\Windows\SysWOW64 - I am using Windows 7 OS), created the System DSN and behold it worked!!!!!! ...

Once again thank you for all the help

Re: Unable to find telapi.dll

Ken_Black — Mon, 23 Nov 2015 20:21:29 GMT

Hi,

I followed this conversation to the end and have ended up with a problem that may be similar to the problem you had (see attached graphic). However, I cannot determine what you did to resolve your issue, although I know it had to do with 32- vs 64-bit telapi.dll. Can you be more specific as to the steps you took to switch to the 32-bit version of the telapi.dll driver?

Thanks,

Ken

Re: Unable to find telapi.dll

LindaT — Mon, 23 Nov 2015 21:24:20 GMT

When installing Teradata 15.00 using TTU_Base.exe, if you selected the ODBC Driver Teradata as well as the Teradata Parallel Transporter Base, it should have updated your Path to include the directories containing the Teradata dll's required for the Bulk Loader.

For Example this was added to the front of my Path after installing. This is what enables Alteryx to find the telapi.dll:

C:\Program Files\Teradata\client\15.00\Teradata Parallel Transporter\bin64;C:\Program Files\Teradata\client\15.00\Teradata Parallel Transporter\msg64;C:\Program Files (x86)\Teradata\client\15.00\Teradata Parallel Transporter\bin;C:\Program Files (x86)\Teradata\client\15.00\Teradata Parallel Transporter\msg;C:\Program Files\Teradata\Client\15.00\ODBC Driver for Teradata nt-x8664\Lib\;C:\Program Files (x86)\Teradata\Client\15.00\ODBC Driver for Teradata\Lib\;C:\Program Files\Teradata\Client\15.00\bin\;C:\Program Files (x86)\Teradata\Client\15.00\bin\;

Re: Unable to find telapi.dll

ararigleno — Wed, 17 Feb 2016 18:17:02 GMT

Dear,

I am a teacher at the University of Brasilia - Brazil.

Urgently need to use plugin Teradata TPT Bulk Loader.

Could you forward an example how to use it in Pentaho Data Integrations (ktr)?

thanks.

Ararigleno Fernandes

Re: Unable to find telapi.dll

sunanda — Mon, 30 Oct 2017 14:45:13 GMT

Ohh wow!! You saved my day. Thank you.

Re: Unable to find telapi.dll

rashmi_joshi — Wed, 22 Nov 2017 00:03:13 GMT

Hi Daniel,

Would you be able to elaborate in greater detail how to troubleshoot this issue?

I am using TD 15.10 and Alteryx 11.3 on a 64 bit windows laptop and keep getting the error: "Error: Input Data (1): Unable to find the dll: "telapi.dll"."

Re: Unable to find telapi.dll

Mgohil — Wed, 06 Dec 2017 14:53:43 GMT

I'm having the same issue on 11.7 Alteryx

Re: Unable to find telapi.dll

Fruitlord — Fri, 16 Mar 2018 20:12:59 GMT

Could you please let us know the specific steps you took to resolve it?

Re: Unable to find telapi.dll

Mgohil — Fri, 21 Sep 2018 13:58:29 GMT

Here's the solution that we used:

1) Redownloaded the td-ttu-15.10.05_for_Windows.

2) Then we re-installed the Parallel Transport.

Once this occurred, the issue was solved.