Latest Activity

code

Executing multiple queries separated by semicolon through python

Hi, Is there any way of executing multiple queries separated by semicolon through jdbc connection via python? Thanks, Aashutosh

jdbc Python

code

IO Error: Invalid number format for port number

Welcome everyone I'm trying to connect to JDBC, but I'm running into a problem (IO error: Invalid number format for port number) i need help, Thanks

IO Error: Invalid number format for port number JDBC

code

Getting py4j.protocol.Py4JJavaError: An error occurred while calling o65.jdbc. : java.sql.SQLException: Unsupported type TIMESTAMP_WITH_TIMEZONE

I am making JDBC connection to Denodo database using pyspark. The table that i am connecting to contains "TIMESTAMP_WITH_TIMEZONE" datatype for 2 columns. Since spark provides builtin jdbc connection to a handful of dbs only of which denodo is not a pa...

JDBC Spark Spark-sql connection

code

JDBC driver not connecting to database

I have downloaded & installed denodo-vdp-jdbcdriver-8.0-update-20210209 in an Windows application to create a connection. I am able to successfully connect to the server but it does not appear to be connecting to the database. Full connection URL...

JDBC driver for Denodo 8 JDBC Denodo vdp jdbc driver

code

Getting Source Tables and Columns of a Datasource through Query

Hi Denodo team, Are there any queries to get all the tables in the datasource and also columns in a datasource for a specified table. I have seen that GET_SOURCE_TABLE() procedure is giving table but it takes view name as a parameter,but I don't want t...

JDBC query Database JDBC DataSource

code

Cloudera CDP with Impalad 3.4.0 jdbc connector

We are currently using Denodo 7 (future plans to upgrade to 8) and are currently using the Impala 2.3 jdbc connector with Cloudera CDH 6.3. We will be upgrading our current Cloudera environment to Cloudera CDP 7.1.6 with Impala 3.4.0 and was curious if...

cloudera JDBC impala

code

How to connect to Amazon Athena from Denodo 8.0 using JDBC??

Hi, is there any documentation on how to perform when connecting to AWS Athena from Denodo 8.0 using JDBC. I know the ir documentation on how to connect bu with Denodo 7.0. Are the procedures the same? Thankyou

Denodo 8.0 JDBC Athena

code

Simba connection error in : uncategorized Column Type

Hi, I am trying to fetch the data from a table on Azure Databricks (ADLS). Tables are delta tables. I am using Simba driver on Denodo and the connection is successful as suggested in denodo documentation. After successful connection. I try to do "Creat...

simba JDBC Azure databricks

code

How to Create Base View in Denodo to a NEO4J data-source?

Hi All, I know that a very similar question was asked before, but my problem is not connecting Denodo with Neo4j, I could connect the tools using the corresponding Driver, placing it in the folder "<DENODO_HOME> \ lib \ extensions \ jdbc-drivers...

Neo4j Create Base View Connection JDBC

code

Adding CONTEXT to JDBC Database URI

I am trying to add a timeout context to a JDBC connection. JDBC Parameters are referenced in the documentation (https://community.denodo.com/docs/html/browse/6.0/vdp/developer/access_through_jdbc/parameters_of_the_jdbc_connection_url/parameters_of_the_...

context JDBC