Latest Activity


Base view from query using temp tables (SQL server)

I can't seem to create a base view from a query that uses a temp table. From looking around online/on the forums, this seems like an intentional limitation due to the session-limited lifetime of temporary tables. However, this seems like a bad limita...

Base view baseview created from query Global Temp Table Create Base View Baseview SQL Server INDEX Temp Tables


Connecting to Denodo

How do I connect to Denodo from diferent sources ? e.g Extracting Denodo Data from Excel, SQL Server, DBP, power bi, tableau and other consumers

Denodo Excel Add-In sql server DataSource


Connecting MS SQL Server through Denodo Testing tool throws error.

I'm trying to establish a connection to SQL Server using the below properties through config file. mssql.jdbcUrl=jdbc:sqlserver://sqlsrv-;databaseName...

SQL Server SQL


Connecting to SQL Server using Windows Authentication with an SA Account

I have credentials for a QA SQL Sever enviroment but it requires Windows Authentication and you have to sign in as the SA account in order to access the DB. Is there a way to force this using the JDBC string? Or - do I need to do some type of authent...

JDBC SQL Server password authentication


Connection with sql server database

Hi Team, I have to read one view from sql server database.How we can set up connection with sql database and can access view. Thanks in advance.

SQL Server


Need help creating a Base View from a SQL Server Stored Procedure

I have a SQL Stored Procedure which I will use to create a Base View in Denodo. The issue is that the Stored Procedure takes an User-Defined Table type as input parameter. If I select the SP and click Create from Selected I get an error that says the ...

Base view Create Base View Stored Procedure SQL Server


SQL Server date datatypes error in conversion for base views

¬°Hello dear Gurus! I'm facing an odd issue for which I found no way to solve it. Source Server DataBase is SQLServer 2016. SQL Server has Collation SQL_Latin1_General_CP1_CI_AS Conflicting datatypes: datetime2, smalldatetyme Here's dataty...

Date Conversion datetime Base view Error SQL Server


SQL Server date conversion error in BaseView

Hello Support Team We are having a big stopper in a project with an odd issue for which we can't find a way to solve it. Technical data is and Consultant has already raised the same question: Source Server DataBase is SQLServer 2016. SQL Server...

Date Conversion Base view VDP 7.0 SQL Server


Unable to connect to Azure SQL because of TCP/IP

Hi, I have been unable to connect to my Azure SQL database that i'm running on Azure VM. I am using Denodo Express to tryout the product. It keeps returning the "Unable to establish connection: The TCP/IP connection to the host, port 1433 has failed",...

Azure Cloud TCP/IP SQL Server


Not able to connect to SQL Server using an Active Directory account

Hello, I am using Denodo 6.0 In the VDP tool, I am trying to connect to a SQL Server database using a Active Directory account (domain \ account name). However, when I test the connection, the tool is telling me: 'Unable to establish Connection. Login ...

SQL Server Active Directory