Forum Discussion

agubba's avatar
agubba
New Contributor
6 years ago

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?

  • richie's avatar
    richie
    6 years ago

    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

  • richie's avatar
    richie
    Community Hero
    6 years ago

    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