|
| Iniciado por guest, 17,may. 2016 13:51 - 5 respuestas |
| |
| | | |
|
| |
| Publicado el 17,mayo 2016 - 13:51 |
Hi
I have a customer who are wanting some sales/performance data extracted from their HyperFileSQL Server DB, they are using another company to produce visuals and performance league charts to present this data, i thought i could create all the queries [WD21] then an ODBC datasource linking to their Hyperfile DB and they could use an Access DB but it only links tables not queries. I dont want to rewrite all the queries in access if i can help it, does anyone know a way around this, or a better solution?
Thanks
ISO |
| |
| |
| | | |
|
| | |
| |
| Publicado el 17,mayo 2016 - 13:55 |
Hi ISO,
Why don't you define HFSQL server side views or materialized views?
Available since V20 if I am correct.
For any external system they are approachable like regular tables.
Cheers,
Peter Holemans |
| |
| |
| | | |
|
| | |
| |
| Publicado el 17,mayo 2016 - 14:07 |
Hi,
or you can create a .net project with your query presented as global procedures or classes...
THe other company just has to link to your .net dll and use the methods
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 17,mayo 2016 - 14:09 |
Hi Peter,
That sounds interesting, Ive only just updated from v18 recently, and havent yet updated the HFSQL Server. I ll get it updated then look into it.
Many Thanks
ISO |
| |
| |
| | | |
|
| | |
| |
| Publicado el 17,mayo 2016 - 14:09 |
Hi again
or, depending on the situation, you can create a webservice REST (webdev awp page) or SOAP (windev) exposing your data...
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 17,mayo 2016 - 14:11 |
| Thanks Fabrice, the webservice might be an option. |
| |
| |
| | | |
|
| | | | |
| | |
|