Wed Aug 10, 2022 10:37 am
Login Register Lost Password? Contact Us

Please Note: The HPCC Systems forums are moving to Stack Overflow. We invite you to post your questions on Stack Overflow utilizing the tag hpcc-ecl (https://stackoverflow.com/search?tab=newest&q=hpcc-ecl). This legacy forum will be active and monitored during our transition to Stack Overflow but will become read only beginning September 1, 2022.



WsSql user friendly GUI interface

Questions around writing code and queries

Thu Jan 13, 2022 12:43 am Change Time Zone

Hi,
Is there any user-friendly interface to use with wssql? (for a non-developer type of user)
The default one, on port 8510 is a bit basic.
For example, as far as I could test, it returns results in a raw XML format (as opposed to the WsECL that shows a pretty nice table)

I understand that the feature is mainly meant to be used programmatically, but perhaps someone can recommend a way of working with it in a more interactive way with some external tool like the ones that exist for relational databases, that for example presents the results as a table, and allows to export the resultset as a csv, or other kind of flat-file.

Or any kind of GUI that allows accessing the end-point and retrieving the results in a graphical way.
Thank you!
rfernandez2007
 
Posts: 25
Joined: Mon Nov 29, 2021 2:40 pm

Tue Jan 18, 2022 2:03 pm Change Time Zone

Hi, since the WsSQL jobs are processed as ECL, there should be a resulting workunit you can access via ECLWatch. The WsSQL result should report the Workunit ID which you can use to view the results via the ECLWatch tools. Thanks.
rodrigo.pastrana
 
Posts: 29
Joined: Tue Jun 10, 2014 2:19 pm

Tue Jan 18, 2022 2:28 pm Change Time Zone

Hi Rodrigo,
Nice workaround. I'll keep it in mind.
Thank you very much!!
Warm Regards
rfernandez2007
 
Posts: 25
Joined: Mon Nov 29, 2021 2:40 pm

Wed Jan 19, 2022 2:04 pm Change Time Zone

Hi, I'm glad we could help. Thanks for posting, and definitely let us know if you have any other question/concern. Rodrigo.
rodrigo.pastrana
 
Posts: 29
Joined: Tue Jun 10, 2014 2:19 pm


Return to Programming

Who is online

Users browsing this forum: No registered users and 1 guest

cron