This site requires JavaScript to be enabled
IE BUMPER

Logo

Dear Tricentis qTest users,

If you would like to submit a Tricentis qTest ticket,

please use this support request form.

Tosca Version
IncidentLookup using list
Language
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
  Help
IE BUMPER
Categories
Boolean Operators
OR or vertical bar symbol (|)
Finds a match if either the terms exist in a document (a union using sets).
AND
Finds a match if both terms exist in a document (an intersection of sets).
NOT, minus (-), or exclamation point (!)
Excludes documents that contain the term after NOT (a difference of sets).
Wildcards
Asterisk (*)
The asterisk symbol performs a multi character wildcard search.
Percent sign (%)
The percent sign performs a single character wildcard search.
Phrases
Quotation marks (")
Use quotation marks to search for an exact phrase with multiple terms.
For examples and more information look at our Knowledge Base: Advanced Search On The Support Portal

General clarifications on TOSCA

Is the below steps possible using TOSCA in testing?
(i) Validate the data in CSV/Triplet files against Database.
(ii) Query the entire table and store the data in some Excel.
(iii) Screenshot of Database validation.

Does anyone know how these steps were done?

Thanks.

1 0

Pugazhvanan Ganapathy

Created: 2017-06-21 18:57:52 , Updates: 1, Last Update: 2017-06-21 18:59:10

Hi Vinodhini,

I understand you wanted to do some groundwork before start working on it. Here is my response based on my knowledge, since I have done some automation on Oracle and SQL Server databases. 
 

Q:: Can I validate the data in CSV/Triplet files against Database?
A :: Yes. You can validate data in CSV using Excel Modules. I have done some work with csv using them. Here is the link you can refer https://support.tricentis.com/community/manuals_detail.do?lang=en&version=10.1.0&url=excel_engine/modules.htm

Q :: Is it possible that I can query the table and store the data in Excel.
A :: Yes. You can select the entire table using sql queries or using where condition and save them to Excel file. But, would like to know why you want to export them to Excel. In case if you want to compare or spot check you can do it with in Tosca using Database Engine instead of saving them to Excel. It is time consuming. Refer below links,
https://support.tricentis.com/community/manuals_detail.do?lang=en&version=10.1.0&url=tbox/tbox_database_engine.htm

https://support.tricentis.com/community/manuals_detail.do?lang=en&version=10.1.0&url=tchb/steering_tables.htm

https://support.tricentis.com/community/manuals_detail.do?lang=en&version=10.1.0&url=tchb/comparing_tables.htm

Also, If your company has purchases Tosca BI (comes with Version 10.2 with separate license), you could do large file, database comparisons in just few seconds. Here is the link

https://support.tricentis.com/community/manuals_detail.do?lang=en&version=10.2.0&url=tosca_bi/tosca_bi.htm

Q :: How to capture the errors of Database validation?
A :: The results are exportable in Tosca with both database engine and Tosca BI. So you will be able to see the mismatches in a readable format like excel or html. Do you still need screenshot?:)

Thanks,
Pugal
Join my LinkedIn group for more interactions and jobs on Tosca
https://www.linkedin.com/groups/12044793

IE BUMPER

Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial