18
Views
3
Comments
[Test Automator] Does it work with Oracle Database also?
Question
test-automator
Web icon
Forge asset by Test Automator Team

In the requirements it says SQL Server, but would it run on Oracle also? Thanks!
2012-03-02 13-17-21
Paulo Ramos
Staff
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.
2019-04-22 19-12-14
André Silva

Thank you, Paulo!
UserImage.jpg
Bill Livesey

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.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.