Latest Activity

code

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

code

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.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver mssql.jdbcUrl=jdbc:sqlserver://sqlsrv- devtest.database.windows.net:1433;databaseName...

SQL Server SQL

code

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

code

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

code

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

code

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 Base view datetime Error SQL Server

code

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

code

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

code

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

code

Pass-through security for SQL Server data sources

Currently we are using LDAP and Active Directory to allow users to authenticate to data sources in Denodo. We would like the capability to ignore this and use pass-through authentication, based on SQL Server permissions. In other words, if a user has W...

SQL Server Active Directory Denodo_SQL_Server pass-through