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

VQL for interface creation
answered 17-04-2018 09:16:38 -0400

On creating interfaces from derived views using denodo front end, I found that some decimal columns(in the derived view) were shown either as decimal or long datatype in the interface. I wish to create interfaces using vql script. Is it safe if I copy...

Answers: 2

Interface

Load on source system
answered 17-04-2018 09:01:50 -0400

Hello, Considering Denodo will send queries to source system, do we have any guidelines regarding the load? Thanks, Adinath

Answers: 1
Related to: Data Virtualization and ETL

Load

Send a Derived View output to FTP Server
answered 17-04-2018 00:17:25 -0400

Hi Team Suppose I have a derived View the related output/data need to generate to a file and need to be transferred to a FTP/SFTP Server, so can you suggest how do we implement it. regards Pavan

Answers: 1

Recursive queries
answered 16-04-2018 15:11:22 -0400

Does denodo 6.0 support Recursive queries like CTE from MSSQL?

Answers: 2

I want a view which only returns the first 10 rows and I want it to be implemented in vql
answered 16-04-2018 10:23:16 -0400

this is in VQL the parser complaints about parsing FETCH CREATE VIEW fv_fillingrate_10lastdays_test FOLDER = '/05 - final views/uc_dmc/uc_fillingrate' AS SELECT DISTINCT trunc(pilot_dt_date_in) AS td FROM fv_fillingrate_dmc fv_fillingrate_dmc WHERE t...

Answers: 1

Creating Datasource - Text file having character like "("
answered 16-04-2018 08:38:52 -0400

I have a text file like this RCL 12312017(1 of 2).txt, i want to make a connection from denodo the date of the file will be changing dynamically.? How oto create a filename pattern for creating data source.

Answers: 1

DataSource

How to connect the Denodo Server to the SQL Server who supports SSL?
answered 16-04-2018 08:31:24 -0400

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

Answers: 3

SQL Server SSL

Datasource Fetch Size Not Inscreasing
answered 16-04-2018 06:35:31 -0400

Hi, I am pulling data from MSSQL Server 2012, I tried to twik fetch size confgration for datasource its not changing. the fetch size is note increasing more then 1000 rows/sec. (from data source to denodo) as well as from denodo vdp cache to other cl...

Answers: 3

Get refreshed current state Job Information using the Denodo Scheduler Client API
answered 16-04-2018 04:50:26 -0400

In my Java Application, I trigger a Denodo Scheduler Job using the Scheduler Manager Factory, and on the Scheduler WebAdmin I can see that the Job got triggered, and the state changes from NOT_RUNNING to RUNNING. However,the belowschedulerManager.getJ...

Answers: 1

java java code

How to Create Base View in Denodo to a NEO4J data-source?
answered 13-04-2018 18:36:11 -0400

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

Answers: 5

Neo4j Connection Create Base View JDBC