Latest Activity
Hi there, I am looking for an official guide to install the new Denodo v9 on a kubernetes cluster. A bit of context: We have a kubernetes cluster where we want to install the v9. We are using an external mssql server to store the metadata. Dri...
Solution Manager Container Denodo v9 external metadata database MSSQL Kubernetes
I'm trying to use a CTE MS SQL query to flatten a dataset of employees and their managers. After looking through mutiple articles in the support section I was hoping I could use "create base view from query". This is giving an error saying - "Incorrect...
Hello, When switching from MSSQL "standard" cache load, to a bulk-load using BCP, what are the best practices and recommendations regarding the SQL Server database ? The User Manuals (here) are quite laconic about that. Best regards
I have designed a VDP job in schdeuler. I have two three columns in the MSSQL table and all three of them are part of primary column. In the exporter section of scheduler job I have set the config as below Delete table contents to false update tupl...
Select * into #Temp from xyz Select * from #Temp When I run this Script using Create Base view from Query, I am getting the below error message. Error: Received exception with message 'Incorrect syntax near the keyword 'into' MS SQL Server 2014 JDBC...
Related to: Best Practices for Migrating SQL queries to Denodo VQL
Receiving the following error when trying to establish a Denodo 7 connection to MS SQL express (Windows 10, MS SQL version 14.0.2002.14): Unable to establish connection: Cannot open database "MAXXPHASE" requested by the login. The login failed. ClientC...
Related to: Accessing MS SQL Server using Windows Authentication
Hi, I need to connect to MS Sql Server 2014. Using username and password is working fine for my local database. But I need to connect it to a database which is SSPI authenticated. Denodo VDP is giving me option to create connection using string and so...
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...
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...
Is there a build function like "Left" or "Right" from MSSQL in Denodo? For example, a example string such as "ABCD". left ('ABCD', 1) will return 'A' right ('ABCD', 2) will return 'CD'