Hey hi All, We are also trying to connect to Teradata using JDBC drivers from SAP Identity Management. We are running IDM on windows 2003 64 bit. I have installed all the components like GSS 13.10, cliv2 and also ODBC connections.
Then i created this URL:jdbc:teradata://terdev/user=PRODIDM/password=XXXXXXXXX
the error we get is:
So after searching some forums we got to know that we have turn of single sign on in teradata which the Teradata team has also already done.
We have already update the classpath with drivers and also the past to JDBC drivers.
Nothing is working. Can some one please let us know if you have any solution.
USER and PASSWORD URL connection parameters were not supported when this was posted back in 2011.
USER and PASSWORD URL connection parameters are a new feature, available beginning with Teradata JDBC Driver version 14.00.00.13.
Having said that, there is also a syntax error in the Teradata JDBC Driver connection URL: commas must be used to separate connection parameters, not forward slashes.
So the example connection URL should be: