Saiku-Configuring users, schemas, and data sources from the console

Previous article on how to download and install Saiku [http://www.cnblogs.com/avivaye/p/4877680.html]

This article describes the Saiku user's configuration operations and points to note

One, add users

Saiku The default administrator account is admin, password is admin. Adding a user's operation is very simple. Click AddUser directly in the admin background. To note the addition of roles, the following two cases will cause the added account can not be logged:1) If theroles does not add 2) If roles add error the system allows only 2 kinds of roles. respectively: Role_user,role_admin

Second, add schema

The process of adding schemas is also very simple, just select the XML file and upload it. Be sure to fill out the schema name and not fill out the schema name to cause the upload to fail.

Third, add data source (sources)

the way you add data sources is complex, because you don't have a detailed description of each item in the background. The first way: fill in the name of each ①name:data sources ②connection Type: Use the default Mondrian, XML/a I'm not used to it at the moment. ③url: There are stricter formats, different database formats, MySQL:jdbc:mysql://[Database host]/[database name]PostgreSQL:jdbc:postgresql://[Database host]:[port]/[database name]DB2:JDBC:DB2://[Database host]:[port]/[database NAME]④schema: After the Schema is added, it is automatically rendered in the drop-down box. ⑤JDBC Driver: The specific format is as follows: MySQL:com.mysql.jdbc.Driver PostgreSQL:org.postgresql.Driver DB2:com.ibm.db2.jcc.DB2Driv ER Note: By default, Saiku is a jar package without JDBC, and you need to download the corresponding. jar file for your database and add the file to the Saiku-server/tomcat/webapps/saiku/web-inf/the system can be restarted after the Lib directory. ⑥username: Database username ⑦password: Database Password The second way: Advanced all connections are written in a string, in the following format: type=Olapname=Foodmartdriver=mondrian.olap4j.MondrianOlap4jDriverlocation=jdbc:mondrian:jdbc=jdbc:mysql://Localhost:3306/foodmart; Catalog=res:datasources/fm.xml; Jdbcdrivers=com.mysql.jdbc.driver;Username=Dbuserpassword=Password Description: Type: Fixed is the name of Olapname:data sources casually take driver: that is, the above connection type, if it is Mondrian, The value is: mondrian.olap4j.MondrianOlap4jDriverlocaltion: That is, the database connection, the specific format as described above. It's important to note that datasources/Fm.xml is not a real directory of files, it is the virtual address acquired after uploading. Username and Password: Database account and Password

Saiku-Configuring users, schemas, and data sources from the console