An easy-to-use BI server built for SQL lovers. Power data analysis
An easy-to-use BI server built for SQL lovers. Power data analysis in SQL and gain faster business insights. Platform independent web application. Single JAR file + Single SQLite DB file. Get up and running in 5 minutes. PostgreSQL, Oracle, SQLServer, MySQL, Elasticsearch... You name it. No ETLs, no generated SQL, polish your own SQLquery to transform data.
Project to dinamically export queries to Excel, PDF and Jasper Viewer
Project to execute SQL queries from an SQL file. Once the file is loaded you can export the result to an Excel or PDF file or to view it with Jasper Viewer. The file loaded can be seen in a textarea. This textarea is editable so that you can edit your query at runtime and export it. For the time being you can't include parameters to the query. The best of this project is that you really don't know how many columns of the table of your database are and this project dinamically does this.
SITools2 is a new CNES generic tool performed by a joint effort between CNES and scientific laboratories. The aim of SITools is to provide a self-manageable data access layer deployed on already existing scientific laboratory databases.