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