Access Data Reservation and Model Details in OrientDB

In the CA TDM Portal, all the data reservation and test data model details are stored in OrientDB. OrientDB is installed when you install the CA TDM Portal. You can query OrientDB in one of the following ways to find the details:
tdm44
In the CA TDM Portal, all the data reservation and test data model details are stored in OrientDB. OrientDB is installed when you install the CA TDM Portal. You can query OrientDB in one of the following ways to find the details:
2
2
Using the Command Prompt
To use the command prompt to access the data reservation and test data model details in OrientDB, follow these steps:
  1. Open the command prompt.
  2. Navigate to the following location:
    C:\Program Files\CA\CA Test Data Manager Portal\orientdb\bin
    Note:
     
    C:\Program Files\CA\CA Test Data Manager Portal
     represents the default location where the CA TDM Portal is installed. 
  3. Open the console as follows:
    console
  4. Connect to the host as follows:
    connect remote:
    <host>
    root
    <password>
  5. List the databases as follows:
    list databases
  6. Connect to OrientDB as follows:
    connect remote:
    <host>
    /ReservationDB root
    <password>
  7. List all the classes as follows:
    classes
  8. Browse the contents of a class as follows:
    browse class DataModel
  9. Run the select statement for a test data model as follows:
    select * from DataModel
  10. Run the select statement for a data reservation as follows:
    select * from Reservation
For more information about other SQL commands, see http://orientdb.com/docs/2.0/orientdb.wiki/Tutorial-SQL.html.
Using the Web Interface
To use the web interface to access the data reservation and test data model details in OrientDB, follow these steps:
  1. Access the following URL:
    http://<hostname>:2480/studio/index.html 
    <hostname>
    represents the computer where the CA TDM Portal is installed.
  2. Click
    Schema
    .
  3. Click
    DataModel
    or
    Reservation
    as required.
  4. Click
    Query All
    .
    All relevant details are listed.