This section describes how to use the Virtual DataPort Administration
Tool to create unified data views from various heterogeneous sources.

We will use the following example as a guide when describing the
process:

Example: Unified data about customer sales and incidents.

A telecommunications company offers phone and internet services to its
clients. Data on the incidents reported in the phone service are stored
in a relational database, which is accessed through JDBC. In addition,
data on the incidents reported in the Internet service are stored in
another relational database also accessed through JDBC.

In our example, the director of the I.T department wants to monitor the
number of incidents (either telephony or Internet) notified by the
clients with the greatest sales volume to establish whether measures
should be taken to increase client satisfaction.

Data on customer sales volumes are managed by another department of the
company. That department provides a Web Service so the other departments
can access to that data.

In this example, we will see how Virtual DataPort can be used to build a
unified data view to meet the needs of the I.T department, by obtaining
the total number of incidents from clients with the greatest sales
volumes.

The path DENODO_HOME/samples/vdp/incidents contains:

SQL scripts for creating the tables used in the examples of this
manual (version for the MySQL, Oracle and PostgreSQL databases).

To follow the examples of this guide, use one of these
scripts to create the required tables in a database.

VQL scripts (VQL stands for Virtual Query Language) that create the
objects (data sources, views, stored procedures…) that we will learn to
create in this manual. You do not need to use them if you are going to
follow this guide. Otherwise, edit the VQL script that matches your
database:

Replace @HOSTNAME with the host name of your database.

In the CREATEWRAPPERJDBC statements, change the parameter
RELATIONNAME, so it matches the name of the schema in your
database. E.g. change RELATIONNAME='VDB.INTERNET_INC' for
RELATIONNAME='test.INTERNET_INC'.