Doest SoapUI support TeraData drivers?
Is it possible to connect to Teradata database?
Forum Discussion
Hi,
It looks like there is a Teradata JDBC driver available to use so you can try using that to connect to Teradata with Ready API with the JDBC datasource or JDBC request test step.
https://downloads.teradata.com/download/connectivity/jdbc-driver
Regards,
Marcus
SmartBear Support
nmrao, MarcusJ, Hello, I did it, but still get the following error:
- Error getting response; com.eviware.soapui.support.SoapUIException: Failed to init connection for driver [com.teradata.jdbc.TeraDriver], connectionString [jdbc:teradata://host/USER=yyyyy,PASSWORD=xxxxx]
The connection string is tested with java and works with the same jdbc, that is placed in SoapUI/bin/ext
Edit: Trying to make this work, in Groovy Script I run following code:
import groovy.sql.Sql;
com.eviware.soapui.support.GroovyUtils.registerJdbcDriver( "com.teradata.jdbc.TeraDriver" )
def con = Sql.newInstance("jdbc:teradata://dbhost", "usr", "pass", "com.teradata.jdbc.TeraDriver");And it says
- java.lang.ClassNotFoundException: com.teradata.jdbc.TeraDriver
But the path in Teradata jar in SoapUI/bin/ext is correct: exactly com.teradata.jdbc.TeraDriver
- Please see if the below link helps.
https://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html
According to the above link, it requires two jar files:
terajdbc4.jar
tdgssconfig.jar
And see which connection string works:
JDBC Type 3: jdbc:teradata://gwhost:port/DatabaseServerName
JDBC Type 4: jdbc:teradata://DatabaseServerName
Another one:
Sql.newInstance("try type 3 or type 4 ", "usr", "pass") -- note no 4th parameter.
- alex1,
Please go thru MarcusJ answer.
Just wanted to clarify that as long as the data base support java client libraries, SoapUI or ReadyAPI can connect provided you follow the instructions from the documentation.
In this case:
Copy the downloaded the driver under READYAPI_HOME/bin/ext and restart the tool. You should be ready to connect.
