esProc

esProc is a professional structured computing tool, which is ready to use, built-in with SPL language easier to use than SQL. The SQL that is realized by using the advanced syntax and complex nesting of commercial database can be easily handled by SPL. The more complex data processing or query is, the more obvious the features of simple SPL syntax and clear steps are. You can observe the result for each step, and the calculation process can be controlled at will according to the result. It is especially suitable to solve the problem of order-related calculation, such as the typical problems in desktop data analysis: same period ratio, ratio compared to last period, relative interval data retrieving, ranking in groups, TopN in groups.

esProc can directly process the data files such as CSV, Excel, JSON and XML. After adding the jdbc driver, it can connect to various databases. After adding expansion, it can connect to various data sources such as MongoDB, Redis, ES and Hadoop. esProc is not only easy to use, but also easy to learn. People who are familiar with SQL and with basic programming skills can easily master it in a short time.