Latest Activity

code

Datatype Issue while creating a base view from SQL Server

I have a table in Sql server with a column of date datatype. For this instance : Create table table_name ( dob date ) ; I have created base view on top of this table. But in base view, datatype of dob as text datatype in denodo which is not expected...

DENODO MSSQL SQLServer sql server datatypes Date

code

ODBC connection issue

I am trying to connect sql server 2014. I installed ODBC drivers provided from denodo but connection issue as below. What is the fix for this?? "Unable to establish connection: server closed the connection unexpectedly This probably means the server t...

ODBC SQL Server

code

How to connect the Denodo Server to the SQL Server who supports SSL?

The Denodo Server is trying to connect to the Client’s SQL Server using JDBC. But, the SQL SERVER forces SSL encryption. The SSL encryption can not be turned off on the client’s server so turning of SSL is not an option. In that case, how to connect th...

SQL Server SSL

code

How to connect the Denodo Server to the Microsoft SQL Server who supports SSL?

The Denodo Server is trying to connect to the Microsoft SQL Server using JDBC. But, the MS SQL SERVER forces SSL encryption. The SSL encryption can not be turned off on the the server so turning off SSL is not an option. In that case, how to connect th...

SQL Server MSSQL SSL SQLServer

code

Denodo connect to SQL server -- cannot log in -- troubleshoot

I am using JTDS SQL server 2012 driver, jdbc:jtds:sqlserver://server:port/database; useNTLMv2=true; domain=domainname after I input login and password, I got error message " Unable to estable connection: Login Failed for user xxxx". then I went to VP...

SQL Server

code

Denodo connect to SQL server -- cannot log in

I am using JTDS SQL server 2012 driver, jdbc:jtds:sqlserver://server:port/database; useNTLMv2=true; domain=domainname after I input login and password, I got error message " Unable to estable connection: Login Failed for user xxxx". then I went to VP...

SQL Server

code

Caching Service Views

There are 14 Service Views in my database which gives data from 2011 - 2018 (joining different combinedviews). We created partial service views for each of the service view by giving a where condition inside the Partial service view (less than 2016 and...

cache DENODO Denodo Scheduler 6.0 SQL Server

code

Unable to cache some views

I am trying to cache on Service Views Layer (14 Service Views). In the scheduler, I created VDPCahce jobs for every individual service view. After starting those jobs, I started the monitoring tool to see the status of caching. After 3 hours, 6 of the ...

cache DENODO denodo scheduler SQL Server

code

Keep view names to cached tables

When I am caching the views, some numbering is adding to the table names in the cache database. I want just the view names to be kept for the tables in the cache databse. Is this possible. If yes, please let me know how can I get this done. Thanks, Sa...

DENODO Denodo Scheduler 6.0 SQL Server

code

Avoid deleting the cached data at the time of deployment to upper environments

We have some views created in the local environment and when we deploy it the upper environment, we cache the views. So, every time we do a deployment we turn the cache back on all the views. This is making the tables which are cached previously in the...

cache DENODO SQL Server deploy