Denodo community Q&A RSS feedLatest Denodo community answered questionsHow to insert binary value to BLOB type2024-09-10T10:53:05Z2024-09-10T10:53:05ZI have a Mysql table with BINARY AND BLOB types.
Created a Base view via Administration tool, where BINARY AND BLOB types taken as BLOB by default
If I want to perform insert operation with Hexadecimal values (0x68656C6C6F) in to the Binary col and Blob columns , I am getting `Exception parsing query near 'x68656C6C6F'.
`what is the right way to handle this scenario. What is the correct syntax
And How denodo differentiate Binary and BLOB types2024-09-10T10:53:05ZRefresh Time / Update frequency2024-09-09T14:36:12Z2024-09-09T14:36:12ZHello,
If I want to know the refresh time or update frequency of any particular data table which is on Denodo Data Catalogue how can I find it ?2024-09-09T14:36:12ZDependencies2024-09-09T09:49:42Z2024-09-09T09:49:42ZHi Team,
Is there any way to get the list of all the dependent views of a base view.2024-09-09T09:49:42ZColumn space issue2024-09-06T11:00:35Z2024-09-06T11:00:35ZWe have a view which is generated from joining a view from collibra, this view has an extra space in the specific column of the view. This space from the view is affecting other views down the line, we have applied the option 'trim' to eliminate the unwanted space .
This space is not available from the source system views, it is observed that the space is present onky after the join.2024-09-06T11:00:35ZGit with HA configured VDPs2024-09-04T20:51:58Z2024-09-04T20:51:58ZWe use Git for source control on Design Studio objects, and since we have switched to HA, the local repository is locked when trying to commit an object. Additionally, we run git reports on the local repos to determine any uncommited files and changes in the last week. The commands are in a shell script, run on the local VDP in this directory: /opt/denodo/denodo-8/work/vdp/repository/
Here's the commands run in the script:
git log --pretty="%h - %s" --since="1 weeks ago"
git diff --stat origin/main
Since moving to a HA configuration, it depends on which VDP you connect to when running the script. If you commit on VDP 1, then you do not see these changes reflected in the copy of the local repository in VDP 2.
How do you force connection to the same VDP when in a HA configuration where you have multiple hot VDPs? Otherwise, the remote repo will have trouble synching to the local repos because you don't know which is connected when you do commits vs when you make changes and push.
Is there a way to force Denodo into using a common local repository directory across HA VDPs?2024-09-04T20:51:58ZS4 Private Cloud Source2024-08-30T02:42:15Z2024-08-30T02:42:15ZHello,
Anyone connected S4 HANA(on Private Cloud) as datasource in denodo?
Did you have to open DB port at S4 HANA end to enable this? What template with SAP had to be used for ticketing?
What are the other options for this source?
Thanks!2024-08-30T02:42:15ZTime Format2024-08-28T15:05:35Z2024-08-28T15:05:35ZHello Team
I want my hours to be return in 24 hour format and not in the AM/PM format.
for exemple, now, i have this kind of hour 03:38:00, and i would prefer 15:38:00.
Is there a function that can change it in the output?
Thanks2024-08-28T15:05:35ZExcel Datasource (Macro-enabled spreadsheet2024-08-28T05:34:24Z2024-08-28T05:34:24ZHi Team,
one question, is it possible to add a .xlsm datasource.
BR2024-08-28T05:34:24Zhow to combine localdate and time into one column?2024-08-28T03:48:47Z2024-08-28T03:48:47ZHello Team,
I have two columns: one type is localdate and the other is time.
Can I combine them directly into one column and make the type of such column be timestamp?
How should do that?
Thank you2024-08-28T03:48:47ZHotFixes and Denodo container images2024-08-27T15:05:05Z2024-08-27T15:05:05ZHello,
Are hotfixes automatically installed on the denodo-platform and solution-manager container images when a new image is pushed?
Thanks2024-08-27T15:05:05Z