LISA Features: Databases

Prove the integrity of the data that drives your applications.

So you've tested the user interface to ensure that the values you see on the screen are correct. But how can you trust that the results on your screen have been properly validated in the database? It's time to dig deeper and find out what is happening behind the screen.

LISA is one of the strongest application and component testing solutions on the market. But LISA's ability to talk directly to databases means your team has the ability to expand test coverage to your databases as well.

In the past, database testing was an isolated exercise conducted with manual tests and/or off-the-shelf database testing tools. That would be enough, if your database wasn't being served to any external applications. LISA tests JDBC databases to prove that business requirements are being met on the back-end of your applications, exactly as they will be deployed. LISA was built from the ground up for this purpose.

Features

LISA provides the ideal automated testing environment for JDBC, offering a new level of breadth and depth that allows the entire team to own quality.

• Inline testing. You'll never write a test client or maintain fragile test scripts again. Break the code-compile-run-curse cycle. With LISA, you can execute against live JDBC components, while you're authoring tests, for an incredible boost to iterative development. You will have to see it to believe the level of live analysis interaction and information you get while you are developing with LISA.
• Built on and for JDBC standards. LISA is pure Java, and is innately aware of Java objects, EJBs, RMI, JMS queues, JDBC databases, web services and JMX metrics. As you should expect, LISA runs on any Java-ready client (Unix/Linux, Win, OSX) and can easily test any Java-compliant server.
• Use your data. Lose your insecurities. With LISA, you can capture datasets and use them to make assertions, apply values on a sequential or random basis, or make data comparisons. Test for specific database hacks, and you never need to publish database debug information where end users could intercept it.
• Freedom to test. LISA is a unified solution from ITKO, and not a patchwork of acquired testing tools. Your LISA license allows you to test as many databases, on as many target servers as you like, without per-server, per-technology costs that take away your incentive to test continuously. And if you wish to expand your testing to other types of components such as web services or EJBs, upgrading LISA is simple.
• Multiple roles. LISA is no-code automated testing, meaning developers no longer have to script tests, and non-programming team members in QA and business requirements teams can also get involved in testing.
• Multiple systems. One LISA test case can follow a complex workflow and validate multiple web sites, web services, Java objects and application servers. LISA supports active sessions, SSL, authentication and magic strings, so it lets you test systems just as your end users will. On the back end, LISA provides live interaction and deep testing of any component or service you can access over the Internet.
• Across the full development lifecycle. Roll unit and functional tests into regression tests included in your Ant/Make builds. Then take those same test cases and turn them into load and stress tests that can run continuously with LISA Server.

Benefits

• True no-code automated testing with compelling features for both developers and QA professionals
• Test and verify input and results from any JDBC database
• Point-and-click exploration and analysis of databases
• Accepts most standard SQL and natural language queries within test cases
• Capture datasets from any JDBC database for use as sequences, random values or test controllers within LISA test cases
• Eliminates the need to program test clients and maintain fragile test scripts
• No more "debug information" required in your database output - LISA's secure channel between test and database means your test data is reported directly to LISA, not hidden somewhere within your output where unknown hackers or competitors can gather private information
• Provides an immediate way to enable "test first," XP development practices
• Brings QA into the iterative development cycle for early and continuous testing of databases
• Leverages your existing build and deploy environment of JUnit/Ant
• Point-and-click testing of EJBs, RMI and other J2EE objects in a way no other product can
• Rich analysis and testing of web applications, and the databases behind them in the same no-code testing tool (LISA for Web Apps base, or LISA Complete SOA Testing Suite required)
• Manage properties and test assertions
• Instantly turn test runs into load tests and scheduled performance tests over time
• Identify performance bottlenecks with advanced yet easily configurable metrics (JMX, SNMP, LISA metrics and Windows Perfmon
• Find performance and functional thresholds, and have LISA send alerts if any boundary conditions are met.
• Share LISA test cases and test runs as simple XML files and incorporate them into your groupware, issue tracking and requirements management processes

To learn more about how LISA incorporates the 4 C's and can address critical development constraints and software reliability challenges in your organization, please contact us, or read more about LISA Virtualize, LISA Validate, LISA Test, and LISA Pathfinder.