Denodo Platform is a data virtualization solution that enables integration, access, and real-time data delivery from disparate on-premises and cloud-based sources.
Before You Begin
It is essential that you have the following installed:
Setting Up a Connection to SQreamDB
Denodo\DenodoPlatform8.0\lib\extensions\jdbc-drivers, create a directory named
Download the SQreamDB JDBC Connector .jar file and save it under the newly created
In the Denodo Platform menu, go to File > New > Data Source > JDBC.
A connection dialog box is displayed.
Under the Configuration tab, select the Connection tab and fill in the data source information:
The name of the data source
The database adapter allows Denodo Platform to communicate and interact with SQreamDB
Driver class path
The path to the location of the JDBC driver required for the connection to the data source
The class name of the JDBC driver used to connect to the data source
The URI that specifies the location and details of the database or data source to be connected
The level of isolation used to manage concurrent transactions in the database connection, ensuring data consistency and integrity
Use login and password
The SQreamDB role
The SQreamDB role password
To verify your newly created connection, select the Test connection button.
When adding the JDBC driver in Denodo, it’s important to note that a restart of Denodo may be required. Additionally, in some cases, the SQream driver may not immediately appear in the list of available JDBC drivers. If you encounter this issue, a simple solution is to reboot the machine and attempt the process again.
When working with table joins involving columns with identical names and exporting a view as a REST service, the query transformation process can introduce ambiguity due to the indistinguishable column identifiers. This ambiguity may result in unresolved column references during query execution, necessitating thoughtful aliasing or disambiguation strategies to ensure accurate results.