Home / Q&A / All Questions

Q&A

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

Fetching Column issue in VQL
answered 05-01-2021 05:39:50 -0500

we have SAP Data Base, when we excute the base view in the denodo tool we could able get the 150 records. But, while excuting in the VQL shell for the specific Query like Select <Column_name> from <data_base>.<Base_view_name> throwin...

Answers: 1

VQL SAP DENODO SAP BW/4HANA

Dynamic Base View based on another Base view (not JOIN)
answered 04-01-2021 12:18:07 -0500

Hi, I need help with a very specific use case. I have 2 different data sources and I need to create a base view from source A filtered by some values from another base view coming from source B. This values in the second view would be a hole column, ...

Answers: 5

Dynamic Interpolation Variables Create Base View join

How does "Case sensitivity in comparison of literal strings" work in Denodo? I am getting the same results for Uppercase and lowercase strings.
answered 04-01-2021 08:59:13 -0500

I am implementing a search module on Denodo REST API. When the users perform a search, they are likely to use lower case for all their search terms. However, if it is case-sensitive, if the search information was spelled with an uppercase in our system...

Answers: 2

REST API REST search

Error while creating a project in Eclipse
answered 04-01-2021 06:29:09 -0500

Hi I'm trying to create a new project in eclipse after installing the denodo4e software successfully, but its giving me an error saying wizard cannot be started. Please help me on this as my teams development activities are getting delayed because of...

Answers: 1

Denodo stored procedure Custom stored procedure

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