Q&A

You must sign in to ask a question. If you do not have an account, you can register here

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 April 2018.

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

Using CTE WITH clause for creating base view from query
answered 12-04-2018 09:19:08 -0400

I'm trying to use a CTE MS SQL query to flatten a dataset of employees and their managers. After looking through mutiple articles in the support section I was hoping I could use "create base view from query". This is giving an error saying - "Incorrect...

Answers: 3

Base view quer cte MSSQL

Find out particular username among multiple data sources
answered 12-04-2018 09:05:40 -0400

Hi Team, Denodo 5.5 DEV environment Suppose there are 10 databases and each database has 10 data sources (mix of jdbc, odbc) (mix of sql server, oracle) Now there is one particular user name, lets say, "denodo_read". This username is present in b...

Answers: 1

DataSource

SSL connection hunging
answered 12-04-2018 08:09:14 -0400

hi Team, i did uncommented and checked next properties files $DENODO_HOME/conf/vdp/VDBConfiguration.properties $DENODO_HOME/conf/vdp-admin/VDBAdminCrnfiguration.properties $DENODO_HOME/resources/apache-tomcat/conf/tomcat.properties $DENODO_HOME/resourc...

Answers: 1
Related to: SSL Self-Signed Cert Installation

SSL

desc wrapper jdbc
answered 12-04-2018 07:44:47 -0400

unable to create base view from query for a jdbc datasource query : desc wrapper jdbc view_name_here error : Unable to create base view: Syntax error: Exception parsing query near '= same query works fine in vql shell. [Denodo VDP 5.5]

Answers: 5

Wrapper

Encrypted connections to sqlserver data sources
answered 12-04-2018 00:37:25 -0400

Hi, I'm trying to create a data source in VDP to a SqlServer DB that requires an encrypted JDBC connection and I'm having trouble finding the proper documentation. Could you point me towards the proper documentation? Thanks, Bryan

Answers: 3

How to convert @LASTCACHEREFRESH to long type as YYMMDDHHMMSS?
answered 11-04-2018 15:40:38 -0400

My source is DB2 and the last updated field type is long as YYMMDDHHMMSS formate. I want to use the full cache-> incremental query->condition to retrive the changed data, how to do it?

Answers: 3

Data Type Conversion

EncryptPassword.getClearPassword() doesnt seem to work
answered 11-04-2018 11:56:36 -0400

I want to store Encypted password in my config file, before sending it to Scheduler Manager to establish a connection. I used the script: 'encrypt_passowrd.bat' 'my_password_to_be_encrypted' And it did generate an encrypted string for me. I used this ...

Answers: 1

encrypt_password.bat java code

Unrecognized SSL message - SSL Exception while instantiating SchedulerManager Class.
answered 11-04-2018 08:31:43 -0400

Whenever I try to instantiate the ScehdulerManager class in my Java project using the below code : SchedulerManagerFactory.getManager(context); I get the below Connect Exception : error during JRMP connection establishment; nested exception is: javax....

Answers: 1

java Scheduler Connectivity

Bulk Data load API
answered 11-04-2018 07:23:37 -0400

Hi Team, I am new to the denodo software. Can you please let me know the steps for bulk data load in denodo having a oracle DB source. Also let me know the things to take care while doing bulk data load using denodo. Also i would like to know what is...

Answers: 1

How to connect the Denodo Server to the Microsoft SQL Server who supports SSL?
answered 11-04-2018 04:11:40 -0400

The Denodo Server is trying to connect to the Microsoft SQL Server using JDBC. But, the MS SQL SERVER forces SSL encryption. The SSL encryption can not be turned off on the the server so turning off SSL is not an option. In that case, how to connect th...

Answers: 1

SQL Server MSSQL SSL SQLServer