SpagoBI4.2 and configuring MySQL database tutorial

SpagoBI4.2 and configuring MySQL database tutorial

• 1. Install MySQL database

• 2. Install the JDK and configure the Java environment variables

• 3. Download SapagoBI4.2 ALLinONE installation package

• 4. Unzip the SpagoBI installation package to the E-Drive bi folder

• 5, configure the system environment variable: catalina_home, the path is E:\BI\SpagoBI-Server-4.2-10042014

• 6. Start the Spagobistartup.bat file under the installation directory E:\BI\SpagoBI-Server-4.2-10042014\bin, when the server startup in xxxxx Ms indicates that the service starts to complete;

• 7, enter "Http://localhost:8080/SpagoBI" in the browser address bar, when the landing interface is normal, indicating the normal operation of the demo environment

• 8, under the installation directory E:\BI\SpagoBI-Server-4.2-10042014\bin, double-click "Shutdown.bat" to close the service

• 9. In the HSQLDB command box, press CTRL + C to stop the database service

• 10. Open Mysqlworkbench, CREATE DATABASE "SpagoBI"

• CREATE SCHEMA ' SpagoBI ';

• 11, set the SpagoBI database as the default database;

• 12. Open the Step1 in the CREATE database script and execute to ensure all the tables are created;

• 13. Open the Step2 in the CREATE database script and execute to ensure all the tables are created;

• 14. Find the MySQL installation directory C:\Program Files (x86) \MYSQL\CONNECTOR.J 5.1. mysql-connector-java-5.1.34-bin.jar file, copy it to the Lib folder under the SpagoBI installation directory, and delete the MySQL jar file from the system;

• 15. Replace the spagobi4.2 folder with the SpagoBI folder under the SpagoBI installation directory E:\BI\SpagoBI-Server-4.2-10042014\webapps

• 16. Replace the SpagoBI MySQL configuration file with the Server.xml file under E:\BI\SpagoBI-Server-4.2-10042014\conf

• 17, according to their own installation of MySQL user name, password and port number to modify the contents of the file response;

• 18, execute "E:\BI\SpagoBI-Server-4.2-10042014\bin" under the Starup.bat file, when the Server startup in xxxxx Ms indicates that the service started to complete;

• 19, enter "Http://localhost:8080/SpagoBI" in the browser address bar, when the landing interface is normal, indicating that the configuration MySQL database successfully

• 20, enter the MySQL database, query sbi_config table found the relevant data;

• 21, update Sbi_config table to enable SpagoBI support Chinese

• 22, under the installation directory E:\BI\SpagoBI-Server-4.2-10042014\bin, double-click "Shutdown.bat" to close the service

• 23, execute "E:\BI\SpagoBI-Server-4.2-10042014\bin" under the Starup.bat file, when the Server startup in xxxxx Ms indicates that the service started to complete;

• 24, in the browser address bar input "Http://localhost:8080/SpagoBI", when the normal appearance of the login interface, the user name and password has become Chinese;

• 25. Login system with Administrator account, select En in the Language options

• 26, at this point spagobi4.2 completed the Chinese and the default data is configured as MySQL database;

--------------------------------------------------------------------------------------------------------------- -

--------------------------------------------------------------------------------------------------------------- --

Contact me:

Blog: Http://www.cnblogs.com/mybi

Email: [Email protected]

qq:2118917071

: Excel_cortana

Q Group: 275725345

SpagoBI4.2 and configuring MySQL database tutorial