Latest Activity

code

How to deal with BLOB in Denodo?

Hello Team, I have a situation that I imported a base view from SAP table. But there is a column which data type is RAW in SAP. After creating base view in Denodo, the type of such column convert to BLOB. If I use cast('text',column) when creating deri...

BLOB SAP

code

SAP ERP Profit Center Master Data Table in Denodo

Hi all, I want to provide a master data table for SAP Profit Center Hierarchy. I found the CEP table and the CEPCT table which are good, but I have problems with the hierarchy nodes. I can't find the descriptions and texts of the nodes in this tables....

SAP

code

handelng leading zeros

Hey Team, I have a Database (SAP) that I connect via the custom wrapper (RFC Calls). In this I have a column that contains leading zeros. It usualy contains int with 8 digits but itis saved as text with 10 char (2 leading zeros). Is it possible to map ...

VDP SAP leading zeros

code

Getting the Source Tables and columns for non-JDBC datasources

Hi Denodo Team, For the views created from JDBC datasource in denodo I am able to get the source tables by using the default procedure GET_SOURCE_TABLES(). But when I use the same procedure to get the underlying source table information for the datasou...

source tables SAP CSV Denodo8 JDBC Data Sources source columns DataSource underlying tables

code

Connect to Denodo from the Power designer tool

Hello, Is there any documentation on how to connect from the SAP Power designer tool to Denodo? We want to connect to Denodo from the designer and generate the Data models based on the associations in Denodo - which we have created already in Denodo. ...

SAP Data Modeling

code

"SELECT top 1 1 as ID FROM <base view> uanble to excute

We have connected the SAP Database. when we are unable to excute the below query "SELECT top 1 1 as ID FROM &lt;base view&gt; " for the expected result ID 1 what changes can be done as the expected result thanks in Advance

Top N SAP DENODO SAP BW/4HANA denodo with tableau

code

Fetching Column issue in VQL

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 &lt;Column_name&gt; from &lt;data_base&gt;.&lt;Base_view_name&gt; throwin...

VQL SAP DENODO SAP BW/4HANA

code

ODBC with SAP HANA in Linux

Hello, In a linux server I have installed Denodo, and I need to create a ODBC datasource to connect with SAP HANA, and I readed that I need to use SAP HANA 2.0 ODBC driver. How can I configure Denodo and how can I create the datasource?

ODBC SAP Linux SAP BW/4HANA DataSource

code

SAP Idocs with Denodo

hi all, we are connecting Denodo with several SAP systems, receiving master data and transactional data. most of the connections use SAP IDOCs, and as Denodo does not handle IDOCs we have Tibco in the middle as passthrought, converting IDOCs into XML t...

SAP XML Idocs

code

SAP BW MDX Optimised Query

Hi, We currently have a base view on SAP BW, which includes a large number (30) of characteristics. The intention is to provide the view to users, who will then only select two or three characteristics for their report. The problem we have is the MDX t...

SAP SAP BW