Denodo
Denodo, Data Virtualization Platform is a data virtualization platform that lets organizations access, integrate, and deliver data in real-time without physically moving it. It provides a single logical data layer across diverse sources (databases, cloud, big data, APIs), enabling faster analytics and reduced data duplication.
Prerequisites
The following prerequisites must be met in order to create and test a successful connection.
- The Denodo server must be accessible from the iceDQ server.
- Valid credentials to access the database.
- Denodo version 8 or above.
Authentication Mechanism
The following authentication mechanism is supported.
- Username & Password
Connection Properties
Use the properties to create a valid connection. Properties marked with an asterisk (*) are required.
| Name | Description | Example Values |
|---|---|---|
| Connection Name * | Name that uniquely identifies the connection. | Prod_conn |
| Driver * | Driver used to establish the connection. By default, one driver is available. | Denodo Native JDBC |
| Custom JDBC URL | Standardized string used to define the connection details. Use this format supported by the driver: jdbc:denodo://[host]:[port]/[database] | jdbc:denodo://136.954.67.30:9999/prod_db |
| Host * | IP address or hostname of the database server. | denodo.acme.com or 136.954.67.30 |
| Port * | Port is the address on which the server listens. Default value is 9999. | 9999 |
| Database * | Name of the target database. | prod_db |
| Type * | The connection type – either System Connection or User Connection. Refer Connections for more details. | System or User |
| Username * | Database login username with necessary privileges. | john_doe |
| Password * | Password associated with the specified username. | Admin@123 |
Custom Properties
The following optional connection properties can be configured based on user requirements.
| Property | Default Value | Possible Values | Description |
|---|---|---|---|
| adjustScaleOfDecimalValues | false | true, false | Modifies decimal values in ResultSet so their scale matches metadata. Useful for Apache Arrow. |
| autoCommit | true | true, false | If true, JDBC transaction methods (setAutoCommit, commit, rollback) are ignored. Transactions must be handled with BEGIN, COMMIT, ROLLBACK. |
| chunkSize | 1000 | Integer value | Maximum number of results per block (chunk). Can be overridden with setFetchSize. |
| chunkTimeout | 90000 ms | Integer value (ms) | Maximum time the server waits before sending a block to the driver, even if not full. |
| describeNationalCharTypesAsBasicTypes | false | true, false | Reports NCHAR, NVARCHAR, NCLOB, LONGNVARCHAR as CHAR, VARCHAR, CLOB, LONGVARCHAR. |
| i18n | DB default | String (locale/i18n code) | Sets internationalization configuration for the connection. |
| identifiersUppercase | false | true, false | Returns field names in uppercase when executing SELECT queries. |
| password | N/A | String | Password for authentication against Virtual DataPort. Requires user. |
| publishCatalogsAsSchemas | false | true, false | Exposes each database as a schema instead of a catalog (useful for tools expecting schema-based structure). |
| publishViewsAsTables | false | true, false | Publishes all views as TABLE elements instead of VIEW. |
| queryTimeout | 900000 ms (15 min) | Integer value (ms), 0 = unlimited | Maximum time the driver waits for query completion. Can be overridden per query with CONTEXT. |
| reuseRegistrySocket, pingQuery, pingQueryTimeout | None | Strings/Integers | Properties for connecting to Virtual DataPort via a load balancer. |
| ssl | None | true, false | Controls SSL connection: true = SSL only, false = non-SSL only, unset = try non-SSL then fallback to SSL. |
| sslTrustServerCertificate | false | true, false | If true, SSL certificates are not validated (useful for self-signed certs, but risky). Applies only if ssl=true. |
| sslTrustStoreLocation / sslTrustStorePassword | None | File path / String | Path and optional password for trust store containing SSL certificates. Uses JVM cacerts if unset. Applies only if ssl=true. |
| user | N/A | String | Username for authentication against Virtual DataPort. Requires password. |
| userAgent | <empty> | String | Sets the user agent string for the connection (useful for monitoring/auditing). |
| userGSSCredential | None | Java object (org.ietf.jgss.GSSCredential) | Used to pass a Kerberos credential for authentication. Must be set as a property, not in URL. |
| wanOptimized | false | true, false | Enables WAN optimization features to reduce latency. |
Supported Datatypes
The following data types are supported.
- INTEGER
- LONG
- DOUBLE
- DECIMAL
- FLOAT
- INTEGER
- LONG
- DOUBLE
- DECIMAL
- FLOAT
- TEXT
- BOOLEAN
- ARRAY
- XML
- REGISTER
Unsupported Datatypes
The following data type is not supported.
- LOBS