Creating Data Sources and Base Views¶
To retrieve data from a repository of data (a database, a SOAP web service, an XML file, etc.), first you need to create a data source in Denodo. A data source represents one repository of data. Then, you need to create one or more base views over each data source. The base views represent the entities in the source. For example, each base view of a JDBC data source is associated to a table or view of the database; each base view of a SOAP data source represents an operation of the web service, etc.
The pages below explain how to create a data source of each type using Design Studio. You can also create them running VQL commands (Denodo’s extension of SQL), however it is prone to errors so we suggest you do it graphically.
After creating the necessary data sources, create base views and then, derived views that combine and transform the data obtained from the sources.
Note
In Denodo Professional, the maximum number of data sources is 5 (see Denodo Platform - Subscription Bundles).