After creating the base views in the previous section, we are ready to query our Data Virtualization server to retrieve the data from our CRM. Let's learn how to issue queries to the Denodo server.
There are several ways to perform the execution of a view, we will use the "client" view for this example, from the Administration Tool:
To use the Context menu you have to:
"Execute..."
.In this case you have to:
Another option is to use the VQL Shell Client:
In the three examples above, a simple query is executed:
After receiving that query, the Denodo server will create a physical query plan to query the data sources (in this case, your MySQL database) and get the results:
You can filter the results obtained in the output using a WHERE condition in the sentence. This can be done using the graphical interface in the execution window shown when using the Context menu or View detail window options.
In this panel,you have specify the where condition. Click on Ctrl+space for autocomplete
To summarize, now you have learned how to execute queries over Denodo views and how the server is querying the source database in real-time to return the results. In the next section, we are going to learn how to create new views using combinations between existing Denodo views.