Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Teradata and NIFI

Highlighted

Teradata and NIFI

New Contributor

We’re trying to do bulk loading of data in Teradata using NIFI. Is that possible in NIFI? Currently we noticed that row by row inserts to teradata is possible but that is not scaling well when it comes to loading millions of records. Teradata has their own set of utility operators: FASTLOAD, MULTILOAD, TPTLOAD, TPTUPDATE, etc that we can use to do fast bulk loading of records into Teradata. Does NIFI support any of these operators? So far I only see the option to run SQL against teradata not utility jobs

Please let me know thanks.

Regards.

-Suhail

3 REPLIES 3

Re: Teradata and NIFI

Explorer

Try to make use of ExecuteScript using python to replicate the jobs you wanted.

Re: Teradata and NIFI

Super Guru

You can do execute process to run those or execute stream command.

Does it have a Java SDK for those commands?

https://community.hortonworks.com/articles/45427/using-teradata-jdbc-connector-in-nifi.html

You can use sqoop with: https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.0/bk_teradata-connector-user-guide/content/ch...

Re: Teradata and NIFI

New Contributor

Is it possible to use sqoop or the Hortonworks teradata connector with NIFI?

-Suhail

Don't have an account?
Coming from Hortonworks? Activate your account here