Save test data to an external data connector

[npanag]

Hi,

I recorded a Web application in Ranorex where you give the Monthly Gross amount and it calculates the Monthly Net and the Annual Net amounts.

I was able to give data from an Excel file to the Monthly Gross box (with data connector and variables). The opposite is feasible? For example, for every iteration the Monthly Net and the Annual Net amounts to be saved in an Excel file, or a text file, or a SQL Server database.

Thank you

Nick

[odklizec]

Hi,

There is definitely no (out of the box) way to save data to Excel file, using Ranorex Data Connector methods. I'm not sure about SQL? But it's possible to save data to CSV file. I'm personally using it, as described here:
http://www.ranorex.com/forum/writing-in ... tml#p34657

[krstcs]

I write data to SQL Server all the time in my tests, but I have to do it through code modules. As Pavel said, there is no built-in way to do it in Ranorex.

If you just need to validate the value, then you don't really need to write it back, just make sure your calculations are correct and validate your calculations are equal to your SUT's calculations in Ranorex.

[npanag]

Thank you guys for your help. You guided me looking at the code, where, finally, i managed to find some help in the forum, in the item "How to Query data from sql server 2008".
I was also able to write data to a text file. My problem is that I don't know C#, which i must now explore.