[Test Automator] Does it work with Oracle Database also?

[Test Automator] Does it work with Oracle Database also?

  
Forge Component
(18)
Published on 2015-11-16 by Paulo Garrudo
18 votes
Published on 2015-11-16 by Paulo Garrudo

In the requirements it says SQL Server, but would it run on Oracle also? Thanks!
Hi,
I don't remember anything specific to SQL Server preventing it to work in Oracle. But it may need some minor modifications. In this case, you should read the requirements as "tested in SQL Server only". Feel free to give it a try, specially if you're confortable with SQL.

Thank you, Paulo!

I'm trying to run TestAutomator on Oracle and have encountered a problems.  

DailyRun_GetCases "Oracle_GetExecuted Tests_Failed" throws and error.  I beleive the SQL for Oracle_GetExecutedTests_Ok and Oracle_GetExecutedTest_Failed should be identical with different values provided for Status_Success.  The SQL for the corresponding SQL Server actions appear to be identical... When I copy/paste the SQL from the _Ok to the _Failed I can get past this issue.

It looks like there was also the same SQL issue on the Homeflow>Dashboard>Evolution_Cases webblock in the "GetExecutedTests" action of Preparation.  I copy/pasted the same SQL from
"Oracle_GetExecutedTests_Ok" from above and the dashboard started working.