Remote Tables

With Virtual DataPort, a user can store the result of a query on a table of an external database. This feature is called remote tables. In this process, Denodo creates the table with the appropriate schema and inserts the result of the query in this table. With this feature, the user does not need another tool to execute a query in Denodo and store the result in a database.

The main component of this feature is the stored procedure CREATE_REMOTE_TABLE. This procedure does this:

  1. Creates a table in the underlying database of a JDBC data source.
  2. Executes a query in the Virtual DataPort server.
  3. Inserts the result of this query into the table of the database created in step #1.
  4. It creates a base view over the table created in step #1.