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.