cancel
Showing results for 
Search instead for 
Did you mean: 

Doest SoapUI support TeraData drivers?

Highlighted
New Contributor

Doest SoapUI support TeraData drivers?

Is it possible to connect to Teradata database?

6 REPLIES 6
Highlighted
Moderator

Re: Doest SoapUI support TeraData drivers?

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



Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
Highlighted
Community Hero

Re: Doest SoapUI support TeraData drivers?

@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.


Regards,
Rao.
Highlighted
New Contributor

Re: Doest SoapUI support TeraData drivers?

@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

Highlighted
Community Hero

Re: Doest SoapUI support TeraData drivers?

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.


Regards,
Rao.
Highlighted
Moderator

Re: Doest SoapUI support TeraData drivers?

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.  

 

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.

 

 

Regards,

Marcus

SmartBear Support



Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
Highlighted
Community Hero

Re: Doest SoapUI support TeraData drivers?

What I noticed while connecting to other databases is that, it can connect to database if the libraries copied into SOAPUI_HOME\bin\ext directory. But have to register using

com.eviware.soapui.support.GroovyUtils.registerJdbcDriver('driver class').


Regards,
Rao.
New Here?
Join us and watch the welcome video:
Announcements
Script Wanted
Let's start July with new challenges!

Create a script to change request body before sending it to the server for the TechCorner tag!


Scripts created in June:
- A script to generate a request body based on data from Datasource
- A script to go through all response nodes and check the value of the required field
- A Dispatching script to get responses based on the values in Request Body
- A script to add a new tag and assign it to all TestCases in a TestSuite
Top Kudoed Authors