Latest Activity

code

Why cache job is taking too much time to establish connection to the database.

Hi, We have scheduled a cache job in scheduler to load the cache. But it is taking too much time to connect to the database. Sometime it takes one and half hour and sometime 2 hours to establish a connection to the database. Once it establishes the con...

code

Error ocurred during user context initialization

Hi Denodo Team, I have configured okta for single sign on Denodo Solution manager. After configuring single sign on for Oauth and openid I am getting below error when trying to login to Denodo solution manager Error ocurred during user context initial...

code

Please share ,maven dependency for Denodo 8 JDBC driver

Please share ,maven dependency for Denodo 8 JDBC driver

code

not able to retrieve query result with DSN pyodbc

Hi, I'm trying to retrieve data from Denodo with python using pyodbc. So, I configured DSN as specified in the official Doc and it works correctly. I tested my python application in two way: with a DSN-less pyodbc approach and with DSN pyodbc approac...

code

Install Denodo on mac

Hi how can i install denodo on my mac i saw the following steps > 1-Download the Denodo installer without the JRE 2-Install java 1.6 or 1.7 in your MacOS 3-Set the JAVA_HOME: export JAVA_HOME=$(/user/libexec/java_home) 4-Run install.sh 5-Once the in...

code

using import from repository and properties file

i would like to use the import script command with the -r and -f options such that I have a vql file generated from the source control repository. the only other thing that is missing is the properties file. I would like to be able to execute the vql f...

code

Ms-Access database connection

Dear Sir, I have data in the MS-Access database and please let me know the procedure for connecting these database from the Denodo Tool. Give with example of connectivity. Regards, Senthil

code

Dynamic column names generated from a pivot

Is there a way in Denodo to do a pivot where you generate the column names from a column's distinct values. The only example I could find for Denodo used static values you already knew. I am assuming if there is, it is going to have to be custom VQL q...

code

LEFT JOIN losing rows

Hello, I am trying to join some tables, all with LEFT JOIN, but when I try, the numbers of rows in the results is less than the table in FROM statament. The strange thing is that if I change the order of the joins the number of the results rows change....

code

Design studio default VIRTUAL DATAPORT SERVER

Hi Denodo Team, When I load design studio, by default the VIRTUAL DATAPORT SERVER field is populated with //localhost:9999/ value. How can I override this value with my preferred value or list of values as drop down? This is to make the DIY team's lif...