cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to connect to Teradata database from Ready API

SOLVED
Highlighted
New Contributor

Unable to connect to Teradata database from Ready API

I am trying to connect to teradata database from ready api(soap ui pro). I have placed the required tdgssconfig,terajdbc4 jar files in smartbear\readyapi-2.1.0\bin\ext folder.

Here are the Driver and connection strings used in JDBC Request step : 

Driver : com.teradata.jdbc.TeraDriver

Connection String: jdbc:teradata://servername/user=username,password=password

I have not used any port number here. Below is the error message received, java.sql.SQLException:Incorrect URL:jdbc:teradata://server=servername/user=username,password=password

This is from the jdbc request wizard in Ready API.

Can someone please help in solving this issue?

Do we need any service account to connect to Teradata database? or Do we need database name and port?

Or Are the jar files being used are incorrect?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Hero

Re: Unable to connect to Teradata database from Ready API

Hi @agubba 

 

the connection string details shouldn't be determined by SoapUI/ReadyAPI! - the connection string details (the parameters included within the connection string) are based on your Teradata instance.

 

The warning you are getting appears to indicate the connection string is incorrect relative to your instance.

 

You need to double check the connection string details required for your instance.

 

When I setup a new database connection I always try and create a connection within a db interrogation tool (like DBVisualiser) that uses the JDBC connection string.  If I can connect via the DB interrogation tool, then I know any issues are definitively related to ReadyAPI!/SoapUI

 

I found the folllowing example on stackoverflow for Teradata

 

jdbc:teradata://xxx.xxxxxx.com/database=xxxxxx,USER=Rocket512,PASSWORD=aui8mn5,tmode=ANSI,charset=UTF8

this isn't necessarily correct relative to your instance

 

I found the following link that appears to list all the possible parameters that you may need in your connection string.  I'd go from here - but the easiest way to resolve this is to ask a DBA/Data Architect who should know the parms you need to add into your string.

 

cheers,

 

richie

if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the title of the post to something more descriptive? This will help people when searching for problems.
2 REPLIES 2
Community Hero

Re: Unable to connect to Teradata database from Ready API

Hi @agubba 

 

the connection string details shouldn't be determined by SoapUI/ReadyAPI! - the connection string details (the parameters included within the connection string) are based on your Teradata instance.

 

The warning you are getting appears to indicate the connection string is incorrect relative to your instance.

 

You need to double check the connection string details required for your instance.

 

When I setup a new database connection I always try and create a connection within a db interrogation tool (like DBVisualiser) that uses the JDBC connection string.  If I can connect via the DB interrogation tool, then I know any issues are definitively related to ReadyAPI!/SoapUI

 

I found the folllowing example on stackoverflow for Teradata

 

jdbc:teradata://xxx.xxxxxx.com/database=xxxxxx,USER=Rocket512,PASSWORD=aui8mn5,tmode=ANSI,charset=UTF8

this isn't necessarily correct relative to your instance

 

I found the following link that appears to list all the possible parameters that you may need in your connection string.  I'd go from here - but the easiest way to resolve this is to ask a DBA/Data Architect who should know the parms you need to add into your string.

 

cheers,

 

richie

if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the title of the post to something more descriptive? This will help people when searching for problems.
Community Manager

Re: Unable to connect to Teradata database from Ready API

Thanks for your help, richie.

 

@agubba, is this what you were looking for?

---------
Tanya Gorbunova
SmartBear Community Manager

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others.↓↓↓↓↓
New Here?
Join us and watch the welcome video:
Top Kudoed Authors