Q&A

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

I can able to execute the table but unable execute the specific column of the table
answered 04-01-2021 05:51:58 -0500

I can able to execute the table but unable execute the specific column of the table. error message Finished with error: Field not found 'bv_SYS_BIC_sap.bayer.CRM/CV_REP_CHANNEL_ENGAGEMENT_AGG_001.start_date' in view 'bv_SYS_BIC_sap.bayer.CRM/CV_REP_CH...

Answers: 1

Invalid query in create base view from query DENODO

Getting error while exposing the Denodo view as REST API with Authentication.
answered 04-01-2021 04:50:55 -0500

HI Team, I am able to expose Denodo view as REST API with authentication method as "None" in setting tab. I can access this view using the URL provided. But when I am exposing any view with any authentication method other than None, I am unable to acce...

Answers: 3

REST API REST Denodo Testing Tool REST Webservice

Number of Load processes in a scheduler job
answered 31-12-2020 07:28:58 -0500

Hello experts, Is there a limit on the number of load processes that can be added to a scheduler job? I have over 60 load processes added in the extraction section of a job and I when I add a new load process, I do not see it in the 'Load Processes' l...

Answers: 1

load processes Denodo Scheduler 7.0

Connect to aws source
answered 30-12-2020 21:38:09 -0500

Hello, How do I connect to Impala that is on AWS? For example, is this correct? Database adapter : Impala 2.3 Driver class path : '<DENODO_HOME>\lib-external\jdbc-drivers\impala-2.3\ImpalaJDBC41.jar' database URI : jdbc:impala://xyz.<aws regio...

Answers: 2
Related to: How to connect to Cloudera Impala from the Denodo Platform

denodo impala aws

Use a jdbc drive in custom handler.
answered 30-12-2020 17:43:47 -0500

In a custom handler, I am trying to conenct to a SQL Azure database using jdbc to log some schedule job run information (such as a start time). The custom handler failed with the folloiwng error: No suitable driver found for jdbc:sqlserver://{SQL Azur...

Answers: 1

handler Job scheduler JDBC

Connection with sql server database
answered 30-12-2020 00:52:28 -0500

Hi Team, I have to read one view from sql server database.How we can set up connection with sql database and can access view. Thanks in advance.

Answers: 1

SQL Server

Getting Error "End of line not found".
answered 30-12-2020 00:30:52 -0500

Hi, I'm getting below error while running one of the interface in VQL shell. Any idea how to resolve this. **Finished with error: Error executing query. Total time 107.932 seconds. [PARSEERROR] Line too long. End of line not found after analyzing 5...

Answers: 1

creating JDBC data source at denodo scheduler version 8
answered 29-12-2020 09:21:07 -0500

please I have an error while trying to export data at jdbc source.. error is "The driver referenced by this data source clas path does not exists"... even the driver exists and works great at scheduler version 7 .. any help please ? also I need to ask ...

Answers: 1

Denodo 8.0 Denodo scheduler admin

Unable to start denodo express 8.0 on Mac
answered 29-12-2020 02:23:12 -0500

Hi Folks - I do understand it is not officially supported. Any guidance of getting around this error is appreciated.... suntosh@suntosh-324-mbp16 bin % ./vqlserver_startup.sh suntosh@suntosh-324-mbp16 bin % Starting Denodo Virtual DataPort Server ... ...

Answers: 3

Denodo Installation

how to use import.sh to run the vql?
answered 28-12-2020 12:23:23 -0500

I understand and used below to run vql shell by import.sh, which run the vql shell in a file using below command with option "-f": $DENODO_HOME/bin/import.sh -f ${connectionTmpFile} -h "${i}?${uid}@${passwords}&queryTimeout=9" >> ${objectlogF...

Answers: 1

import.sh