Hi,
The problem that you are receiving is due to the Denodo Express License restriction, only MS Excel or MS Access are permitted when you create an ODBC data source.
Regarding the connection, the data source JDBC can be used to connect with SQL Server instead of ODBC in Denodo Express.
Hope this helps!