DB Connector to teradata not working

hello, I’m creating a DB conector to a teradata database, when I try acces, knime shows this error

ERROR Database Connector (legacy) 3:1 Execute failed: Could not create connection to database: Driver “com.teradata.jdbc.TeraDriver” does not accept URL: jdbc:Teradata://XX.XX.XXX.X:XXXX/XXX_XXX_XXXX

in theory the url is right.

have any one a posible solution.

Kind regards

Edgar

Hello @Fercho73,

and welcome to KNIME Community!

I suggest to use new(er) database connector node and not legacy. Also check this topic regarding Teradata connection string:

Additionally you can always check documentation:
https://docs.knime.com/latest/db_extension_guide/index.html#connector_generic

Hope this helps!

Br,
Ivan

1 Like

Add the current Teradata JDBC driver to your Preferences/KNIME/Databases config (NOT legacy) as database type “default”.

Then, use the DB/Connection/DB Connector node (NOT Database(legacy)). Database Type “Default”, Dialect SQL-92, and pick your Teradata driver ID.

URL - jdbc:teradata://

JDBC parameters - set parameter name DATABASE equal to your desired root database context. Set any additional driver parameters required (ENCRYPTDATA, TMODE, etc.)

Under the Advanced tab, set Append JDBC parameter to URL, JDBC URL initial parameter separator to “/”, and JDBC URL parameter separator to “,”. Enable all dialect capabilities.

hello every one, sorry it´s been impossible to connet to teradata.
This is the error thios time.

ERROR DB Connector 3:49 Execute failed: [Teradata JDBC Driver] [TeraJDBC 17.20.00.15] [Error 1000] [SQLState 08S01] Login failure for Connection to prod_dwh_consulta Sat Jan 21 14:27:29 COT 2023 socket orig=prod_dwh_consulta cid=622874b3 sess=0 java.net.UnknownHostException: Host desconocido (prod_dwh_consulta) at java.base/java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method) at java.base/java.net.InetAddress$PlatformNameService.lookupAllHostAddr(Unknown Source) at java.base/java.net.InetAddress.getAddressesFromNameService(Unknown Source) at java.base/java.net.InetAddress$NameServiceAddresses.get(Unknown Source) at java.base/java.net.InetAddress.getAllByName0(Unknown Source) at java.base/java.net.InetAddress.getAllByName(Unknown Source) at java.base/java.net.InetAddress.getAllByName(Unknown Source) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.doLookup(TDNetworkIOIF.java:240) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.getAddresses(TDNetworkIOIF.java:278) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:459) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:186) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createIO(TDNetworkIOIF.java:177) at com.teradata.jdbc.jdbc.GenericTeradataConnection.(GenericTeradataConnection.java:319) at com.teradata.jdbc.jdbc_4.TDSession.(TDSession.java:188) at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.(JDK6_SQL_Connection.java:36) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:181) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:171) at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:229) at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:164) at org.knime.database.connection.UrlDBConnectionController$ControlledDriver.connect(UrlDBConnectionController.java:103) at org.knime.database.connection.UrlDBConnectionController.connect(UrlDBConnectionController.java:368) at org.knime.database.connection.UserDBConnectionController.connect(UserDBConnectionController.java:294) at org.knime.database.connection.UrlDBConnectionController.createConnection(UrlDBConnectionController.java:348) at org.knime.database.connection.AbstractConnectionProvider.createConnection(AbstractConnectionProvider.java:103) at org.knime.database.connection.impl.DBConnectionManager.lambda$2(DBConnectionManager.java:501) at java.base/java.util.concurrent.FutureTask.run(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source)

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.