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