Denodo Connections

Contents:

Expand all Collapse all

Contents:

NOTE: This connection type is disabled by default. For more information on enabling this connection type, please contact, Google Support.

Feature Availability: This feature may not be available in all product editions. For more information on available features, see Compare Editions.

You can create connections to Denodo through the Dataprep by Trifacta application.

Supports Basic and OAuth2 credentials types.
Supports custom queries.
Uses native JDBC driver.

Limitations

intervalyearmonth and intervaldaysecond are not supported and these datatypes are read as strings in Dataprep by Trifacta environment.
Denodo Platform version should be 8.0 or above.
While using custom SQL, LIMIT under subqueries is not supported.

Prerequisites for OAuth 2.0

Before you begin, please verify that your Dataprep by Trifacta environment meets the following requirements:

Create an OAuth 2.0 client app for Denodo in a supported identity provider. For example, Azure AD. For more information, see OAuth 2.0 for Denodo.
Configure Denodo Server to use the OAuth 2.0 client credentials.
Create the Denodo client in the Dataprep by Trifacta application.

After completing the above, you can create a connection in the Dataprep by Trifacta application to Denodo Server to begin accessing your data.

Create Connection

via Dataprep by Trifacta application

When you create the connection, please review the following properties and specify them accordingly:

Connection Property	Description
Host	Host of the Denodo server.
Port	Port number of the Denodo server.
Database	Database name of the Denodo server.
Connect String Options	The following is the default connect string option: connectTimeout=0&queryTimeout=0 Tip: Use chunkSize and chunkTimeout in the Connect String Options to optimize performance.
Credential Type	Select the type of credentials to provide with the connection: Basic: Denodo server supports username and password authentication. OAuth 2.0: You must create and register Denodo an OAuth 2.0 client in Dataprep by Trifacta application . For more information, see OAuth 2.0 for Denodo.
Default Column Data Type Inference	Leave this value as `Enabled`.

Create Connection via API

"vendor": "denodo",
"vendorName": "denodo",
"type": "jdbc"

Driver information

For more information on drivers, see https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/access_through_jdbc/access_through_jdbc.

Testing

For more information, see Verify Operations.

Using Denodo

Denodo is a data virtualization tool that combines the data from different sources logically.

See Also for Denodo Connections:

Send Feedback

Page tree