Latest Activity
I have a server with a Rest API that has multiple endpoints that return JSON data (e.g. a jasperserver that has a rest call to get all report units and a rest call to get all report schedules). I now want to create one table for the report units and on...
I am connecting to a DB2 database. one particular table contains a column with data type - PACKED DECIMAL. the base view displays junk characters for this column. is there a way to convert the data type of the column on the fly or in the VQL? OR i...
Hi Team, As mentioned in the artical it is possible to mount volume in kubernetes for Denodo metadata and depending on the storage class we could persist across deployments. However there is a teething problem with volume mount. With the volume metada...
Related to: Data Persistence in Containers
I am trying to add a timeout context to a JDBC connection. JDBC Parameters are referenced in the documentation (https://community.denodo.com/docs/html/browse/6.0/vdp/developer/access_through_jdbc/parameters_of_the_jdbc_connection_url/parameters_of_the_...
How to write select query for composite keys in denodo like oracle Below is the example for oracle: SELECT * FROM table_name WHERE (key_part_1, key_part_2) IN ( ('B',1), ('C',2) ); Could you please let me know ASAP Thanks Satish K
Hi, I need help constructing the correct VQL to change the password for a JDBC connection within VDP? I believe it is something like: ALTER DATASOURCE JDBC connectionname ENCRYPT_PASSWORD 'thisisthenewpassword';
Hi, I recently created a Power BI report based on a Denodo datasource and published it to powerbi.com. I want to set up a scheduled refresh on powerbi.com. In order to do that, it looks like I need to use a gateway. To ensure that the refresh is cons...
Hello, I know Denodo can be integrated with Presto. Is it planned to be also planned with Trino, the new fork of Presto? If yes, at which horizon? If not, why? Best regards, Tristan Labetoulle
Denodo 7.0 Please how can I use AND for conditions in CASE command. I am getting error for the statement below: SELECT ST."EQUIPMENTID", CASE ST."INSERVICE"=1 WHEN SR."DATESERVICED" IS NOT NULL AND SC."INSTALLDATE" IS NULL AND SC."INSERVICEDATE" IS ...
Hi, Steps followed for neo4j base view. 1) created data source for neo4j by using jdbc (adapter : generic , driver neo4j 4.0 , driver class : org.neo4j.jdbc.Driver) 2) Created a base view from Query using below query MATCH (n:Samplenode {name: 'xyz'})...
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
- 102
- 103
- 104
- 105
- 106
- 107
- 108
- 109
- 110
- 111
- 112
- 113
- 114
- 115
- 116
- 117
- 118
- 119
- 120
- 121
- 122
- 123
- 124
- 125
- 126
- 127
- 128
- 129
- 130
- 131
- 132
- 133
- 134
- 135
- 136
- 137
- 138
- 139
- 140
- 141
- 142
- 143
- 144
- 145
- 146
- 147
- 148
- 149
- 150
- 151
- 152
- 153
- 154
- 155
- 156
- 157
- 158
- 159
- 160
- 161
- 162
- 163
- 164
- 165
- 166
- 167
- 168
- 169
- 170
- 171
- 172
- 173
- 174
- 175
- 176
- 177
- 178
- 179
- 180
- 181
- 182
- 183
- 184
- 185
- 186
- 187
- 188
- 189
- 190
- 191
- 192
- 193
- 194
- 195
- 196
- 197
- 198
- 199
- 200