Error Connecting Knime to terada

Hello community
I have this error trying to connect to Teradata, can anyone help me to solve this, please?

I already installed the path

Added the driver preferences

and set the connection

Once the node is executed brings me this error:

ERROR DB Connector 3:1 Execute failed: [Teradata JDBC Driver] [TeraJDBC] [Error 1000] [SQLState 08S01] Login failure for Connection to teradata Sun Oct 01 11:29:38 COT 2023 socket orig=teradata cid=1dd9ce05 sess=0 Host desconocido (teradata) at java.base/ Method) at java.base/$PlatformNameService.lookupAllHostAddr(Unknown Source) at java.base/ Source) at java.base/$NameServiceAddresses.get(Unknown Source) at java.base/ Source) at java.base/ Source) at java.base/ Source) at$Lookup.doLookup( at$Lookup.getAddresses( at at at at com.teradata.jdbc.jdbc.GenericTeradataConnection.( at com.teradata.jdbc.jdbc_4.TDSession.( at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection( at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection( at com.teradata.jdbc.TeraDriver.doConnect( at com.teradata.jdbc.TeraDriver.connect( at org.knime.database.connection.UrlDBConnectionController$ControlledDriver.connect( at org.knime.database.connection.UrlDBConnectionController.connect( at org.knime.database.connection.UserDBConnectionController.connect( at org.knime.database.connection.UrlDBConnectionController.createConnection( at org.knime.database.connection.AbstractConnectionProvider.createConnection( at org.knime.database.connection.impl.DBConnectionManager.lambda$4( at java.base/ Source) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$ Source) at java.base/ Source)

Kind regards


Hi @Fercho73 -

Are you sure that the Database URL you’ve provided is correct? Oftentimes what’s provided is an IP address, but yours looks more like a generic connection string.

Thanks scott, What could be an example of the database url?

Scott, there’s any chance to have direct contact with you or someone else?

Hi Scott,

I think the problem could be that I’m not really sure what kind of connection should I use according to the Examples of Teradata JDBC Driver Connection URL provided by Teradata on its own webpage.

According to your suggestion, I put the IP into the option I show you, but a new error appears.

Execute failed: Selected JDBC driver does not support given JDBC url.

thanks a lot I already connected to teradata.

Glad you were able to figure it out. What turned out to be the problem?

Hi scott it was the database URL. I should used the Teradata JDBC Driver Connection URL for Two or more connection parameters.
jdbc:teradata://DatabaseServerName /ParameterName =Value ,ParameterName =Value

My parameters are, DATABASE, USER and, PASSWORD.

Also, I changed the database dialect to Microsoft SQL server and initially, it executed a simple query.

Now I’m trying a more complex query that I’ve already used in other apps but this time I have this error message.

[Teradata Database] [TeraJDBC] [Error 3707] [SQLState 42000] Syntax error, expected something like a ‘SUCCEEDS’ keyword or a ‘MEETS’ keyword or a ‘PRECEDES’ keyword or a ‘BETWEEN’ keyword or an ‘IN’ keyword between the word ‘ACUERDO_COMPENSACI’ and ‘?’.

I´ve changed the dialect to mySQL, but it happens again. I think its a matter of tilde o accent marks
It seems like it can’t read words like compensación.

which dialect should I use to fix this?

Kind regards


Hi Scott,

this is a simple query to show you what happened


I’ve found that the node, once fletched the columns on the table I´m working on, has changed the character ó for an @, “Compensaci@n” instead “compensación”.

once run the node give me the message

“[Teradata Database] [TeraJDBC] [Error 5628] [SQLState HY000] Column ACUERDO_COMPENSACI?N not found in PROD_DWH_CONSULTA.PI_DERIVADOS_415.”

the thing is that running this with the Teradata SQL assistant, works perfectly.


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