In previous sections, you created several views with Denodo to allow client applications to retrieve the information directly from the Denodo server. In particular, you have created the view 'amount_due_by_client' which combines data from several sources and exposes the information about the billing balance of a company's clients.
You already know how to execute queries over that view, but now it's time to connect to the Denodo server from your external applications. Denodo Platform is based on a client-server architecture, where clients issue requests to the server. These requests can be sent using one of the following interfaces:
- JDBC: Denodo provides its own JDBC driver.
- ODBC: Denodo provides an ODBC interface (requires the installation of additional components).
- ADO .Net: Denodo is compatible with the Npgsql ADO.Net provider for PostgreSQL.
- RESTful Web service (XML, JSON, HTML outputs): useful for applications that cannot use the JDBC or ODBC interfaces to connect to Denodo.
In this section, you will see several ways to access Denodo from external applications: