nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dima Fadeyev <linuxrem...@gmail.com>
Subject export from Teradata
Date Thu, 14 Jul 2016 13:26:47 GMT
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.

Mime
View raw message