Q&A

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

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

Display Date/Timestamp in a Specific Pattern
answered 17-06-2021 14:48:53 -0400

Hello! We have countless tables in Oracle that contains columns of DATE datatype although in Denodo, they are set as TIMESTAMP (i see that the datatype DATE is already depracated). In line with that, could you kindly help us know what setting could we...

Answers: 3