DaVinci visualization system deployment, installation and simple use

Time:2021-11-27

DaVinci is a popular domestic open source BI system with perfect functions and good visualization effects. The main way to obtain data is to create a data view by writing SQL to display various charts.

DaVinci is dedicated to providing one-stop data visualization solutions for business personnel / data engineers / data analysts / data scientists. It can be used independently as a public cloud / private cloud or integrated into a third-party system as a visualization plug-in. Users can meet a variety of data visualization needs by simply configuring on the visualization UI, and support visualization functions such as advanced interaction / industry analysis / pattern exploration / social intelligence.
GitHub address:https://github.com/edp963/davinci

DaVinci visualization system deployment, installation and simple use

DaVinci login page

DaVinci visualization system deployment, installation and simple use

Danvinci simple drag demo.gif

Installation deployment

Based on Ubuntu 16.04 LTS, DaVinci 0.3.1, chrome and chromedriver versions 89.0.4389.114

Initialize MySQL database

First, install your own MySQL database, which is recommended to be nameddavinciAnd then execute on this databasedavinci0.3.1.zipCompressed package (the compressed package can be on the official website or below)Download installation resourcesOf the bin directory found in)davinci.sqlFile to create the corresponding table.

Download installation resources

Access this addresshttps://github.com/KANLON/picture-bed/tree/main/resource/artical/Davinci%E5%8F%AF%E8%A7%86%E5%8C%96%E7%B3%BB%E7%BB%9F%E9%83%A8%E7%BD%B2%E5%AE%89%E8%A3%85%E5%8F%8A%E7%AE%80%E5%8D%95%E4%BD%BF%E7%94%A8-davinci-install-packageThe GitHub warehouse Directory:

  1. chromedriver_ Linux64.zip (this is the chrome driver package of the screenshot)
  2. DaVinci 0.3.1.zip (this is DaVinci’s installation package)
  3. google-chrome-stable_ current_ Amd64.deb (this is the Chrome browser for Ubuntu)

These are three files on your own server/data/services/davinci-serviceDirectory

You can directly execute the following commands. This is downloaded directly from GitHub. If the speed is slow, it can be downloaded automatically and manually. If you fail, you can try several more times.

Sudo MKDIR - VP / data / services / DaVinci Service & & CD / data / services / DaVinci service / & & echo "download application. YML"  && sudo curl -LO ' https://raw.githubusercontent.com/KANLON/picture-bed/main/resource/artical/Davinci%E5%8F%AF%E8%A7%86%E5%8C%96%E7%B3%BB%E7%BB%9F%E9%83%A8%E7%BD%B2%E5%AE%89%E8%A3%85%E5%8F%8A%E7%AE%80%E5%8D%95%E4%BD%BF%E7%94%A8 -DaVinci install package / application. YML '& & echo "download chromedriver"  && sudo curl -LO ' https://github.com/KANLON/picture-bed/raw/main/resource/artical/Davinci%E5%8F%AF%E8%A7%86%E5%8C%96%E7%B3%BB%E7%BB%9F%E9%83%A8%E7%BD%B2%E5%AE%89%E8%A3%85%E5%8F%8A%E7%AE%80%E5%8D%95%E4%BD%BF%E7%94%A8 -davinci-install-package/chromedriver_ Linux64. Zip '& & echo "download DaVinci installation package" & & sudo curl - Lo' https://github.com/KANLON/picture-bed/raw/main/resource/artical/Davinci%E5%8F%AF%E8%A7%86%E5%8C%96%E7%B3%BB%E7%BB%9F%E9%83%A8%E7%BD%B2%E5%AE%89%E8%A3%85%E5%8F%8A%E7%AE%80%E5%8D%95%E4%BD%BF%E7%94%A8 -DaVinci install package / DaVinci 0.3.1. Zip '& & echo "download the chrome installation package"  && sudo curl -LO ' https://github.com/KANLON/picture-bed/raw/main/resource/artical/Davinci%E5%8F%AF%E8%A7%86%E5%8C%96%E7%B3%BB%E7%BB%9F%E9%83%A8%E7%BD%B2%E5%AE%89%E8%A3%85%E5%8F%8A%E7%AE%80%E5%8D%95%E4%BD%BF%E7%94%A8 -davinci-install-package/google-chrome-stable_ current_ AMD64. DEB '& & echo "download CSV template"  && sudo curl -LO ' https://raw.githubusercontent.com/KANLON/picture-bed/main/resource/artical/Davinci%E5%8F%AF%E8%A7%86%E5%8C%96%E7%B3%BB%E7%BB%9F%E9%83%A8%E7%BD%B2%E5%AE%89%E8%A3%85%E5%8F%8A%E7%AE%80%E5%8D%95%E4%BD%BF%E7%94%A8 -davinci-install-package/%E6%B5%8B%E8%AF%95davinci%E7%B3%BB%E7%BB%9F%E7%9A%84csv%E6%96%87%E4%BB%B6.csv'

Download and modify the corresponding application.yml configuration file

Access the GitHub repository for thishttps://github.com/KANLON/picture-bed/tree/main/resource/artical/Davinci%E5%8F%AF%E8%A7%86%E5%8C%96%E7%B3%BB%E7%BB%9F%E9%83%A8%E7%BD%B2%E5%AE%89%E8%A3%85%E5%8F%8A%E7%AE%80%E5%8D%95%E4%BD%BF%E7%94%A8-davinci-install-packageDownload getapplication.ymlFile and modify theMysql database(note here that some parameters behind the JDBC link cannot be deleted) andMail configuration, and then put the configuration file into/data/services/davinci-serviceDirectory (mainly to facilitate the execution of later scripts. You can use the directory separately, but you need to modify the following script again)

set up script

Complete the above database installation and installation resource download, and then switch torootAccount, execute the script to install and startdavincisystem

Echo "copy installation package"
mkdir -pv /data/services/davinci-service
cd /data/services/davinci-service
cp /data/davinci-install-package/davinci0.3.1.zip  /data/services/davinci-service
unzip davinci0.3.1.zip 
mv davinci-assembly_0.3.1-0.3.1-SNAPSHOT-dist-rc davinci0.3.1
Echo "copy configuration"
/bin/cp -rf /data/davinci-install-package/application.yml /data/services/davinci-service/davinci0.3.1/config
export DAVINCI3_HOME=/data/services/davinci-service/davinci0.3.1
Echo "convenient screenshot of installing chrome driver"
mkdir -pv /data/zhangcanlong
sudo apt-get update
cd /data/zhangcanlong
Echo "install chorme"
cp /data/davinci-install-package/google-chrome-stable_current_amd64.deb ./
sudo dpkg -i google-chrome-stable_current_amd64.deb
Echo "force installation of all missing dependencies"
sudo apt-get install -f -y
cp /data/davinci-install-package/chromedriver_linux64.zip /data/zhangcanlong/
unzip /data/zhangcanlong/chromedriver_linux64.zip 
cp /data/zhangcanlong/chromedriver /usr/bin/
chromedriver --version
Echo "start service"
/data/services/davinci-service/davinci0.3.1/bin/start-server.sh

If you compress a command like this, you can download the above installation package resources first, and then run the following installation command to complete the installation of DaVinci

Echo "copy installation package" & & MKDIR - PV / data / services / DaVinci Service & & CD / data / services / DaVinci Service & & CP / data / DaVinci install package / DaVinci 0.3.1.zip / data / services / DaVinci Service & & unzip DaVinci 0.3.1.zip & & MV DaVinci assembly_ 0.3.1-0.3.1-snapshot dist RC davinci0.3.1 & & echo "copy configuration" & & / bin / CP - RF / data / DaVinci install package / application.yml / data / services / DaVinci service / davinci0.3.1/config & & export davinci3_ Home = / data / services / DaVinci service / DaVinci 0.3.1 & & echo "convenient screenshot of installing chrome driver" & & MKDIR - PV / data / zhangcanlong & & sudo apt get update & & CD / data / zhangcanlong & & echo "install chord" & & CP / data / DaVinci install package / Google Chrome stable_ current_ amd64.deb ./ && sudo dpkg -i google-chrome-stable_ current_ Amd64.deb & & echo "force installation of all missing dependencies" & & sudo apt get install - F - Y & & CP / data / DaVinci install package / chromedriver_ linux64.zip /data/zhangcanlong/ && unzip /data/zhangcanlong/chromedriver_ Linux64.zip & & CP / data / zhangcanlong / chromedriver / usr / bin / & & chromedriver -- version & & echo "start service" & & / data / services / DaVinci service / davinci0.3.1/bin/start-server.sh

After the command is executed, wait a few minutes, and the following screenshot shows that the startup is successful, and then accesshttps://127.0.0.1:8080Can accessdavincisystem

DaVinci visualization system deployment, installation and simple use

Danvinci startup complete

Simple use

After the installation is complete, open the login pagelocalhost:8080, enter the following default account and password to log in successfully
User name: guest, password: 123456

Then, create a data source – > create a data view – > create a visual component (widget)

Note that the data created by DaVinci is written based on SQL. Before creating, you need to understand some common SQL syntax

Based on visualization components, it can form a dashboard or a large display

In addition, you can regularly send the created visualization components to the e-mail (schedule) through screenshots or excel

There is no problem with basically following the operation of the official documents. The instructions in the official documents are relatively concise and clear

Official document address created by davinic:https://edp963.github.io/davinci/docs/zh/1.2-quick_start

Let me briefly show you the self-made tutorial moving picture here. If you don’t understand it, you can take a look at the tutorial in the official document

Tutorial video link:https://www.bilibili.com/video/BV1AU4y1b7Ms

summary

DaVinci is currently a popular open source reporting system in China. It was relatively simple to install it at the beginning, because it was written in Java. I am familiar with it, but I encountered a small problem, that is, to install the screenshot driver. It has been a long time. Of course, if docker is used for deployment, it will be much faster, but due to the service limitations of our company, it is troublesome to download other people’s images for deployment. We can only use the images we already have, so we can only use Linux system scripts to deploy from the head.

After talking about the deployment, let’s talk about its experience. DaVinci feels that the interaction is very good, and all kinds of visual interaction are very good. In addition, there are two ways to compose a page: one is in the form of ordinary report, which can only put data components; The other is a special large screen page, which can not only put some data components, but also drag and drop some text, date, video and other components separately, which is more personalized. However, the data can only be generated by SQL. There is no simple interface to automatically generate SQL according to the table for query. There is a certain threshold for users who do not understand the syntax of SQL, and there is no function of data alarm. Only when the data float is greater than or less, can email or SMS alarm be sent. At present, DaVinci only supports timed task alarm, There is no alarm combined with the data fluctuation.

In general, DaVinci is a very good open source reporting system at present, which is applicable to most companies. Moreover, it is developed in Java as the back-end, and it is also very convenient to transform.

reference resources

  1. DaVinci official installation documenthttps://edp963.github.io/davinci/docs/zh/1.1-deployment

Essay Essay
It seems that I haven’t updated it for a long time. I have dropped a lot of goals every week. This article has been written for a long time, mainly to get a video tutorial. I feel I should study the video clip well. Later, we will update the deployment and simple demonstration of other domestic open source reporting systems. Please pay attention!

I’m curdboys, oneOften doing curd, not just satisfied with curdProgram ape.