Service Virtualization

how to use DevTest internal database ?

By DevTest internal database, I assume you are referring to the Derby database that ships with the DevTest product.  CA provides this instance of Derby to assist customers during the initial installation and usage of DevTest. This database is not designed nor recommended for long term usage.  

CA advises customers to switch to a supported Enterprise DBMS package either during the installation procedure or as soon as possible after installation.  

If your question refers to how to extend the databases maintained inside Derby, those actions are performed as they would be for any other DBMS.  However, I would recommend against adding new tables or altering existing tables in the OOTB Derby databases as you could potentially break the product or create issues when migrating from one release to another.

I agree with Joel. Adding new tables or altering existing ones may impact the functionality. However, if you would like to  query and view the data, you can connect to the internal derby instance using any DB client software, like SQuirreL SQL Client and query the tables. 

Agree with Joel, the Derby database will not be supported if manually altered outside of DevTest.  The Derby database is for demo purposes only to verify the components out of the box.  Once testing is started you will have to go to a supported external database.

To add to all of the correct comments above, if the product database is altered CA Product Support will not be able to assist with any database related issues.

Since a new, unaltered, schema would be required when investigating an issue, there is the potential for data loss.

We therefore recommend that no changes be made to the database other than those made by the product or on direct instruction from CA Support. 

how can I query internal derby database ?  Also is there any way to find out if any enterprise database are used in workstation , if there is no access to enterprise Lisa server?

Direct access to the DevTest database is not supported. If I understand your second question correctly, it is expected that the workstation be able to access the enterprise database. In all but the most recent releases is is a requirement.