Using the Essence Framework, you can easily get the same data from the Essence Portal into your own custom Pages and Controls. For this you don't need to write queries or make calls to a webservice. Here's how you can do this.
The use of GetEntities
Using the GetEntities method you can retrieve the data from the Essence Framework. It's an easy to use method and it doesnt make any difference if the data comes from a database or a webservice. Or the data could even come from a combined datasource like a database and an OData webservice. As a programmer you don't have to worry about what is the datasource. GetEntities will handle this all for you.
In this video the use of GetEntities is explained in detail: