Take the 2-minute tour ×
Software Quality Assurance & Testing Stack Exchange is a question and answer site for software quality control experts, automation engineers, and software testers. It's 100% free, no registration required.

I'm working with several companies that are deploying SAP HANA (in memory appliance that compresses data from the DB and moves the entire structure into memory resulting in query times that are ~3600 times faster). Our problem is we need to functionally test the system to ensure the right data arrived, no corruption occurred, the apps were modified to talk to this appliance rather than the DB correctly, etc.

We came up with a basic way to do this but we need more. We're going to run some reports with the system before migrating to HANA and then run the reports afterwards. They should be the same since the application shouldn't have changed functionally and the data should be identical even though it's in columnar format and in a different location.

How else can you functionally test reports or reporting UIs like BI or BW? What about Flash or CRM apps?

Also, I'd like to find a way to automate this. If anyone has experience automating BOBJ, let me know. I'd love to buy you a steak dinner.

share|improve this question
    
This might be useful, a question about testing backend migrations: sqa.stackexchange.com/questions/2625/… –  Sam Woods Mar 6 '12 at 16:44
    
Mike, when you say the same, what do you mean? The same content, the same layout, the same user interaction? Each can be tested differently. –  dzieciou Nov 3 '12 at 7:58
    
Check out diffkit.org, its a command line Java tool that will diff entire DBs. With it you can easily setup automated tests for larg edata structures. –  Merch Mar 12 at 8:58

2 Answers 2

No steak dinner for me and a bit of a general reply but do you have a way in your apps to capture the query/results going to/from the database? We have done a similar thing with SQL Server Analysis Services and then written an application to "replay" the traces and verify the response. Once you have the queries and results in text format (assume that's what the traces show) you can write scripts to vary the queries to test other functionality beyond the original queries.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.