Doest SoapUI support TeraData drivers?

Question

Is it possible to connect to Teradata database?

marcusj · Answer

Hi,
&nbsp;
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.
&nbsp;
https://downloads.teradata.com/download/connectivity/jdbc-driver
&nbsp;
&nbsp;
Regards,
Marcus
SmartBear Support

nmrao · Answer

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.

alex1 · Answer

nmrao,&nbsp;MarcusJ,&nbsp;Hello, I did it, but still get the following error:&nbsp;- 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]&nbsp;The connection string is tested with java and works with the same jdbc, that is placed in SoapUI/bin/ext&nbsp;&nbsp;&nbsp;Edit: Trying to make this work, in Groovy Script I run&nbsp;following code:&nbsp;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");&nbsp;And it says&nbsp;java.lang.ClassNotFoundException: com.teradata.jdbc.TeraDriver&nbsp;But the path in Teradata jar in&nbsp;SoapUI/bin/ext is correct: exactly&nbsp;com.teradata.jdbc.TeraDriver

nmrao · Answer

Please see if the below link helps.https://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.htmlAccording to the above link, it requires two jar files:    terajdbc4.jar    tdgssconfig.jarAnd 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.

marcusj · Answer

Also, to add to what nmrao said please make sure you restart SoapUI after adding the JDBC driver jar files to {SoapUI install}\bin\ext directory. &nbsp;
&nbsp;
Edit:
If you are connecting to the database using a Groovy script and not the JDBC test step then put the jar files in the {SoapUI install}\lib directory and restart SoapUI.
&nbsp;
&nbsp;
Regards,
Marcus
SmartBear Support

Forum Discussion

Doest SoapUI support TeraData drivers?

Recent Discussions

Adding custom header to auth profile token call

Update API definition : Error with the json format

Test result Pass when data source times out

Related Content

Unable to connect to Teradata database from Ready API

Fetch the row count in DDT driver

No suitable driver found for jdbc:sqlserver