Preparing the Connection to Databases

To connect to a database from Virtual DataPort through its JDBC interface, you need to do this:

  1. You may need to obtain the JDBC driver from the vendor’s website.

    The Denodo Platform does not include the JDBC drivers for all the databases that it supports. The appendix Supported JDBC Data Sources of the Administration Guide lists the databases supported by Virtual DataPort and if its driver is included or not.

    If the driver is not included, once you obtain it, copy it to the folder <DENODO_HOME>/lib-external/jdbc-drivers/database adapter - version, in the host where the Denodo server runs. For example, if you are going to connect to Teradata 15, copy the driver to <DENODO_HOME>/lib-external/jdbc-drivers/teradata-15.

  2. You will need a service account with at least READ privileges over the tables and views that you want to access in the database. This account will be used at least, while importing these elements into Virtual DataPort.

  3. If this database is going to be a target of a Data Movement, this service account also requires the privilege to create and delete tables, and insert data in them.

  4. We recommend creating a catalog or schema in the database that the Cache Engine is going to use. The Cache Engine creates many tables (one for each view of Denodo where the cache is enabled). Therefore, it is useful for these tables to be isolated from the rest of the elements of that database.