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 <[email protected]> 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.
