Latest Activity
Our DBA claims that the Denodo view is causing DEADLOCKs on the SQL Server. They recommended us to pass the query to SQL Server with the "WITH (NOLOCK)" option. Is this possible with Denodo views? If yes, please provide specific example. Btw, the SQL...
sql server deadlock nolock deadlock read uncommitted sql server
This is the errror I am receiving. Exception in thread "main" java.lang.IllegalArgumentException: Missing configuration parameter 'encoding' at com.denodo.connect.testing.Configuration.get(Configuration.java:106) at com.denodo.connect.testing.Configur...
I am unable to configure SQL Server as a Data Source using the "Microsoft SQL Server 2016 (MS Driver)" as the Database Adapater where the user is a Windows Authenticated user (i.e., not a SQL Server Authenticated user) but without having to setup Kerbe...
hello, how do I connect sql server using integratedservices; and compare with vql using Denodo Testing Tool. Please help!! Please provide link if there is documentation. When I tried I keep getting java configuration 'encoding' error. I am able to tes...
Running Denodo Express VDP on my laptop. Got SQL Express installed and loaded with AdventureWorks DW 2014 data. What would be the URI if this is the case? I am trying to connect via JDBC using the following URI: jdbc:jtds:sqlserver://IA-EME/SQLEXPRESS...
I want to create the jason and SQL base view in Denodo 7.0. When i go to the sources I see only Excel and LDAP option. Other option is there but not able to use.
Hi, can we use Denodo to write (insert records, delete recors, modify) the results of a given query to a data base? (i.e i would like to store the results of a query into a SQL data base) Many thanks,
Hi, I would like to add my experience with Denodo 5.5 in Windows 2012 64 bit. I had to copy ntlmauth.dll to %DENODO_HOME%/jre/bin and restart the server instead of %SYSTEMROOT%/system32. The latter wouldn't work and raised a "SSO Failed: Native SS...
Related to: Accessing MS SQL Server using Windows Authentication
According to https://community.denodo.com/answers/question/details?questionId=90670000000XcjoAAC&title=Can+denodo+Support+to+recursive+queries+%3F Denodo doesn't support recursive query directly. I am trying to create a base view through the method...
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...