Unable to find telapi.dll

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.

Doc2.docx

Database Connection

Accepted answers

danielbrun2

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

MPullela

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

All comments

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-package

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

ararigleno

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

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335