Denodo Connections
Anmerkung
This connection type is disabled by default. For more information on enabling this connection type, please contact, Alteryx Support.
You can create connections to Denodo through Alteryx Analytics Cloud (AAC).
Supports Basic and OAuth2 credentials types.
Supports custom queries.
Uses native JDBC driver.
Limitations
intervalyearmonth
andintervaldaysecond
are not supported and these datatypes are read as strings in the AACAAC 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 AACAAC 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 AACAAC.
After completing the above, you can create a connection in AACAAC to Denodo Server to begin accessing your data.
Create Connection
From AACAAC
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 Tipp Use chunkSizeandchunkTimeout in the Connect String Options to optimize performance. |
Credential Type | Select the type of credentials to provide with the connection:
|
Default Column Data Type Inference | Leave this value as |
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.