You can translate the document:

Content

Virtual DataPort allows connecting to databases using JDBC data sources. Once the connection to the database is set, base views can be created in VDP. These base views can be created in two ways:

  • Importing a database table directly.
  • Creating a view by executing a SQL query on the database.

When using the second option, the SQL query will be sent to the database without modifications unless interpolation variables are being used. These interpolation variables use the syntax @VARIABLE or @{VARIABLE} like in the following examples:

SELECT * FROM internet_inc WHERE state = ‘@OPTION’

SELECT * FROM internet_inc WHERE state = ‘@{OPTION}’

It is important to keep in mind that the characters “\”, “^”, “@”, “{“ and “}” are special characters for VDP so they need to be escaped with the “\” character when creating the base view if they are not being used to define interpolation variables.

In Denodo versions previous to Denodo 8.0, SQL comments like lines starting with “--” must be deleted. To avoid errors on execution time when applying some optimizations the semicolon “;” at the end of a SQL query, if any, must be removed too.

In these versions, after receiving an “Invalid query error” or an “invalid character” error when creating a base view using a SQL query take into account these considerations in case some characters need to be escaped or removed.

References

Create Base View from SQL Queries

Disclaimer
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.

Questions

Ask a question

You must sign in to ask a question. If you do not have an account, you can register here