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.