Q&A

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

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

Azure Denodo database with Direct query Power BI
answered 15-06-2021 07:03:13 -0400

Hi, I am looking solution to connect Denodo database with Power BI direct query method. I am able to connect Power BI desktop with Denodo database using ODBC connection but unable to view the content into Power BI service. I am connecting Power BI de...

Answers: 1

Azure #powerBI connection #Denodo-PowerBI LDAP #powerBI connection #Denodo-PowerBI #reportserver

GraphQL service for Express Edition?
answered 15-06-2021 05:04:23 -0400

Hi, I was trying to test out GraphQL service on Denodo Express edition, and followed the official documentation but run into the issues. If I try to go to this link - SERVERIP:9090/denodo-graphql-service/graphql/admin , I receive the following error ...

Answers: 1