I. Project Introduction

DataGear is a data management and visual analysis platform, developed using Java language, using browser/server architecture, supporting a variety of databases, the main functions include data management, SQL workbench, data import/export, data set management, chart management, kanban management, etc.

The system characteristics

  • Managed database drivers: Administrators can add database drivers using the driver management function to connect to a new database without restarting the database.
  • Parameterized data sets: Write dynamic SQL statement data sets, add parameters to them, and build interactive charts.
  • Multi-source aggregate chart: A chart can add data sets from multiple sources to aggregate data from different sources into the same chart.
  • Plug-in chart types: Each type of chart is supported by a large number of built-in chart plug-ins. Administrators can also upload custom chart plug-ins to enrich the system chart types.
  • Template Kanban definition: Kanban uses a native HTML page as a template, can be freely edited, bound, asynchronously loaded charts, and can import any HTML page as a kanban.

Two, function introduction

2.1 the kanban

Such data kanban should be the content leaders in the era of big data are more willing to see!

Chart 2.2

Rich chart types to meet a variety of demand scenarios.


2.3 Data Management

Supports the management of multiple data sources. The system provides drivers for MySQL, Oracle, PostgreSQL, and SQL Server databases by default, and supports customized extended data sources.

2.4 SQL Workbench

Same as other database visualization tools.

2.5 Data Import

Data import supports four types: Csv,Json,Sql, and Excel.

2.6 Data Export

Data export also supports four types: Csv,Json,Sql and Excel.

Iii. Running projects

3.1 Installation Package Running

The premise

  • 1. InstallJre1.8 +Running environment, the JDK’s official website to download address: https://www.oracle.com/java/technologies/javase-downloads.html
  • 2.DataGearOfficial website to download the latest installation package, the website address: http://www.datagear.tech/

run

1. After the package is decompressed, an installation package named datagear-* is generated.In 2.windowsDouble-click on the environmentstartup.batCan run if yesLinuxEnvironment is runningstartup.shCan. The console logs are as follows:

D: \ Downloads \ datagear, version 1.8.1 - > Java - cp lib \ datagear - webappembd -, version 1.8.1. Jar; Lib \ javax.mail servlet - 3.0.0. V201112011016. Jar; Lib \ jetty - all - 8.1.22. V20160922. Jar; Lib \ log4j - 1.2.17. Jar; Lib \ slf4j - API - 1.7.9. Jar; Lib \ slf4j - log4j12-1.7.9. Jar org. Datagear. Webappembd. App-----------------------------------------
[2020-06-21 20:40:43] starting...
-----------------------------------------
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in[the jar file: / C: / Users/Administrator/AppData/Local/Temp/jetty - 0.0.0.0-50401 - datagear - webapp -, version 1.8.1. War -_ - any - / webapp/WEB - INF . / lib/slf4j - log4j12-1.7.9 jar! / org/slf4j/impl/StaticLoggerBinder class]SLF4J: Found binding in[the jar file: / D: / Downloads/datagear -, version 1.8.1 / lib/slf4j - log4j12-1.7.9. Jar! / org/slf4j/impl/StaticLoggerBinder class]SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] ----------------------------------------- [2020-06-21 20:40:57] starting [OK] ----------------------------------------- Copy the code

3. Visit http://localhost:50401

3.2 Source package operation

Download the project

Use the gitBash command to download the project

git clone https://gitee.com/datagear/datagear.git
Copy the code

Import the project into the development tool Idea, which automatically downloads dependencies.

Package run project

useMavenTools package projects in two ways: 1. UseIdeabuilt-inMavenThe plug-in build project looks like this:2. Open the cli in the root directory of the project and run the following command:

mvn clean package -DskipTests # Skip unit tests
Copy the code

Run the project

cd datagear-webappembd/target/datagear-x
startup.bat Windows environment startup command
./startup.sh #Linux environment startup command
shutdown.sh ##Linux environment stop command
Copy the code

Four, the last

Through the data directly generate different types of charts, and finally complete the function of data kanban. Convenience and simplicity. This data management and visualization analysis project, very practical. My article is mainly application based, if you are also interested in the project source code, we discuss and enhance together!

Restless ape man
Continuous technology sharing!