You can translate the question and the replies:

Can Denodo support use MSSQL Function

Now we only use Denodo to create base view from query or create store procedure. But now we want to use Functions from MSSQL, can Denodo support that? because current cannot see the Functions in Denono.
Function MSSQL
user
01-06-2015 05:00:31 -0400

1 Answer

Hi, When you create a view from query, you can use MS SQL functions in the query. This SQL query has to use the syntax of the queried database and not the syntax of Virtual DataPort. Check out the section ‘Creating JDBC/ODBC Base Views from SQL Queries’ in the ‘Virtual DataPort Administration Guide’ to know more about this. In addition to that, Denodo provides an extensible set of functions which you can see from the Help > Functions List option. Hope this helps.
Denodo Team
02-06-2015 07:34:34 -0400
You must sign in to add an answer. If you do not have an account, you can register here