Forum Discussion
using ODBC vs. HTML to connect to Denodo
I have a Denodo service which requires a parameter to be specified on the connection. A HTML connection string looks like this:
https://denodo.mycompany.com/path/ServiceIwantToAccess?MandatoryParam=XYZ
an ODBC-based connection looks like this:
let
Source = Denodo.Contents("DenodoODBC", null),
FOO_Database = Source{[Name="FOO",Kind="Database"]}[Data],
FOO_Schema = FOO_Database{[Name="FOO",Kind="Schema"]}[Data],
ServiceIwantToAccess_View = FOO_Schema{[Name="ServiceIwantToAccess",Kind="View"]}[Data]
in
ServiceIwantToAccess_View
I need to pass "MandatoryParam" to the FOO_Schema somehow, but can't find any syntax on it. I can't use SelectRows as that assumes you've got the table view already.
Hi Anonymous ,
You could try to use parameters to implement it.
- HTML
You need to add the entire website in the list.
- ODBC
You could change some values with the parameter you created, like the picture. (I used Excel file as the data source.)
Best Regards,
Xue
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- v-xuding-msft
Community Support
Hi Anonymous ,
You could try to use parameters to implement it.
- HTML
You need to add the entire website in the list.
- ODBC
You could change some values with the parameter you created, like the picture. (I used Excel file as the data source.)
Best Regards,
Xue
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.