Importing Data Sources and Creating Base Views¶
In the first step of our example, you will learn how to do the following:
- Import two JDBC sources: see section Importing JDBC Sources
- Create base views over these data sources: see section Creating Base Views from a JDBC Data Source
- Import a SOAP Web service data source: see section Importing SOAP Web Service Sources
- Create base views that invoke the operations of the SOAP Web service: see section Creating Base Views from a SOAP Web Service
- Examining the schema of the new base views: Viewing the Schema of a Base View
The second part of the example continues in the section Creating Derived Views.
Besides creating a JDBC and a Web service base view, this section also explains how to import data sources and create base views for the following types of sources:
- ODBC databases: see section Creating Base Views from SQL Queries.
- Multidimensional databases: see section Multidimensional Database Sources.
- XML and JSON documents: see sections XML Sources and JSON Sources.
- Delimited files (DF): see section Delimited File Sources.
- Excel files: see section Excel Sources.
- Web pages: see section Web Sources (WWW).
- Google Search: see section Google Search Sources.
- Denodo Aracne: see section Aracne Sources.
- LDAP servers: see section LDAP Sources.
- BAPI: see section BAPI Sources.
- Custom sources developed using the Denodo API: see section Custom Sources.
When importing data sources of the types XML, JSON or delimited files, it is necessary to specify a path to the file. The section Path Types in Virtual DataPort describes how to do so.