Unable to find telapi.dll

[MPullela]

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.

[danielbrun2]

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-pack...

Please let me know whether this helps.

All the best,

Daniel

[RodL]

@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

[MPullela]

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 !!!! :)

[danielbrun2]

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

[MPullela]

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

[danielbrun2]

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

[MPullela]

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

[danielbrun2]

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

[MPullela]

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.