We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in September 2019.
If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.
In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.
Hi, I have this in Oracle. select 'A' || ', ' || 'B' || ', ' || 'C' from dual How do you do this in VQL? Thanks.
Answers:
3
Hello, I would like to how if anyone has been able to connect to an offline siebel database
Answers:
1
Has anyone successfully connected to Denodo using Rstudio or any of the R tools using JDBC?
Answers:
1
Question about CASE in the SELECT statement of query. I have this in Oracle. CASE WHEN REGEXP_LIKE (UPPER (MAIN_PRODUCT), 'CBMCLS|CBMOT|CBMSHG') THEN REGEXP_REPLACE (UPPER (MAIN_PRODUCT), 'CBMCLS|CBMOT|CBMSHG', 'CBM') ELSE UPPER(MAIN_PRODUCT) END AS ...
Answers:
2
SELECT xpath ( cast ('xml' , '<Entries> <ChargebackClaim DebitMemoRefNum="61186134101">123 </ChargebackClaim> </Entries>' ) , '/Entries/ChargebackClaim/@DebitMemoRefNum/text()', true) as xpath_results FROM Dual(); I am getting...
Answers:
2
I've seen commands to update configuration parameters. Is it possible to change the "filename" and "filePattern" parameter within "RollingFile" for QUERIESOUT using VQL ? Or has this to be done by editing log4j2.xml directly?
Answers:
1
I have a connection to an Oracle database. In the connection we set up several Driver Properties including the user name which the database uses to pull only the rows the user executing the query has access to (row security). That property is set up l...
Answers:
1
Hi Team, We need your clarification here, how Denodo create Cache Table in Cache DB, below is the my question: we are using Denodo 5.0 now and migrating code into 6.0. here, we have a view in Denodo 5.0 it is full cached (oracle is Cache DB). just exam...
Answers:
1
When trying to use the concat function, I get an error saying that it is not a recognized built-in function name. Below is a sample script that gives the same error. SELECT t1.api_no14 PID, t1.automation_name WELL_NAME, t2.CREATE_DATE COMMENT_DATE, t2...
Answers:
1
Hi Team, Product Name: Virtual DataPort 7.0 (Express) Hive Version: Hive v1.1.0 CDH (Cloudera Distribution Hadoop): v 5.13.0 Database Adapter : Hive 2.0.0 (HiveServer2) Driver Class path : 'hive-2.0.0' Driver Class : org.apache.hive.jdbc.HiveDriver D...
Answers:
1