agubba
New Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
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?Solved1.7KViews0likes2CommentsHow to write results back to Data source using Groovy
Hello, I am testing a REST API and the response is retrieved in Json. I am using an excel data source with multiple rows of test data in it. Is there a way to write back results of a groovy script step to the same excel data source in a new column against each row of test data? If Yes, kindly provide the steps to do the same. Thanks, Abhishek2KViews1like4CommentsRe: Script assertion to assert json response
Here is the sample json response. For a single "Id", I need to check if the response has a case and description same like as in the excel datasource. This test cases should validate whether all the rows entered in data source has a matching record in the response. Please help. { "Id": "ABC0012345", "Description": "Doc received", "System": "Manual", "case": "C-0601", "DateTime": "2017-08-31", "initiatedBy": "User1", "product": "All-MC", "state": "MC", "deliveryType": "Print", "docType": "Letters" } { "Id": "ABC0012345", "Description": "Doc not received", "System": "Manual", "Case": "C-0600", "DateTime": "2017-12-31", "initiatedBy": "User2", "product": "All-MP", "state": "CA", "deliveryType": "Fax", "docType": "Mails" }1.6KViews0likes0CommentsScript assertion to assert json response
Team, Step 1: I have an excel datasource with 3 columns - ID, Description and Case Step 2: I have a rest service for which ID is a required parameter, which brings back description and case along with other parameters. A single ID can have "n" number of cases. This is a json response Step 3: I have a data source loop, as I want to iterate this for more ID's Need help in asserting the response, where the assertion should validate the combination of Description and Case together. Can someone please provide the Groovy script assertion for this? I have to run this for almost 100 unique ID's1.7KViews0likes3Comments