Forum Discussion

joso1's avatar
joso1
New Contributor
4 years ago
Solved

ReadyAPI connectivity to Azure SQL

 Any pointers to configure Azure SQL with ReadyAPI. I am getting the following error on the below connection string:   groovy code:   def db = [url:"jdbc:sqlserver://" + serverName+ ":" + serverP...
  • richie's avatar
    richie
    4 years ago
    Hey joso1,

    I did a bit of googling and for some versions of the adal jar there were missing dependencies, so you might want to check this isnt a problem with your version of the .jar file.

    Stackoverflow link: https://stackoverflow.com/questions/52270540/not-able-to-get-azure-token-using-adal4j-api

    I know youre trying to connect using groovy, but when i try and setup new db connections using jdbc in ReadyAPI!, quite often if im having problems i'll try and setup the connection in a db interrogation tool first (removing some of the complication) like say DBVisualiser/TOAD etc. The JDBC config required in the db tools is identical to ReadyAPI! so doing it this way i at least know that the jdbc connection string parameters are correct (as they can change based on how the db is setup) which is most of the problem to be resolved. Once ive got my connection setup in the db tools i then know if i replicate the settings in ReadyAPI! and it doesnt work, the problem cant be incorrect driver .jar nor incorrect jdbc connection url and that it has gotta be something else (sticking .jar in wrong directory, etc.)

    Thats all i got im afraid...perhaps the other forum members have some better ideas?

    Ta

    Rich
richie's avatar
richie
Community Hero
Hey joso1,

I didnt even know you could connect to Azure SQL using JDBC.
When i was hitting Azure SQL i used REST to run my queries. I thought AzureSQL runs in the cloud and so i never had direct queryable access to the underlying tables. Instead we queried the entity layer (XML) that sits above the tables (using fetchXML). I think the entity layer is a security feature so people cant interact with the tables themselves.

Ta

Rich
joso1's avatar
joso1
New Contributor
4 years ago

Hey richie 

 

It was a cake walk when I did with odbc/adal libs in python. I did some reading and research and jdbc connection is doable with authentication. I cant seem to get my head around this one here though!

  • richie's avatar
    richie
    Community Hero
    4 years ago
    Hey joso1,

    I did a bit of googling and for some versions of the adal jar there were missing dependencies, so you might want to check this isnt a problem with your version of the .jar file.

    Stackoverflow link: https://stackoverflow.com/questions/52270540/not-able-to-get-azure-token-using-adal4j-api

    I know youre trying to connect using groovy, but when i try and setup new db connections using jdbc in ReadyAPI!, quite often if im having problems i'll try and setup the connection in a db interrogation tool first (removing some of the complication) like say DBVisualiser/TOAD etc. The JDBC config required in the db tools is identical to ReadyAPI! so doing it this way i at least know that the jdbc connection string parameters are correct (as they can change based on how the db is setup) which is most of the problem to be resolved. Once ive got my connection setup in the db tools i then know if i replicate the settings in ReadyAPI! and it doesnt work, the problem cant be incorrect driver .jar nor incorrect jdbc connection url and that it has gotta be something else (sticking .jar in wrong directory, etc.)

    Thats all i got im afraid...perhaps the other forum members have some better ideas?

    Ta

    Rich