Q&A

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

Denodo unable to fetch all the records for an entity which contains different Schemas file extensions for the parquet files from S3
answered 24-02-2021 06:15:56 -0500

Hello, I tried to create a base with file pattern (.) for the parquet file entity/table in s3 region. Then, when i excute the count query to fetch all the recodrs in the entity.I could able to get the below mentioned error. Finished with error: Error ...

Answers: 3

custom S3 HDFSCustomWrapper; S3 DENODO AWS S3 Create Base View

Condition controls in the base view of a custom wrapper connector
answered 23-02-2021 07:09:19 -0500

I limited the allowed operators to “=”, “>=”, and “<=” by overriding the getConfiguration method with CustomWrapperConfiguration configuration = super.getConfiguration(); configuration.setAllowedOperators(new String[] { CustomWrapperCondition.OPE...

Answers: 1

Custom Connector custom wrapper

vql to get only the exact database URI for data source in Denodo
answered 23-02-2021 00:23:51 -0500

HI team, do we have some system table, or vql command, which get only the exact database URI for a Denodo data source, for example we only want to get below kind of information: jdbc:oracle:thin:@aassddcc.compant.com:6566/aassddcc I understand we have...

Answers: 3

vql database URI

Error while launching Denodo Monitor - Failed to invoke from(CompositeData)
answered 22-02-2021 09:54:57 -0500

Hi, I’m making tests using Denodo Express 8.0 for Windows 64 bits. I need to trace the queries done by each user and i want to check that Denodo Monitor can give me all the needed information. I followed this instructions : https://community.denodo.c...

Answers: 2

Denodo Monitor

Same Query Returns different number of records in Baseview and Derivedview
answered 19-02-2021 07:29:38 -0500

Hello Team, I have created 2 baseview(bv_studies, bv_results) of dfferent sources in Denodo. After that, I have created one derived view(dv_final) from these baseview with Inner Join. I am passing 2 parameters to bv_studies. Now the problem is, while ...

Answers: 4

Quary execution Baseview derived view

Direct Data Load
answered 19-02-2021 07:22:05 -0500

I have sevral views which are copies of the base views, but in order to maintain the setup we have in Denodo and to only expose 1 Database to the ODBC users we had to create these exact copy tables from the base views. With this new option of Direct Da...

Answers: 1
Related to: Denodo Platform 8.0 February 2021 Update - Virtual DataPort Enhancements

Direct Data Load

VQL Parser for Python
answered 19-02-2021 07:17:32 -0500

Hi, I would like to parse a VQL in Python in order to retrieve all elements of a VQL in a correct AST. Could you please tell me if such kind of parser already exists or if there is a way to get the VQL grammar somewhere ? I already found some fragment...

Answers: 3

VQL parsing Python

Denodo Connection to SAP BW4HANA
answered 19-02-2021 05:01:20 -0500

Hello Team, Good afternoon. We are planning to upgrade our SAP BW on HANA system to SAP BW/4HANA system and connect Denodo to do data virtualizations from various systems including BW/4HANA for reporting. What is the best and feasible approach to conne...

Answers: 1

SAP BW/4HANA

Powerbi Connector
answered 19-02-2021 04:31:13 -0500

I'm trying Powerbi Connector in order to use DirectQuery but always PowerBI make a full import of the result of the Directquery, the report always wait finish the load of all directquery... so, not using all the power of Denodo. How can I use Powerbi d...

Answers: 1

#powerBI connection #Denodo-PowerBI

pg_database not found error from ERStudio
answered 18-02-2021 07:30:30 -0500

Hello, I am trying to connect to Denodo from the ER Studio tool. However, I am getting the "pg_database not found error" . As suggested in the below link: https://community.denodo.com/answers/question/details?questionId=9060g000000XesTAAS&title=OD...

Answers: 1