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 easiest way to do this is using the administration tool. You can also do it using VQL (Denodo’s extension of SQL), however it is more cumbersome and prone to errors.
The following subsections explain how to use the administration tool to create a data source of each type:
- JDBC databases
- ODBC sources
- SOAP web services
- Multidimensional databases
- XML files
- JSON files
- Delimited files like CSV files
- Excel files.
- Denodo ITPilot wrappers that extract data from web sites
- Google Search appliances
- LDAP servers
- SAP BAPIs
- Custom sources developed using the Denodo API
After creating the necessary data sources, you can create derived views that combine and transform the data obtained from the sources.