We are building a new experience for our SmartBear Community.
This site is now read-only. You can still browse and search as usual. Learn More

Forum Discussion

HEATConsultant's avatar
HEATConsultant
Occasional Contributor
8 years ago
Solved

Data Import from SQL Database

SOAP Newbie here.   Successfully created my first SOAP Project and request to create a record.   Now how can I do a mass import by getting the data from a SQL Database source file and then lo...
  • richie's avatar
    richie
    8 years ago

    Hi HEATConsultant,

     

    check the other post you submitted - I've answered that one.

     

    The change to those instructions to source from a database is to specify 'Data Connection' rather than 'directory'.

     

    Obviously you'll have to tailor the query appropriately to pick up the records you need - check out the following link https://support.smartbear.com/readyapi/docs/testing/data-driven/types/connection.html

     

    Cheers,

     

    richie

selva29's avatar
selva29
Occasional Contributor
8 years ago

Hi , 

 

I cant able to execute complex POSTGRES query form JDBC Request and get the response . same query is working fine in the POSTGRES console and get the result .

 

Is Soap ui accepts only the sql query , post-gres query are not working from jdbc request?, if so what will the solution for this? Please someone clarify 

 

query which i tried: 


select Max(NULLIF(regexp_replace(reference_id, '[^0-9.]*','','g'), '')::numeric)
from transactions as ref_id 

 

Thanks