Latest Activity

code

Data precision

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...

code

VCS Management Disabled

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...

code

timestamp datatype in denodo

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...

code

Accessing remote Excel file

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...

code

Denodo to AWS

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...

AWS
code

Display Date/Timestamp in a Specific Pattern

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...

code

If Cache Scheduler fails can it call data source directly using FULL cache mode?

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...

code

Symbolic link visible as a file and not folder

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...

code

How to fetch execution time for Denodo query by python

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.

code

Azure Denodo database with Direct query Power BI

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...