Home / Q&A / All Questions

Q&A

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

JSON exposed data discrepancy
answered 22-06-2021 16:17:20 -0400

Hi, I have exposed data into JSOn from Denodo API, the source system from which denodo is getting data is in form like this,it is in two line India - 123456; INDIA When exposed this data from denodo into JSOn format using API I am getting output: Ind...

Answers: 1

JSON

Excel Data Source: Is it possible to create a view on a directory containing the excel files?
answered 22-06-2021 10:21:15 -0400

Is it possible to create an excel data source based on a directory of files versus an individual file? If so, how would you configure this?

Answers: 3

Excel Data Source Mulitple Files

Dynamic column names for Pivot
answered 22-06-2021 08:53:04 -0400

Hi Team, I have a requriement where in i need to PIVOT rows in to column where the column name is not static. While reading I could find that theres a solution to achieve this. Can someone please give me a detail step by step solution for this? Cre...

Answers: 1

#pivot

Stopping job at particular time
answered 22-06-2021 06:38:00 -0400

Can we stop the job which is running for more than an hour? or at a particular time?

Answers: 1

Schedule jobs

Denodo Application Services running on Multiple nodes
answered 22-06-2021 05:58:36 -0400

any one have implemented runnign application services like, scheduler, VDP, ARN, ARn Index, Data Catalog, running on multiple nodes with HA failover Over. Today i see the derby database have been local any one have used sqlserver

Answers: 1

Data precision
answered 21-06-2021 11:12:50 -0400

Hi team, I need help with few questions listed below: I am connecting to SQL server and for the numeric(19,8) datatype the decical value is lost at denodo side. How to maintain the decimal precision at denodo side? SQL side uptp 8 decimal places – 5500...

Answers: 3

VCS Management Disabled
answered 18-06-2021 13:54:30 -0400

Hi, Could you please help me how to enable the "VCS Management" option in Virtual DataPort Server Configuration. currently it showing disabled. Where I can find the diff viewer tool to compare the content of conflicting elements when performing chec...

Answers: 1

version control system Administration Tool Version Control

timestamp datatype in denodo
answered 18-06-2021 05:55:33 -0400

Hi team, As per my understanding timestamp datatype should return data upto milisec: TIMESTAMP Timestamp without a time zone (year, month, day, hour, minute, second and fraction of second with nanosecond precision) When i am creating a base view and t...

Answers: 8

Accessing remote Excel file
answered 18-06-2021 05:09:40 -0400

Hi Team, We are using denodo 8.0 version. I have a requirement to connect to a excel file which is not available within denodo server. It can be on any other share drive or any other server. How to conenct to this excel file? When i make a excel conne...

Answers: 4

@excel file

Denodo to AWS
answered 17-06-2021 23:32:10 -0400

Hi All, I need to bring Dennodo base view data into a AWS S3 bucket. This can be done through a Glue job that connects to Denodo using the JDBC url and stores the data into the required S3 bucket. However the connection to Denodo from AWS is not gett...

Answers: 3

AWS