Thanks to the open framework of RedPrairie
tm MOCA
tm framework we have a few options when it comes to the clients that can access the MOCA Server. I wanted to compare the clients to see how they are different from each other. If there are features that I have missed, let me know so that I can put them here as well.
|
RedPrairie 2012 WinMSQL |
Lexedit |
Oracular MOCA Client 2012.1.0 |
Version |
2012.1.4 |
2.8.4.1 |
2012.1.0 |
Technology |
Microsoft |
Microsoft |
Pure Java |
Auto Complete SQL |
No |
Yes |
Yes |
Auto Complete MOCA Commands |
No |
Yes |
Yes |
Security - restrict access |
Yes |
No |
Yes |
Trace Viewer |
This one is much better than earlier versions |
Very nice trace viewer. Can serve as default trace viewer |
Very nice trace viewer. |
Explain SQL |
No |
Yes |
No |
Load CSV files on client |
No |
Yes |
Yes |
mload server files |
No |
No |
Yes |
Edit Server Files |
No |
No |
Yes. Offers security based on roles to disable for some users |
Search Source code |
No |
No |
Yes. Search files and code in database tables |
Compare two environments |
No |
No |
Yes |
Automatic Updates |
No |
Yes |
Yes |
Cost |
Comes with RedPrairie client |
Free - requires registration |
Free - no registration |
Company |
RedPrairie (www.redprairie.com) |
Orbital Services (www.lexedit.com) |
Oracular (www.oracular.com) |
Download From |
n/a |
www.lexedit.com |
autoupdate.oracular.com/mocaclient |
Here is the details for each feature:
Technology |
I do not see this as a really distinguishing feature unless you want to run Oracular MOCA Client on a mac or unix |
Security - Restrict Access |
This is an important feature. All of these tools basically provide the same capability as "Server Command Operations" - so if someone does not have that access, they should not be able to gain access via these tools as well.
Specifically the menu option SALSrvCmdOpr controls access to the standard "Server Command Operations" screen which allows a user to execute any MOCA command. Oracualar MOCA client will see if the user who is attempting to connect has this permission. If the user does not have this permission then they will not be allowed access to Oracular MOCA client as well |
Edit Server Files |
Often the system administrators do not like to give access to the server to edit source code. Oracular MOCA Client allows the developer to navigate to the files using MOCA protocol and update the source code. This is really nice for such situations. |
mload server files |
Same idea as above - if you do not have command line access to the db/data directory, Oracular MOCA Client allows you to navigate to the files, right click on them and load them via mload |
Search Source Code |
In Oracular MOCA Client, you can put in a regular expression - it will search through the source code tree on the server and find what you are looking for. It can also create a tree which tells what calls what. It can also search through algorithms and DDAs |
Compare two environments |
Oracular MOCA client allows you to point to two environments and compare the data . |
Some distinguishing features of each product are as follows:
RedPrairie WinmSQL |
It has come a long way since the earlier versions that really prompted folks to develop lexedit and oracular moca client
New version offers syntax highlighting via setup file
New version offers multiple connections
|
Lexedit |
This is the first "reaction" to how awful winmsql really was and it has been constantly improving. Some interesting features include:
Very nice overall feel - looks very mature
Tips
Integrates standard Windows concepts like customizable toolbar
Elaborate language setup - it views MSQL as one of many languages it can support
80 column guide is interesting to write code that is easily viewable on old terminals
|
Oracular MOCA Client |
This is more of a full development environment (IDE) rather than simply a replacement for RedPrairie WinMSQL:
Integrates with Orcular's change management
Web Clipboard (experimental). Idea is that you copy text to cloud and paste from cloud on another machine.
Robot development via groovy
Repository of commonly used scripts
Save current state in a named file
|
Saad really good posts...would appreciate if you had some posts from thefunctional side aswell
ReplyDeleteInvesting online has been a main source of income, that's why knowledge plays a very important role in humanity, you don't need to over work yourself for money.All you need is the right information, and you could build your own wealth from the comfort of your home! Binary trading is dependent on timely signals, assets or controlled strategies which when mastered increases chance of winning up to 90%-100% with trading. It’s possible to earn $10,000 to $20,000 trading weekly-monthly in cryptocurrency(bitcoin) investment, just get in contact with Mr Bernie Doran my broker. I had almost given up on everything about binary trading and never getting my lost funds back, till i met with him, with his help and guidance now i have my lost funds back to my bank account, gained more profit and I can now trade successfully with his profitable strategies and signals! Reach out to him on Gmail ( BERNIEDORANSIGNALS@GMAIL.COM ) , or his WhatsApp : +1(424)285-0682 for inquiries
DeleteI lost my job few months back and there was no way to get income for my family, things was so tough and I couldn’t get anything for my children, not until a met a recommendation on a page writing how Mr Bernie Doran helped a lady in getting a huge amount of profit every 6 working days on trading with his management
I got bored and wrote my own version of winmsql also. It is pure Java as well, tested by Jenkins. Having your own editor's source is great when you think "Hmmm, X would make a great feature." Good times.
ReplyDeleteWe upgraded WMS 4.2 version to WMS 2011.x and we have java 6 in our wms servers, the problem is Java recently released security vulnerblity in java 6 and recomended to upgrade java 6 to java 7, But we came to know that WMS 2011.x is not compatible with java 7 .What would be your suggetion on this case ?
ReplyDeletethank you this is very userfull for us.
ReplyDeleteoracular client supports ssl connections? it seems to be not working with the 2020 BY with ssl moca services. Could you please check it once?
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteI am working on a new client https://github.com/IkeRolfe/JdaTools/releases
ReplyDeletegive it a try and drop some feedback.
This a VERY early version.
Hey Saad,
ReplyDeleteGreat post, but there is a new MOCA client that needs to be added!
This new open source MOCA client is anchored in Visual Studio Code and leverages the Language Server Protocol.
https://github.com/mrglassdanny/vscode-moca-client
I've been using vscode-moca-client and it works perfectly AFAIK. I am new to MOCA and would be interested in an article that does a feature comparison with LextEdit. Thanks for the great info Saad! It's the best I've found!
ReplyDeleteAll thanks to Mr Anderson Carl for helping with my profits and making my fifth withdrawal possible. I'm here to share an amazing life changing opportunity with you. its called Bitcoin / Forex trading options. it is a highly lucrative business which can earn you as much as $2,570 in a week from an initial investment of just $200. I am living proof of this great business opportunity. If anyone is interested in trading on bitcoin or any cryptocurrency and want a successful trade without losing notify Mr Anderson Carl now on Whatsapp: +1(252)285-2093 Email: andersoncarlassettrade@gmail.com
ReplyDelete