I am using Lisa 8.x and currently on derby DB . I am interested to know about the DB insights ,Schema , Database and tables .
My current requirement is to fetch transactions received by services. I connected to Lisa.db using JDBC step and that was successful and tried few queries i found on community that worked with results. But i want to know all the tables and other details to build some useful queries to fetch meaningful data for report Generation.
Hi J_NeSmith ,
Sorry. I do not know if there are any documentation about the tables and schema. You might use tools such DbVisualizer or Toad to view the schema and data content. Couple things to consider:
- Recommend moving off the DevTest Derby database to an Enterprise DBMS (tables/schemas will remain the same)
- Keep in mind the Schema is internal to DevTest; therefore, it can change without notification in a future release
- Take care to ensure that custom queries for reports do not compete with internal DevTest processing for CPU, tables, memory, etc. -- especially if the product's Derby database is in use
We provide DDL of the databases in the DEVTEST_HOME\database folder. As Joel said, Derby is only supported for demo purposes. It is recommended to use one of our supported external databases and be on a supported release of DevTest.
I found mentioned DDL for database with all tables . Thanks
Thanks Joel and Marcy