Q&A

Connecting to Census data using the API and can't flatten multiple levels of json arrays
answered 28-05-2021 13:34:32 -0400

I am using Denodo Express 8.0. I am trying to connect to the census api, and I'm able to create a base view using the url (https://api.census.gov/data/2018/acs/acs1?get=NAME,group(B01001) and a denodo json data source. But when I try to flatten it, i...

Answers: 3

census JSON Data Source

How to patch VDP Admin Tool to 8.0.20210209
answered 27-05-2021 14:31:48 -0400

I recently updated our VDP server to 8.0.20210209. I need to apply the same patch to my workstation. Server is linux, workstation is windows 10. I clicked the Update button on the Platform Control Center on my workstation but then I must browse to a fi...

Answers: 1

patch vdp-client

HTTP 400 error
answered 27-05-2021 08:07:41 -0400

Hi, I am gettign 400 error as well. I can run the API on web but when i run it on denodo its adding 25 before %26 and this is breaking the link. Any reference how to solve this? Error retrieving data from the API. This is the link from execution trace...

Answers: 3

Can Timeout Be Set on the Server?
answered 27-05-2021 03:01:17 -0400

Hi, Instead of configuring the queryTimeout on the application side such as in DSN of various users, can we possibly set the timeout on the server side so that all users, would have the same queryTimeout? This way, we/admin, could control the timeout o...

Answers: 1
Related to: Configuration of ODBC timeout in a DSN

Denodo 8 - SSL Configuration and TLS Configuration Script
answered 26-05-2021 12:41:06 -0400

Team, I'm in the process of configuring SSL for our Denodo 8.0 servers. I'm on the step where we use the TLS Configurator to configure / enable SSL for the platform componenets. For the most part, everything is clear with one exception. The instruction...

Answers: 2

Denodo 8.0 SSL

Convert Ascii to Hexadecimal
answered 26-05-2021 08:01:39 -0400

I'm trying to use base64_to_hex in Denodo 8 but I'm getting error message "Function 'base64_to_hex' with arity 1 not found", I read in https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20XtraFuncs%20-%20User%20Manual that I c...

Answers: 1

DB2 for i statistics
answered 25-05-2021 17:27:52 -0400

Trying to gather statistics for a table in DB2 for i, and Denodo 8 is telling me "It is not possible to gather statistics from the system tables of the data source: Gathering statistics from system tables is not supported for this database". Has anyon...

Answers: 1

DB2

Exposing JSON data into API with specific parameter
answered 25-05-2021 15:01:46 -0400

I have this format as of now when I exposed my data into JSON format(the default one): { "name": "cp", "elements": [ { "reference": "beta5", "ordernumber_0": 8008, "product": "gaiytaqw", "what": "sagar", "applicat...

Answers: 5

#Rest API json api

insert operation through postman for multiple unique primary keys
answered 25-05-2021 08:02:07 -0400

Hi Team, issue 1: I have tried inserting record through postman for multiple unique primary key index but not able to achieve can you provide solution for that tried below way: col1:3170167-set as primary key at base view level col2:2107403-set as prim...

Answers: 3

Certificate expired
answered 25-05-2021 05:22:27 -0400

Hi there Can you please provide guidance, our certifcate has expired and I would like to apply the latest. Can you please advise the steps I need to follow. This is for a Window server running Denodo 7. Kaashief

Answers: 3

Data Source Setup Certification