Installation deployment for SMARTBI

Source: Internet
Author: User
Tags knowledge base port number tomcat tomcat server oracle database
first, the system environment requirements


recommended requirements for client systems



Second, manually install the deployment on the server Smartbi.war

The complete process for manually installing configuration Smartbi using the server app package Smartbi.war is as follows:

2.1 Application License Smartbi-license.xml

The following figure:

2.2. Create a knowledge base manually

Create the database smartbirepository in MySQL and grant the database authorization to the user

GRANT all privileges The smartbirepository.* toroot@localhost identified by ' root '. Remember address localhost port number 3306 user name root password root

If the Oracle database is created database create Tablespace + space name datafile ' c:\class.dbf ' (storage path) size 50mautoextend on. Create permissions Grant Connect, resource, DBA to + username.

2.3. Increase the database driver

1) Clear the other versions of the database driver (if any) that already exist in the <smartbi>\tomcat\webapps\smartbi\web-inf\lib directory.

2) Add the database driver files (Mysql.jar) that are used on the current project to the <smartbi>\tomcat\webapps\smartbi\web-inf\lib directory.

2.4. Deploy the Smartbi.war to the server

Because the java-home is already well-equipped so it is not configured, the Windows system simply adds the Java virtual machine configuration in the catalina.bat/catalina.sh: set java_opts=%java_opts%- dfile.encoding=gbk-duser.region=cn-duser.language=zh-djava.awt.headless=true–xms1024m–xmx9000m. Then copy the Smartbi.war package to the <tomcat>\webapps directory and run <tomcat>\bin\startup.bat to start the Tomcat server. Log into the HTTP://LOCALHOST:8080/SMARTBI data analysis page as shown in the following figure:


Upload license file: First " select " The local license file, and then click on the " upload " button to confirm that the selected files are correctly uploaded to the server, click on the test Knowledge Base connection, show success explained the previous success.


and then restart.

Enter the SMARTBI main interface: Http://localhost:8080/smartbi as shown in the following image: Backing up the database

Also fill in the fill in the test knowledge base, if the display is successful restart the service. Start successfully as shown in the figure


Log in again Http://localhost:8080/smartbi enter the homepage login Admin Password Manager


Adding an Oracle data source JDBC:ORACLE:THIN:@192.168.1.131:1521:ORCL

SMARTBI installation Please refer to the wiki documentation: http://wiki.smartbi.com.cn/pages/viewpage.action?pageId=17956999

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.