Q&A

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

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

If Cache Scheduler fails can it call data source directly using FULL cache mode?
answered 16-06-2021 22:59:57 -0400

Hello, I have one view and full cache mode is applied on it and it is scheduled to run everyday on 8PM, so in full cache mode view will never hit datasource, SUppose scheduler went down due to any reason, now my question is: Q. Can we call data sourc...

Answers: 1

cache

Symbolic link visible as a file and not folder
answered 16-06-2021 12:50:06 -0400

I created the symbolic link and that is visible as a file and not a folder. Can you please explain if something is wrong here? Also i need to use double quotes around the remote network folder. " mklink /d c:\Tempsymboliclink "\server\Parameter" Secon...

Answers: 2

@symbolic link

How to fetch execution time for Denodo query by python
answered 16-06-2021 08:24:13 -0400

Hi team, Do we have some way about how to fetch execution time for Denodo query by python script? Or do we have some pre-defined store procedure can be used for this property, we have the requirement to auto-collect the query running time. Thanks.

Answers: 1

Denodo python query execution time