Hi Dima, You will have to create an über jar from the JDBC drivers provided by Teradata and copy the uberjar into the lib folder of nifi.
As Matt pointed out the instructions are in the email thread. You can refer them. Anuj > On Jul 14, 2016, at 9:35 AM, Matt Burgess <mattyb...@gmail.com> wrote: > > Dima, > > There was a discussion on how to get the SQL processors working with > Teradata a little while ago: > > http://mail-archives.apache.org/mod_mbox/nifi-users/201605.mbox/%3CCAEXY4srXZkb2pMGiOFGs%3DrSc_mHCFx%2BvjW32RjPhz_K1pMr%2B%2Bg%40mail.gmail.com%3E > > Looks like it involves making a fat JAR to include the Teradata driver > and all its dependencies, since the DBCPControllerService asks for a > single JAR containing the driver class > > Regards, > Matt > >> On Thu, Jul 14, 2016 at 9:26 AM, Dima Fadeyev <linuxrem...@gmail.com> wrote: >> Hello, everyone, >> >> I'm new to nifi and this mailing list, I'm evaluating if we could extract >> data (tables) from Teradata to local fs or HDFS with nifi. Is that possible? >> >> What I've done so far was creating an "Execute SQL" processor with the query >> and the a database connection pooling service with the following >> configuration: >> >> connection url: jdbc:teradata://teradata.host/database=mydb >> class name: com.teradata.jdbc.TeraDriver >> jar url: file:///root/nifi-0.7.0/lib/terajdbc4.jar >> ... >> >> I'm seeing this error in the log file: >> >> org.apache.nifi.processor.exception.ProcessException: >> org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of >> class 'com.teradata.jdbc.TeraDriver' for connect URL ' >> jdbc:teradata://teradata.host/database=mydb' >> at >> org.apache.nifi.dbcp.DBCPConnectionPool.getConnection(DBCPConnectionPool.java:225) >> ~[na:na] >> ... >> Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC >> driver of class 'com.teradata.jdbc.TeraDriver' for connect URL ' >> jdbc:teradata://teradata.host/database=mydb' >> ... >> Caused by: java.sql.SQLException: No suitable driver >> >> It looks like nifi can't find or load the driver, even though the jar is >> located in /root/nifi-0.7.0/lib/terajdbc4.jar >> >> Please, help me resolve this. >> Thanks in advance.
