Home

SpagoBI Installation Manual

1. attribute type soam objectClass top objectClass organizationalUnit E jou Group Sg Gruppo A businessCategory i SottoGruppo_A description Sh Gruppo B destinationIndicator Y People FacsimileTelephoneNumber linternationalisSDNNumber 1 physicalDeliveryOfficeName postal ddress postalCode postOfficeBox preferredDeliveryMethod iregisteredAddress isearchGuide iseeAlso st street telephoneNumber teletexTerminalIdentifier telexNumber userPassword ix121Address Submit Reset Change Class Properties Connected To Idap localhost 389 start 6 JXplorer File Edit View Bookmark Search LDIF Options Tools Security Help gSa t eBRe X Da S fn v Quick Search f Explore dh Results G schema HTML View E Table Editor World attribute type value com len biadmin ze spagobi objectClass organizationalPerson i i Group objectClass person jm Gruppo_A objectClass top a SottoGruppo A sn biadmin d Gruppo B description descrizione eis People ou ou Gruppo_A ou Group dc spagobi dc com admin ou ou Gruppo_B ou Group dc spagobi dc com ItelephoneNumber 051 6563707 title Dot userPassword non string data destinationIndicator FacsimileTelephoneNumber jinternationaliSDNNumber n I physicalDeliveryOfficeName pos
2. job store delegate class Hsqldb delegate class org quartz jobStore driverDelegateClass org quartz impl jdbcjobstore HSQLDBDelegate Mysql delegate class org quartz jobStore driverDelegateClass org quartz impl jdbcjobstore StdJDBCDelegate Postgres delegate class org quartz jobStore driverDelegateClass org quartz impl jdbcjobstore PostgreSQLDelegate Oracle delegate class org quartz jobStore driverDelegateClass org quartz impl jdbcjobstore oracle OracleDelegate 4 4 Install Cms Repository SpagoBI needs a connection to a content management system cms compliant to the jsr 170 specification in order to store and version the BI documents The connection is represented by a jsr 170 Repository object which allows to open working session into the cms SpagoBI can be configured to initialize directly the repository or to get it as a jndi resource Using JBoss server it s necessary to initialize the repository directly so Only if you haven t already done it copy the folder JBOSS INST FILES sbidata into JBOSS HOME folder open the file cms jboss jonas xml in JBOSS HOME server default deploy spagobi war WEB INF conf and substitute SERVER_HOME with the actual path of JBOSS HOME in the definition of the parameters repository_path this property indicates the folder in which JackRabbit will store contents and conf_file_path this property indicates the file for Jackrabbit conf
3. Installation Manual 1 0 0 lt type mapping gt Hypersonic SQL lt type mapping gt lt metadata gt lt local tx datasource gt lt datasources gt 4 3 Install SpagoBI platform Connect to http forge objectweb org projects spagobi select the file tab and then download the SpagoBI bin 1 9 4_xxx zip Extract from the zip archive the file spagobi war and rename it as spagobi zip Create a folder with the name spagobi war and unzip the file spagobi zip inside it Delete the spagobi zip file and then copy the parent spagobi war directory into JBOSS HOME server default deploy folder To unzip a war file you need first to rename its extension form war to zip At the end you should have a spagobi war folder which contains other subfolders jsp img WEB INF etc Edit the file spagobi xml contained in JBOSS HOME server default deploy spagobi war WEB INF conf spagobi and Search the tag lt SPAGOBI MODE gt and change the attribute mode to WEB lt SPAGOBI MODE mode WEB gt Search the tag lt SPAGOBI_CONTEXT_PATH gt and replace the value with your SpagoBI installation URL you have simply to change the server name and port Example if you have installed SpagoBI on a server call myhost and the server is listening on port 5000 the value must be http myhost 5000 spagobi default Tomcat server port is 8080 Search the tag LANGUAGE SUPPORTED and set to true the default attribute of the children LANGUAGE tag
4. Odocument type Report Oengine type External Odriver class it eng spagobi drivers jasperreport JasperReportDriver Ourl http lt server gt lt port gt SpagoBlJasperReportEngine JasperReportServlet 4 6 2 Install SpagoBIJPivotEngine Connect to http forge objectweb org projects spagobi select the file tab and then download the file SpagBIJPivotEngine bin 1 9 4 xxx zip Extract from the zip archive the file SpagoBIJPivotEngine war and rename it as SpagoBIJPivotEngine zip Create a new folder named SpagoBIJPivotEngine war and unzip the file SpagoBIJPivotEngine zip inside it Delete the SpagoBIJPivotEngine zip file and copy the parent SpagoBIJPivot war directory into JBOSS HOME server default deploy folder Remove the following jar files from JBOSS HOME server default deploy SpagoBIJPivotEngine war WEB INF lib Olog4j 1 2 8 jar file log4j jar already available in Jboss server version 1 2 8 Using the SpagoBI administration web application define a new External Engine with see chapter 4 7 Configure external engines Odocument type On line analytical processing Oengine type External Odriver class it eng spagobi drivers jpivot JPivotDriver Ourl http lt server gt lt port gt SpagoBIJPivotEngine JPivotServlet 4 6 3 Install SpagoBlQbeEngine Connect to http forge objectweb org projects spagobi select the file tab and then download the file SpagoBIQbeEngine bin 1 9 4 xxx zip Extract from the zip archive the fil
5. 2 0 X SpagsB SpagoBI Web Application Jboss 4 0 3SP1 lt p Installation Manual 1 0 0 lt listener class gt org exoplatform services portletcontainer impl servlet PortletApplicationListener lt listener class gt lt listener gt gt 1 lt servlet gt lt servlet name gt PortletWrapper lt servlet name gt lt servlet class gt org exoplatform services portletcontainer impl servlet ServletWrapper lt servlet class gt lt servlet gt gt ssil 1 lt servlet mapping gt lt servlet name gt PortletWrapper lt servlet name gt lt url pattern gt PortletWrapper lt url pattern gt lt servlet mapping gt gt copy the file JBOSS HOME server default deploy spagobi war components mapcatalogue img mapManagement png into JBOSS HOME server default deploy spagobi war img wapp directory In the BOSS HOME server default deploy spagobi war img wapp directory rename the file mapManagement png to map64 png 4 3 1Configure Hibernate SpagoBI uses Hibernate to manage metadata Since SpagoBI can use different databases hibernate must be configured in order to use the correct settings and sql dialect Into the folder JBOSS HOME server default deploy spagobi war WEB INF classes there are five hibernate configuration files one for each database supported hibernate cfg postgres xml postgres database hibernate cfg ora xml oracle database hibernate cfg mysql xml mysql database h
6. 2008 page 5 of 29 ti Engineering Ingegneria Informatica S p A 2005 This work is licensed coetrea Ive under the Creative Commons Attribution NonCommercial ShareAlike lt Y commons License To view a copy of this license visit t C OCM MONS D EED http creativecommons org licenses by nc sa 2 0 x age SpagoBI Web Application Jboss 4 0 3SP1 lt Sp B nce Free Platform Installation Manual 1 0 0 server listening on port 9002 with a spagobi databases already populated with the necessary data Remember that every time you start the Jboss server to work with SpagoBI the database server must be running If you don t want to use hsqldb you have the possibility to choose between PostgresSQL Oracle SQLServer and MySQL If you don t have anyone of these database servers installed you need to install one of them Once you have a functional database server you must create a new database for the metadata spagobi is the database name suggested Once completed the operation above it s possible to proceed with the creation and initial population of the metadata database launching the right script for your database server For each database server supported you need to download from the SpagoBI Repository a zip archive containing the sql script to create the schema the comments of the table and finally to populate the schema with initial data These scripts don t contain the examples data as the hsqldb So
7. corresponding to your language Be sure that one and only one of the LANGUAGE tags have the default attribute set to true Example if you want to have menus and messages in french you need this configuration LANGUAGE SUPPORTED LANGUAGE default false language it country IT 7 LANGUAGE default false language en country US gt LANGUAGE default true language fr country FR gt Note Some menus and messages could be not translated because there is no translation file created for them Edit the file initializer xml contained into JBOSS HOME server default deploy spagobi war WEB INF conf and uncomment the following initializers lt INITIALIZER class it eng spagobi security init SecurityInitializer config gt lt INITIALIZER class it eng spagobi init TreeInitializer config SPAGOBI TREE_INITIALIZATION gt e Edit the file web xml contained into JBOSS HOME server default deploy spagobi war WEB INF and comment the definitions and mappings of the portlet listener and portlet servlet Es lt l lt listener gt SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 8 of 29 ti Engineering Ingegneria Informatica S p A 2005 This work is licensed coetrea Ive under the Creative Commons Attribution NonCommercial ShareAlike lt Y commons License To view a copy of this license visit t C OCM MONS D EED http creativecommons org licenses by nc sa
8. roleName sbi_admin gt lt BEHAVIOUR userID biadmin roleName spagobi biadmin gt lt BEHAVIOUR userID bitest roleName sbi_test gt BEHAVIOUR userID bitest roleName spagobi bitest gt lt BEHAVIOUR userID bidev roleName sbi_dev gt lt BEHAVIOUR userID bidev roleName spagobi bidev gt lt BEHAVIOUR userID biuser roleName sbi_user gt BEHAVIOUR userID biuser roleName spagobi biuser gt lt BEHAVIOURS gt lt PRIVILEDGES gt lt PRIVILEDGE roleName sbi_admin functionalityName EnginesManagement gt SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 26 of 29 ti Engineering Ingegneria Informatica S p A 2005 This work is licensed coetrea Ive under the Creative Commons Attribution NonCommercial ShareAlike lt Y commons License To view a copy of this license visit t C OCM MONS D EED http creativecommons org licenses by nc sa 2 0 X SpageB SpagoBI Web Application Jboss 4 0 3SP1 lt p Installation Manual 1 0 0 lt PRIVILEDGE roleName sbi_admin functionalityName FunctionalitiesManagement gt lt PRIVILEDGE roleName sbi_admin functionality Name LovsManagement gt lt PRIVILEDGE roleName sbi_admin functionality Name ConstraintManagement gt lt PRIVILEDGE roleName sbi_admin functionality Name ParameterManagement lt PRIVILEDGE roleName sbi_admin functionality Name DocumentAd
9. to install it a Download the file eclipse SDK 3 0 2 win32 zip at http archive eclipse org eclipse downloads drops R 3 0 2 200503110845 index php b unzip the eclipse zip C go in the eclipse 3 0 2 eclipse plugins org eclipse jdt core 3 0 2 directory d copy the jdtcore jar file into JBOSS HOME server default lib directory e go into JBOSS HOME server default lib directory et rename the file jdtcore jar to jdt compiler 3 0 2 jar Note use only jdt compiler 3 0 x jar jdt compiler 3 1 x jar don t work with Tomcat 5 5 X 5 5 9 include in Jboss 4 0 3SP1 See _ https www zarb org pipermail jpackage discuss 2005 October 008945 html 4 21nstall the Metadata Database SpagoBI metadata are stored in a database for this release SpagoBI supports PostgresSQL Oracle MySQL SQLServer and HSQLDB SpagoBI Utility files package contains an hsql database that can be used to test SpagoBI without installing a database server After the execution of the activities listed in the previous paragraph the hsqldb script is stored into JBOSS HOME sbidata database HSQL database is very useful for test purpose but is very weak in a production environment Anyway if you want to use HSQLDB just exec the command JBOSS HOME sbidata database start bat on a windows platform Or JBOSS HOME sbidata database start sh on a linux unix platform The command starts an HSQLDB SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2
10. ver 1 0 0 October 2 2008 page 6 of 29 ti Engineering Ingegneria Informatica S p A 2005 This work is licensed coetrea Ive under the Creative Commons Attribution NonCommercial ShareAlike lt Y commons License To view a copy of this license visit t C OCM MONS D EED http creativecommons org licenses by nc sa 2 0 SpagoBl Web Application Jboss 4 0 3SP1 Installation Manual 1 0 0 AX SpoqsB The driver jar of the corresponding database you use have to be put under JBOSS HOME server default lib Pay attention If you decide to use the SpagoBI hsqldb example database add into JBOSS HOMEJ server default lib the hsgldb1 8 O 2 jar library and remember to remove the existing hsqldb jar library in the same folder in order to avoid conflicts 4 2 2Configuring Datasource as JNDI Resource SpagoBI needs a JNDI datasource for the metadata database To configure the JNDI resources do the following steps Copy from JBOSS INST FILES server default deploy the file spagobi ds xml into JBOSS HOME server default deploy The xml copied configures a new jndi datasource for the metadata database The default values are for the SpagoBI hsql database and if you are using another database server you need to change them Based on your database change the value of the following parameters driverClassName ul username password Edit the spagobi ds xml file and change the properties connection url driver cl
11. ED http creativecommons org licenses by nc sa 2 0 XS ages SpagoBI Web Application Jboss 4 0 3SP1 p Installation Manual 1 0 0 Obidev password bidev his pages contains the SpagoBI development web application Obitest password bitest his page contains the SpagoBI execution web application with the possibilty to view documents in test state Obiuser password biuser his page contains the SpagoBI execution web application For configuring the external engines use the biadmin for the connection Next click on this icon to add a new external engine Click on this icon external engines 4 FR Configure a new external engine like Jasper Engines Management DETAILS MOTEUR EX CUTION Titre Nom i Type de moteur Nom Pilote it eng spagobi drivers jasperreport JasperReportDriver a SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 29 of 29 ti Engineering Ingegneria Informatica S p A 2005 This work is licensed cocrea ive under the Creative Commons Attribution NonCommercial ShareAlike e commons License To view a copy of this license visit to C O M M O NS DEED http creativecommons org licenses by nc sa 2 0
12. Engine war directory into JBOSS HOME server default deploy folder SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 20 of 29 ti Engineering Ingegneria Informatica S p A 2005 This work is licensed coetrea Ive under the Creative Commons Attribution NonCommercial ShareAlike lt Y commons License To view a copy of this license visit t C OCM MONS D EED http creativecommons org licenses by nc sa 2 0 X SpoqeB SpagoBI Web Application Jboss 4 0 3SP1 lt p Installation Manual 1 0 0 Remove the following jar files from JBOSS HOME server default deploy SpagoBIWekaEngine war WEB INF lib Olog4j 1 2 8 jar Using the SpagoBI administration web application define a new External Engine with see chapter 4 7 Configure external engines Odocument type Data mining model Oengine type External Odriver class it eng spagobi drivers weka WekaDriver Ourl http lt server gt lt port gt SpagoBIWekaEngine WekaServlet 4 6 6 Install SpagoBlGeoEngine Connect to http forge objectweb org projects spagobi select the file tab and then download the file SpagoBIGeoEngine bin 1 9 4 xxx zip Extract from the zip archive the file SpagoBIGeoEngine war and rename it as SpagoBIGeoEngine zip Create a new folder named SpagoBIGeoEngine war and unzip the file SpagoBIGeoEngine zip inside it Delete the SpagoBIGeoEngine zip file and copy the parent SpagoBIGeoEngine war directory into
13. JBOSS HOME server default deploy folder Remove the following jar files from JBOSS HOME server default deploy SpagoBIGeoEngine war WEB INF lib Oxalan 2 4 0 jar OxercesImpl jar Olog4j 1 2 8 jar Using the SpagoBI administration web application define a new External Engine with see chapter 4 7 Configure external engines Odocument type Map Oengine type External Odriver class it eng spagobi drivers geo GeoDriver Ourl http lt server gt lt port gt SpagoBIGeoEngine servlet AdapterHTTP ACTION_NAME GEO_ACTION amp NEW_SESSION TRUE 4 6 7 Install SpagoBIJPXMLAEngine Connect to http forge objectweb org projects spagobi select the file tab and then download the file SpagBIJPXMLAEngine bin 1 9 4_xxx zip Extract from the zip archive the file SpagoBIJPXMLAEngine war and rename it as SpagoBIJPXMLAEngine zip Create a new folder named SpagoBIJPXMLAEngine war and unzip the file SpagoBIJPXMLAEngine zip inside it Delete the SpagoBIJPXMLAEngine zip file and copy the parent SpagoBIJPXMLAEngine war directory into JBOSS HOME server default deploy folder Remove the following jar files from JBOSS HOME server default deploy SpagoBIJPXMLAEngine war WEB INF lib Olog4j 1 2 8 jar The driver is the same of SpagoBIJPivotEngine control that the file sbi driver jpivot 1 9 4 jar is present inside folder JBOSS HOME server default deploy exoplatform sar spagobi war WEB INF lib if it is missing you have to connect to SpagoBI Web Applic
14. N FILTER gt lt SECURITY gt gt SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 18 of 29 ti Engineering Ingegneria Informatica S p A 2005 This work is licensed coetrea Ive under the Creative Commons Attribution NonCommercial ShareAlike lt Y commons License To view a copy of this license visit t C OCM MONS D EED http creativecommons org licenses by nc sa 2 0 X Spa SpagoBI Web Application Jboss 4 0 3SP1 lt p Installation Manual 1 0 0 4 6 Install Engines 4 6 1 Install SpagoBlJasperReportEngine Connect to http forge objectweb org projects spagobi select the file tab and then download the file SpagoBlJasperReportEngine bin 1 9 4 xxx zip Extract from the zip archive the file SpagoBlJasperReportEngine war and rename it as SpagoBlJasperReportEngine zip Create a folder with the name SpagoBlJasperReportEngine war and unzip the file SpagoBlJasperReportEngine zip inside it Delete the SpagoBlIJasperReportEngine zip file and then copy the parent SpagoBlJasperReportEngine war directory into JBOSS HOME server default deploy folder Remove the following jar files from JBOSS HOME server default deploy SpagoBlJasperReportEngine war WEB INF lib Olog4j 1 2 8 jar file log4j jar already available in Jboss server version 1 2 8 Using the SpagoBI administration web application define a new External Engine with see chapter 4 7 Configure external engines
15. Name Scheduler gt functionalityName Events gt functionalityName WorkspaceExec gt lt PRIVILEDGE lt PRIVILEDGE lt PRIVILEDGE lt PRIVILEDGE lt PRIVILEDGES gt lt RELATIONS gt lt AUTHORIZATIONS gt roleName spagobi dev functionalityName LovsManagement gt roleName spagobi dev functionalityName ConstraintManagement gt roleName spagobi dev functionalityName ParameterManagement gt roleName spagobi dev functionalityName DocumentAdministration gt To activate this feature to have user and goups configuration in XML files do the followings steps a Only if you haven t already done it you need to put inside the spagobi WEB INF lib directory the jar of the xml security provider implementation download the file SpagoBIXmlSecurityProvider bin 1 9 4 xxx zip from SpagoBI donwload page http forge objectweb org project showfiles php group id 204 and extract the contained file sbi security xml 1 9 4 jar into JBOSS HOME server default deploy spagobi war WEB INF lib b Make sure that sbiwa ldap authorizations xml file is disabled and that sbiwa authorizations xml file is enabled in the file JBOSS HOME server default deploy spagobi war WEB INF conf master xml SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 page 16 of 29 Engineering Ingegneria Informatica S p A 2005 This work is licensed under the Creative Commons Attribution NonCommercial ShareAlike License T
16. TAL SECURITY CLASS lt USER PROFILE FACTORY CLASS className z it eng spagobi security LdapUserProfileFactoryImpl gt ROLE NAME PATTERN FILTER gt lt ROLE NAME PATTERN FILTER gt lt SECURITY gt Please note that you need to put inside the spagobi WEB INF lib directory the jar of the ldap security provider implementation download the file SpagoBILdapSecurityProvider bin 1 9 4_xxx zip from SpagoBI donwload page and extract the contained file sbi security ldap 1 9 4 jar into JBOSS HOME server default deploy spagobi war WEB INF lib SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 15 of 29 Engineering Ingegneria Informatica S p A 2005 This work is licensed E greative under the Creative Commons Attribution NonCommercial ShareAlike A ons License To view a copy of this license visit to C OCM MO NS DEED http creativecommons org licenses by nc sa 2 0 Sp ness Intelliger SpagoBl Web Application Jboss 4 0 3SP1 1 0 0 age B e Free Platform Installation Manual 4 5 2Usign xml files The provided solution reads user and goups configuration from xml files and it was developed only for test purposes Users and groups with their associations are defined in file JBOSS HOME server default deploy spagobi war WEB INF conf sbiwa authorizations xml In this file you can associate also roles with functionalities as seen for Ldap authorization Here y
17. X SpageB SpagoBI Web Application Jboss 4 0 3SP1 lt p gence Free Platform Installation Manual 1 0 0 SpagoBI 1 9 4 Web Application for Jboss 4 0 3SP1 Installation Manual 1 0 0a Authors Yannick LE NY from the original document SpagoBI Web Application Tomcat Installation Manual 1 0 0 created by Bernabei Angelo Zerbetto Davide SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 1 of 29 5 Yannick LE NY creative Engineering Ingegneria Informatica S p A 2005 This work is licensed e commons under the Creative Commons Attribution NonCommercial ShareAlike to COMMONS DEED License To view a copy of this license visit http creativecommons org licenses by nc sa 2 0 SpagoBI Web Application Jboss 4 0 3SP1 SP mob Free Platfo Installation Manual 1 0 0 Index T VERSION ist ck eke nee ical 3 2 DOCUMENT GOAL m Q 3 3 REFERENCES ssisscccessssscissivsiesrssaisssesdsssaseusnensssseonnsietiesasssieanaesinissenisskisneensessadatibeessrsenoasenisciaasnaniicisin 3 A INSTALL SPAGOPBL ioeuiesisisetie th tbi nasi e titre ra bra eae tabou skis kl steel ab SERE ia 3 4 1 INSTALL ADDITIONAL LIBRARIES AND CONFIGURATION FILES 255x225 353555252452325 02 954 9402 9 9 pbtrrr apro RES se RE DE PA SER REV 4 2 7 IMS Tec pum MAREA DATABASE deae count ves coe a DL LEEQE 5 4 2 1 Insol thie dotabase driver uui ticis citri tuae Eta Eel oo eo p kp prc poe e v
18. Y commons License To view a copy of this license visit t C OCM MONS D EED http creativecommons org licenses by nc sa 2 0 SpoqeB SpagoBI Web Application Jboss 4 0 3SP1 lt p Installation Manual 1 0 0 ROLE roleName spagobi biadmin description spagobi biadmin gt ROLE roleName bi_test description bi test gt ROLE roleName spagobi bitest description spagobi bitest gt lt ROLE roleName bi_dev description bi_dev gt lt ROLE roleName spagobi bidev description spagobi bidev gt lt ROLE roleName bi_user description bi_user gt ROLE roleName spagobi biuser description spagobi biuser gt lt ROLES gt lt FUNCTIONALITIES gt lt FUNCTIONALITY functionalityName EnginesManagement description EnginesManagement gt lt FUNCTIONALITY functionalityName FunctionalitiesManagement description FunctionalitiesManagement gt lt FUNCTIONALITY functionalityName LovsManagement description LovsManagement gt lt FUNCTIONALITY functionality Name ConstraintManagement description ConstraintManagement gt lt FUNCTIONALITY functionality Name ParameterManagement description ParameterManagement gt lt FUNCTIONALITY functionality Name DocumentAdministration description DocumentAdministration gt lt FUNCTIONALITY functionality Name DocumentDevelopment description DocumentDevelopment gt lt FUNCTIONALITY functi
19. a folder into your JBOSS HOME The folder contains the hsqldb metadata database and the root folder of the cms repository The following libraries will be copied into JBBOSS HOME server default lib directory ehcache 1 1 jar concurrent 1 3 4 jar SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 4 of 29 ti Engineering Ingegneria Informatica S p A 2005 This work is licensed coetrea Ive under the Creative Commons Attribution NonCommercial ShareAlike lt Y commons License To view a copy of this license visit t C OCM MONS D EED http creativecommons org licenses by nc sa 2 0 SpagsB SpagoBI Web Application Jboss 4 0 3SP1 lt p Installation Manual 1 0 0 2 jackrabbit core 1 0 1 jar s f4j log4j12 jar jcr 1 0 jar The following libraries will be copied into JBOSS HOME server default lib directory portlet api 1 0 jar dom4j 1 6 jar 2jta 1 0 1B jar 2 dap jar xercesImpl jar The following libraries will be copied into JBOSS HOME server default lib directory commons collections 3 1 jar hsqldb1 8 0 2 jar remember to remove the existing hsqldb jar library in the same folder in order to avoid conflicts 5 With Jboss 4 0 3SP1 you need jdt compiler 3 0 2 jar file to use SpagoBI 1 9 4 as Web Application but the file jdt compiler 3 0 2 jar is not in the the file called SpagoBlIUtilityFiles 1 9 4 xxx zip You need to do some steps
20. ass user name password type mapping with the right value for the connection to your SpagoBI database The default value are suitable for hsqldb SpagoBI is provided with a hsqldb database for testing but not for production Host localhost port 9002 user sa password nothing database spagobi This testing database is stored in the sbidata database directory In the default spago ds xml for testing with hsqldb database you have this configuration lt xml version 1 0 encoding UTF 8 gt lt datasources gt lt local tx datasource gt lt jndi name gt spagobi lt jndi name gt lt connection url gt jdbc hsqldb hsql localhost 9002 spagobi lt connection url gt lt driver class gt org hsqldb jdbcDriver lt driver class gt lt user name gt sa lt user name gt lt password gt lt password gt lt min pool size gt 5 lt min pool size gt lt The maximum connections in a pool sub pool gt lt max pool size gt 20 lt max pool size gt lt metadata gt SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 7 of 29 cocreative Commons COMMONS DEED Engineering Ingegneria Informatica S p A 2005 This work is licensed under the Creative Commons Attribution NonCommercial ShareAlike License To view a copy of this license visit http creativecommons org licenses by nc sa 2 0 EOE X Spa SpagoBI Web Application Jboss 4 0 3SP1 lt p
21. ation Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 21 of 29 ti Engineering Ingegneria Informatica S p A 2005 This work is licensed coetrea Ive under the Creative Commons Attribution NonCommercial ShareAlike lt Y commons License To view a copy of this license visit t C OCM MONS D EED http creativecommons org licenses by nc sa 2 0 X Spa SpagoBI Web Application Jboss 4 0 3SP1 lt p Installation Manual 1 0 0 http forge objectweb org projects spagobi select the file tab and then download the file SpagoBIJPivotDriver bin 1 9 4_xxx zip Extract from the zip archive the file sbi drivers jpivot 1 9 4 jar and copy it inside JBOSS HOME server default deploy exoplatform sar spagobi war WEB INF lib Using the SpagoBI administration web application define a new External Engine with see chapter 4 7 Configure external engines Odocument type On line analytical processing Oengine type External Odriver class it eng spagobi drivers jpivot JPivotDriver Ourl http lt server gt lt port gt SpagoBIJPXMLAEngine JPivotServlet Note that SpagoBIJPXMLAEngine is a client web application for a XMLA server The installation steps of a XMLA server are not included in this document 4 6 8Install SpagoBlTalendEngine Connect to http forge objectweb org projects spagobi select the file tab and then download the file SpagoBITalendEngine bin 1 9 4_xxx zip Extract from the zip ar
22. chive the file SpagoBITalendEngine war and rename it as SpagoBITalendEngine zip Create a new folder named SpagoBITalendEngine war and unzip the file SpagoBITalendEngine zip inside it Delete the SpagoBITalendEngine zip file and copy the parent SpagoBITalendEngine war directory into JBOSS HOME server default deploy folder Remove the following jar files from JBOSS HOME server default deploy SpagoBITalendEngine war WEB INF lib Olog4j 1 2 8 jar Edit file talend properties in JBOSS HOME server default deploy SpagoBITalendEngine war WEB INF classes and configure the following properties runtimeRepository rootDir the root path of the repository containing the jobs it can be absolute or relative spagobi autopublish if it is true when you deploy a new job from Talend Opend Studio a SpagoBI document will be automatically created and put on the functionalities tree spagobi functionality label the label of the functionality where SpagoBI document will be created if spagobi autopublish is true spagobi url the SpagoBI context url it is required if spagobi autopublish is true Edit file talend perl properties in JBOSS HOME server default deploy SpagoBITalendEngine war WEB INF classes and adjust your Perl installation directory mandatory if you want to executed Perl based jobs Edit file talend java properties in JBOSS HOME server default deploy SpagoBITalendEngine war WEB INF classes and adjust Java process memory options if
23. connect to http forge objectweb org projects spagobi select the file tab and then download the file called lt lt name of you database gt gt dbscript 1 9 4 zip Into the zip file there are some sql script files you must execute the creation and insertion script with a client for your database server In every archive exists also a drop script but this one is useful only if you need to clean your database deleting all the spagobi metadata tables Example if you have a postgresql database server you need to download the relative archive postgres dbscript 1 9 4 zip and run in the following order the scripts PG_create sql PG_insert sql and then also PG_create_quartz_schema sq 4 2 1Install the database driver Before to proceed with persistence configuration we must install the database drivers packages in the application server Because SpagoBI can be configured to connect to different database servers one for the metadata and one for datawarehouse for example you must obtain the specific drivers for every database server used by SpagoBI The drivers package can be obtained from database vendors site and for the current SpagoBI release we test the following versions Postgresq postgresql 8 0 311 jdbc2 jar Oracle ojdbc14 jar MySQL mysql connector java 3 1 10 bin jar HSQLDB hsqldb1_8_0_2 jar contained into JBOSS INST FILES server default lib SQLServer sqljdbc jar SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual
24. creative Commons COMMONS DEED License To view a copy of this license visit http creativecommons org licenses by nc sa 2 0 Engineering Ingegneria Informatica S p A 2005 This work is licensed under the Creative Commons Attribution NonCommercial ShareAlike By ee 9 X SpageB SpagoBI Web Application Jboss 4 0 3SP1 p the Bus Free Platform h siness Intelligence Installation Manual 1 0 0 lt PRIVILEDGE roleName sbi_user functionality Name Events gt lt PRIVILEDGE roleName sbi_user functionality Name Worklist gt lt PRIVILEDGE roleName sbi_user functionalityName WorkspaceExec gt lt PRIVILEDGES gt lt RELATIONS gt lt AUTHORIZATIONS gt Now you should be able to connect to the url http localhost 8080 spagobi index jsp To configure the engines the Ensine Intelligence Free Pith nm Name Password The web application defines five users Oadmin password admin his pages contains the SpagoBI administration web application Obiadmin password biadmin his pages contains also the SpagoBI administration web application SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 28 of 29 ti Engineering Ingegneria Informatica S p A 2005 This work is licensed ocrea ive under the Creative Commons Attribution NonCommercial ShareAlike e commons License To view a copy of this license visit to C OCM MO NS DE
25. e SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 19 of 29 ti Engineering Ingegneria Informatica S p A 2005 This work is licensed coetrea Ive under the Creative Commons Attribution NonCommercial ShareAlike lt Y commons License To view a copy of this license visit t C OCM MONS D EED http creativecommons org licenses by nc sa 2 0 X SpoqeB SpagoBI Web Application Jboss 4 0 3SP1 lt p Installation Manual 1 0 0 SpagoBIQbeEngine war Unzip the war file into a directory named SpagoBIQbeEngine war Copy the new directory into JBOSS HOME server default deploy folder Remove the following jar files from JBOSS HOME server default deploy SpagoBIQbeEngine war WEB INF lib OPTIONAL no log4j properties log4j 1 2 8 jar file log4j jar already available in Jboss server version 1 2 8 If you want advised change the password of the administrator user look at the section How to configure SpagoBIQbeEngine administrator users of the How To documentation file to learn how to do it Using the SpagoBI administration web application define a new External Engine with see chapter 4 7 Configure external engines Odocument type Datamart Model Oengine type External Odriver class it eng spagobi drivers qbe QbeDriver Ourl http lt server gt lt port gt SpagoBIQbeEngine servlet AdapterHTTP ACTION NAME SPAGO BI START ACTION amp NEW SESSION TRUE without any s
26. ects spagobi click on the File tab download the file called SpagoBIUtilityFiles 1 9 4_xxx zip and then unzip it The unzip operation produces a folder SpagoBIUtilityFiles which contains spagobi web tomcat server jboss server and other folders The folder jboss server respects the tree folders structure of a Jboss4 0 3SP1 installation nd contains some required libraries and files in the following we will refer to this folder as JBOSS FILES The folder spagobi web respects the tree folders structure of a Tomcat 6 0 x and contains some required libraries and files in the following we will refer to this folder as TOMCAT INST FILES There s also another folder example portal which contains some files useful to install a new SpagoBI test portal the installation of this example portal is not mandatory in the following we will refer to this folder as EXAMPLE PORTAL 4 1Ilnstall additional libraries and configuration files SpagoBI needs some additional libraries and configuration files in order to start correctly and manage metadata 1 Copy the jar files contained in JBOSS INST FILES server default deploy exoplatform sar inside your JBOSS HOME server default lib directory 2 Copy the jar files contained in TOMCAT INST FILES lib inside your JBOSS HOME server default lib 3 Copy the content of JBOSS INST FILES lib inside your JBOSS HOME server default lib 4 Copy the JBOSS INST FILES sbidat
27. ey e dp elt od d asa 6 4 2 2 Configuring Datasource ds JINDT ResoUuree n acce das ue etapa oa d xtti iaa da o edad a Z dS eni SAO BIL ELAT OR a 8 DEGENTES D MERETUR EE 9 CERTA o ubueueeituil choreis 20 4 6 5 Install SpagoBlWekaEngine EE 20 AGG install SOGOU COP Mie ccisiiiroriiiierrindn nidal adadad aia ddi 21 4 68 BE Be oe Fluid tT 22 m NUDO oe Ng es faa aig fee ge feo ade age Ge care apes pena ae eet ewdean endings 24 SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 2 of 29 p Yannick LE NY creative Engineering Ingegneria Informatica S p A 2005 This work is licensed em commons under the Creative Commons Attribution NonCommercial ShareAlike eS License To view a copy of this license visit http creativecommons org licenses by nc sa 2 0 COMMONS DEED X SpagsB SpagoBI Web Application Jboss 4 0 3SP1 lt p Installation Manual 1 0 0 1 Version Version Release n 1 0 0 Data Version Release September 26th 2008 Update description SpagoBI 1 9 4 Web Application installation steps on a Jboss Server 4 0 3SP1 by Yannick LE NY from the original document SpagoBI Web Application Tomcat Installation Manual 1 0 0 created by Bernabei Angelo and Zerbetto Davide Version Release n 1 0 0a Data Version Release October 2th 2008 Update description Minor corrections by Yannick LE NY 2 Documen
28. gement description FunctionalitiesManagement gt lt FUNCTIONALITY functionalityName LovsManagement description LovsManagement gt FUNCTIONALITY functionalityName ConstraintManagement description ConstraintManagement gt lt FUNCTIONALITY functionalityName ParameterManagement description ParameterManagement gt lt FUNCTIONALITY functionalityName DocumentManagement description DocumentManagement gt lt FUNCTIONALITIES gt lt ENTITIES gt lt RELATIONS gt lt PRIVILEDGES gt lt PRIVILEDGE roleName sbi admin functionalityName EnginesManagement gt lt PRIVILEDGE roleName sbi admin functionalityName FunctionalitiesManagement gt PRIVILEDGE roleName sbi admin functionalityName LovsManagement gt PRIVILEDGE roleName sbi admin functionalityName ConstraintManagement PRIVILEDGE roleName sbi admin functionalityName ParameterManagement gt PRIVILEDGE roleName sbi admin functionalityName DocumentManagement gt lt PRIVILEDGES gt lt RELATIONS gt Edit the file spagobi xml contained in JBOSS HOME server default deploy spagobi war WEB INF conf spagobi and change the security configuration lt SECURITY gt tag to lt SECURITY gt PORTAL SECURITY INIT CLASS gt it eng spagobi security init LdapSecurityProviderInit PORTAL SECURITY INIT CLASS gt lt PORTAL SECURITY CLASS className it eng spagobi security LdapSecurityProviderImp1 gt lt CONFIG gt lt POR
29. ibernate cfg hsql xml hsql database hibernate cfg sqlserver xml sqlserver database You must define which file must be used based on your database edit the file JBOSS HOME server default deploy spagobi war WEB INF conf spagobi spagobi xml search for the tag lt HIBERNATE CFGFILE gt change its value putting the name of the correct hibernate configuration file the default is for hsqldb Example the line for hsqldb databases is lt HIBERNATE CFGFILE gt hibernate cfg hsql xml lt HIBERNATE CFGFILE gt SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 9 of 29 ti Engineering Ingegneria Informatica S p A 2005 This work is licensed coetrea Ive under the Creative Commons Attribution NonCommercial ShareAlike lt Y commons License To view a copy of this license visit t C OCM MONS D EED http creativecommons org licenses by nc sa 2 0 X SpagsB SpagoBI Web Application Jboss 4 0 3SP1 lt p Installation Manual 1 0 0 4 3 2 Configure Quartz The SpagoBI scheduler feature is based on Quartz technology Quartz is a library which can store its metadata into a database in the default configuration this database is the SpagoBI one In order to properly configure it do the following steps edit the file TOMCAT HOME webapps spagobi WEB INF classes quartz properties search the string job store delegate class Under this split line there s the same property
30. ication Jboss 4 0 3SP1 lt p Installation Manual 1 0 0 4 7Configure the engines After the execution of the previous steps you should be able to connect to web application to define the engines web application pages First if you use xml file for authentication and authentication you need to add more informations in your JBOSS HOME server default deploy spagobi war WEB INF conf sbiwa authorizations xml file We add 4 accounts with differents rights for using SpagoBI Change your sbiwa authorizations xml file like this lt xml version 1 0 encoding ISO 8859 1 lt AUTHORIZATIONS default FALSE gt lt ENTITIES gt lt USERS gt fs USER userID admin password ODPiKuNIrrVmD8IUCuw1hQxNqZc gt USER userID admin password admin gt USER userID biadmin password biadmin gt USER userID bitest password bitest gt USER userID bidev password bidev gt USER userID biuser password biuser gt lt USERS gt lt ROLES gt ROLE roleName Administrator description Administrator gt ROLE roleName spagobi admin description spagobi admin gt lt ROLE roleName bi_admin description bi_admin gt SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 24 of 29 ti Engineering Ingegneria Informatica S p A 2005 This work is licensed coetrea Ive under the Creative Commons Attribution NonCommercial ShareAlike lt
31. iguration Pay attention at the path form also for Windows system it must contain only separator and it must start with no c for example An example path could be Programs exo jboss delete the file cms xml contained into JBOSS HOME server default deploy spagobi war WEB INF conf folder or rename it into cms tomcat xml rename the file cms jboss jonas xml contained into JBOSS HOME server default deploy spagobi war WEB INF conf folder into cms xml At last you have to substitute the file commons collections jar in JBOSS HOME server defaultlib with the commons collections 3 1 jar you find in JBOSS HOME server default deploy spagobi war WEB INF lib SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 11 of 29 ti Engineering Ingegneria Informatica S p A 2005 This work is licensed coetrea Ive under the Creative Commons Attribution NonCommercial ShareAlike lt Y commons License To view a copy of this license visit t C OCM MONS D EED http creativecommons org licenses by nc sa 2 0 X SpagsB SpagoBI Web Application Jboss 4 0 3SP1 lt p Installation Manual 1 0 0 4 5 Authentication and authorization Authentication and authentication can be perfomed connecting to an external Ldap system or using predefined xml files 4 5 1Usign Ldap system The provided implementation is based on Novel library Open Source to connect to OpenLDAP When you have instal
32. led and configured OpenLDAP you have to add group and user directories using its graphical client JXPlorer as per the following ldif schema dn dc spagobi dc org objectclass dcObject objectclass organization 0 SpagoBI dc spagobi dn cn root dc spagobi dc org objectclass organizationalRole cn root OU People for users dn ou People dc spagobi dc org ou People objectClass top objectClass organizationalUnit OU Group for groups dn ou Group dc spagobi dc org ou Group objectClass top objectClass organizationalUnit At this point we can add groups and users Just for example we can add the groups Gruppo A and Gruppo B and the user biadmin see figures below SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 12 of 29 ti Engineering Ingegneria Informatica S p A 2005 This work is licensed coetrea Ive under the Creative Commons Attribution NonCommercial ShareAlike AN commons License To view a copy of this license visit t C OCM MONS D EED http creativecommons org licenses by nc sa 2 0 SpagoBl Web Application Jboss 4 0 3SP1 1 0 0 pageb the Business Intelligence Free Platform Installation Manual A JXplorer File Edit View Bookmark Search LDIF Options Tools Security Help ssa strem X DHE 4 n viz explore d Results Gb schema E HTML View Table Editor Quick Search
33. ministration gt lt PRIVILEDGE roleName sbi_admin functionality Name ImportExport gt lt PRIVILEDGE roleName sbi_admin functionality Name Scheduler gt lt PRIVILEDGE roleName sbi_admin functionality Name Events gt lt PRIVILEDGE roleName sbi_admin functionality Name Worklist gt lt PRIVILEDGE roleName sbi_admin functionality Name WorkspaceExec gt lt PRIVILEDGE roleName sbi_admin functionality Name MapCatalogue gt lt PRIVILEDGE roleName sbi_dev functionality Name LovsManagement gt lt PRIVILEDGE roleName sbi_dev functionality Name ConstraintManagement gt lt PRIVILEDGE roleName sbi_dev functionality Name ParameterManagement gt lt PRIVILEDGE roleName sbi_dev functionality Name DocumentDevelopment gt lt PRIVILEDGE roleName sbi_dev functionality Name Events gt lt PRIVILEDGE roleName sbi_dev functionalityName Worklist gt lt PRIVILEDGE roleName sbi_dev functionalityName WorkspaceExec gt lt PRIVILEDGE roleName sbi_test functionalityName DocumentTest gt lt PRIVILEDGE roleName sbi_test functionalityName Events gt lt PRIVILEDGE roleName sbi_test functionalityName Worklist gt lt PRIVILEDGE roleName sbi_test functionalityName WorkspaceExec gt lt PRIVILEDGE roleName sbi_user functionalityName DocumentExecution gt SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 27 of 29 co
34. nd password for the connection to your SpagoBI metadata database Example for testing with the hsqldb database provided with SpagoBI START JOB STORE org quartz jobStore class org quartz simpl RAMJobStore org quartz jobStore class org quartz impl jdbcjobstore JobStoreT X org quartz dataSource quartz jndiURL java comp env jdbc spagobi org quartz dataSource quartz driver org hsqldb jdbcDriver org quartz dataSource quartz URL jdbc hsqldb hsql ocalhost 9002 spagobi org quartz dataSource quartz user sa org quartz dataSource quartz password org quartz dataSource quartz maxConnections 20 org quartz dataSource quartz driver org postgresql Driver org quartz dataSource quartz URL jdbc postgresql localhost 5432 quartz SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 10 of 29 ti Engineering Ingegneria Informatica S p A 2005 This work is licensed coetrea Ive under the Creative Commons Attribution NonCommercial ShareAlike lt Y commons License To view a copy of this license visit t C OCM MONS D EED http creativecommons org licenses by nc sa 2 0 X SpagsB SpagoBI Web Application Jboss 4 0 3SP1 lt p Installation Manual 1 0 0 org quartz dataSource quartz user postgres org quartz dataSource quartz password postgres org quartz dataSource quartz maxConnections 5
35. o view a copy of this license visit http creativecommons org licenses by nc sa 2 0 OAS ons October 2 2008 XX DEED X SpoqeB SpagoBI Web Application Jboss 4 0 3SP1 lt p Installation Manual 1 0 0 lt CONFIGURATOR pathz WEB INF conf sbiwa authorizations xml CONFIGURATOR pathz WEB INF conf sbiwa menu xml gt lt CONFIGURATOR pathz WEB INF conf sbiwa ldap authorizations xml gt gt lt END WEB APPLICATION C Edit the file spagobi xml contained in JBOSS HOME server default deploy spagobi war WEB INF conf spagobi and change the security configuration lt SECURITY gt tag to SECURITY PORTAL SECURITY INIT CLASS gt it eng spagobi security init XmlSecurityProviderInit PORTAL SECURITY INIT CLASS gt lt PORTAL SECURITY CLASS className it eng spagobi security XmlSecurityProviderImp1 gt lt CONFIG gt lt PORTAL SECURITY CLASS gt lt USER PROFILE FACTORY CLASS className it eng spagobi security XmlUserProfileFactoryImp1 gt lt ROLE NAME PATTERN FILTER gt lt ROLE NAME PATTERN FILTER gt lt SECURITY gt More detailed step to change the security provider Uncomment this part lt Xml Spago framework security Provider gt ts acs lt SECURITY gt lt PORTAL SECURITY INIT CLASS gt it eng spagobi security init XmlSecurityProviderInit lt PORTAL SECURITY INIT CLASS gt lt PORTAL SECURITY CLASS it eng spagobi
36. onalityName DocumentTest description DocumentTest gt lt FUNCTIONALITY functionality Name DocumentExecution description DocumentExecution gt FUNCTIONALITY functionalityName ImportExport description ImportExport gt FUNCTIONALITY functionality Name Scheduler description Scheduler gt SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 25 of 29 ti Engineering Ingegneria Informatica S p A 2005 This work is licensed coetrea Ive under the Creative Commons Attribution NonCommercial ShareAlike lt Y commons License To view a copy of this license visit t C OCM MONS D EED http creativecommons org licenses by nc sa 2 0 X SpagsB SpagoBI Web Application Jboss 4 0 3SP1 lt p Installation Manual 1 0 0 FUNCTIONALITY functionalityName Events description Events gt FUNCTIONALITY functionalityName Worklist description Worklist gt FUNCTIONALITY functionalityName WorkspaceExec description WorkspaceExec gt lt FUNCTIONALITY functionality Name MapCatalogue description MapCatalogue gt lt FUNCTIONALITIES gt lt RESOURCES gt lt RESOURCES gt lt APPLICATIONS gt lt APPLICATIONS gt lt ENTITIES gt lt RELATIONS gt lt BEHAVIOURS gt lt BEHAVIOUR userID admin roleName sbi_admin gt lt BEHAVIOUR userID admin roleName spagobi admin gt lt BEHAVIOUR userID biadmin
37. ou find an example lt xml version 1 0 encoding ISO 8859 1 lt AUTHORIZATIONS default FALSE gt lt ENTITIES gt lt USERS gt USER userID biadmin password biadmin gt USER userID bidev password bidev gt lt USERS gt lt ROLES gt lt ROLE roleName spagobi admin description spagobi admin gt lt ROLE roleName spagobi dev description spagobi dev gt lt ROLES gt lt RESOURCES gt lt RESOURCES gt lt APPLICATIONS gt lt APPLICATIONS gt lt ENTITIES gt lt RELATIONS gt lt BEHAVIOURS gt BEHAVIOUR userID biadmin roleName spagobi admin gt BEHAVIOUR userID bidev roleName spagobi dev gt lt BEHAVIOURS gt lt PRIVILEDGES gt lt PRIVILEDGE lt PRIVILEDGE lt PRIVILEDGE lt PRIVILEDGE lt PRIVILEDGE lt PRIVILEDGE lt PRIVILEDGE lt PRIVILEDGE lt PRIVILEDGE lt PRIVILEDGE roleName spagobi admin roleName spagobi admin roleName spagobi admin roleName spagobi admin roleName spagobi admin roleName spagobi admin roleName spagobi admin roleName spagobi admin roleName spagobi admin roleName spagobi admin functionalityName EnginesManagement gt functionalityName FunctionalitiesManagement gt functionalityName LovsManagement gt functionalityName ConstraintManagement gt functionalityName ParameterManagement gt functionalityName DocumentAdministration gt functionalityName ImportExport gt functionality
38. pace 4 6 4 Install SpagoBIBirtReportEngine Connect to http forge objectweb org projects spagobi select the file tab and then download the file SpagoBIBirtReportEngine bin 1 9 4_xxx zip Extract from the zip archive the file SpagoBIBirtReportEngine war and rename it as SpagoBIBirtReportEngine zip Create a new folder named SpagoBlIBirtReportEngine war and unzip the file SpagoBIBirtReportEngine zip inside it Delete the SpagoBIBirtReportEngine zip file and copy the parent SpagoBIBirtReportEngine war directory into JBOSS HOME server default deploy folder Remove the following jar files from JBOSS HOME server default deploy SpagoBIBirtReportEngine war WEB INF lib Olog4j 1 2 8 jar Using the SpagoBI administration web application define a new External Engine with see chapter 4 7 Configure external engines Odocument type Report Oengine type External Odriver class it eng spagobi drivers birt BirtReportDriver Ourl http server port SpagoBIBirtReportEngine BirtReportServlet 4 6 5 Install SpagoBIWekaEngine Connect to http forge objectweb org projects spagobi select the file tab and then download the file SpagoBIWekaEngine bin 1 9 4_xxx zip Extract from the zip archive the file SpagoBIWekaEngine war and rename it as SpagoBIWekaEngine zip Create a new folder named SpagoBIWekaEngine war and unzip the file SpagoBIWekaEngine zip inside it Delete the SpagoBIWekaEngine zip file and copy the parent SpagoBIWeka
39. repeated four times org quartz jobStore driverDelegateClass based on your SpagoBI database server HSQLDB Oracle you have to uncomment the right one and obviously to comment the others to comment a row just place a at the beginning The SpagoBI scheduler feature is based on Quartz technology Quartz is a library which can store its metadata into a database For the SpagoBI installation the quartz metadata database can be the same as the SpagoBI one In order to configure it do the following steps edit the file JBOSS HOME server default deploy spagobi war WEB INF classes quartz properties search the string job store delegate class Under this split line there s the same property repeated four times org quartz jobStore driverDelegateClass Based on your SpagoBI database server HSQLDB Oracle you have to uncomment the right one and obviously to comment the others to comment a row just place a at the beginning search the string org quartz dataSource quartz jndiURL and comment it type a as the first characther of the row search the string org quartz dataSource quartz driver and change its value putting the driver class name for your SpagoBI metadata database search the string org quartz dataSource quartz URL and change its value putting the url of your SpagoBI metadata database search the string org quartz dataSource quartz user and org quartz dataSource quartz password and change their values putting the username a
40. rofile HOST server that hosts the LDAP system PORT connection port OBJECTCLASS class that is used for users research SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 14 of 29 Engineering Ingegneria Informatica S p A 2005 This work is licensed E greative under the Creative Commons Attribution NonCommercial ShareAlike A Y ons License To view a copy of this license visit to C OCM MO NS DEED http creativecommons org licenses by nc sa 2 0 SpagoBI Web Application Jboss 4 0 3SP1 SP Bf Installation Manual 1 0 0 insa Intelligence Fras P latfem 1 SEARCH_ROOT initial path for users research OU_ATTRIBUTE name of the user attribute that identifies the belonging group SEARCH_ROOT_GROUP initial path for groups research OBJECT_CLASS_GROUP class that is used for groups research ATTRIBUTES ID GROUP groups attributes Note for security reason the administration password characters must be edited using Spago DefaultCipher class SpagoBI verifies if a user role is authorized to perform a certain action in order to permit this you have to associate each role to its set of permitted functionalities in file TOMCAT HOME webapps spagobi WEB INF conf sbiwa_Idap_authorizations xml lt ENTITIES gt lt FUNCTIONALITIES gt lt FUNCTIONALITY functionalityName EnginesManagement description EnginesManagement gt lt FUNCTIONALITY functionalityName FunctionalitiesMana
41. security XmlSecurityProviderImpl gt Ms className lt CONFIG gt lt PORTAL SECURITY CLASS gt lt USER PROFILE FACTORY CLASS it eng spagobi security XmlUserProfileFactoryImpl gt i className lt ROLE NAME PATTERN FILTER gt lt ROLE NAME PATTERN FILTER gt lt SECURITY gt 1 gt Comment this part lt Exo security Provider gt daz SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 17 of 29 License To view a copy of this license visit C OCM MO UN S DEED http creativecommons org licenses by nc sa 2 0 Engineering Ingegneria Informatica S p A 2005 This work is licensed E greative ons under the Creative Commons Attribution NonCommercial ShareAlike By v 9 X Spa SpagoBI Web Application Jboss 4 0 3SP1 lt p Installation Manual 1 0 0 lt SECURITY gt lt PORTAL SECURITY INIT CLASS gt it eng spagobi security init ExoPortalSecurityProviderInit lt PORTAL SECURITY INIT CLASS gt lt PORTAL SECURITY CLASS className it eng spagobi security ExoGroupAsRoleSecurityProviderImp1 gt lt CONFIG gt lt NAME_PORTAL_APPLICATION gt portal lt NAME_PORTAL_APPLICATION gt lt CONFIG gt lt PORTAL SECURITY CLASS gt lt USER PROFILE FACTORY CLASS className it eng spagobi security ExoGroupAsRoleUserProfileFactoryImpl gt lt USER PROFILE FACTORY CLASS gt lt ROLE NAME PATTERN FILTER gt lt ROLE NAME PATTER
42. t goal This document provides a step by step description for SpagoBI 1 9 4 Web Application installation and configuration on a Jboss Server 4 0 3SP1 To get a working copy of a JBoss 4 0 3SP1 server you can download from Jboss download page the file jboss 4 0 3SP1 zip and simply unzip it into your file system download from the JBoss site the version JBoss 4 0 3SP1 and unzip it into your file system jboss home Here there is the direct link to the jboss 4 0 3SP1 zip MS Windows or jboss 4 0 3SP1 tar gz Linux Unix file http sourceforge net project showfiles php group_id 22866 amp package_id 16942 amp release_id 365509 remove all the libraries contained into jboss home lib endorsed resolver jar xalan jar xercesImpl jar xml apis jar 3 References Some of the concepts of this document refer to the following documentation SpagoBI business intelligence platform framework available at http spagobi eng it 1 Spago framework available at http spago eng it JBoss application server available at http www jboss org 4 Install SpagoBI We assume that you use the java version 1 5 x and that you have correctly installed a Jboss 4 0 3SP1 server in the following we will refer to the Jboss base directory as JBOSS HOME or here the home spagobi spagobi 194 jboss 4 0 3SP1 directory To test the Jboss installation go to JBOSS HOME bin and run the command run bat in a windows environment or run sh in a unix environment wait
43. talAddress postalCode postOfficeBox ipreferredDeliveryMethod registeredAddress seedlso ist street teletexTerminalIdentifier ItelexNumber x121Address Connected To Idap localhost 389 Submit Jl Reset Jl Change Class Jl Properties SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 13 of 29 Engineering Ingegneria Informatica S p A 2005 This work is licensed under the Creative Commons Attribution NonCommercial ShareAlike License To view a copy of this license visit http creativecommons org licenses by nc sa 2 0 Egreative commons COMMONS DEED SpagoBI Web Application Jboss 4 0 3SP1 SP B Installation Manual 1 0 0 s Intelligence Free Platformi 1 The user biadmin is associated to the groups by specifing the DN of the group in the ou attribute for example ou Gruppo_A ou Group dc spagobi dc com An example of ldif file with a definition of bidev user is the following dn uid bidev ou People dc spagobi dc org objectClass top objectClass person objectClass organizationalPerson ou ou Gruppo_A ou Group dc spagobi dc com cn bidev sn bidev givenName bidev mail bidev spagobi org userPassword Inside TOMCAT INST FILES Idif you find an example ldif schema When you have decided the groups users structure on LDAP system you have to verif
44. until the command ends up with the message Server JBoss MX MicroKernel 4 0 3SP1 build CVSTag JBoss 4 0 3 SP1 date 200510231054 Started in xs xxx ms and then connect with a browser to the url SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 3 of 29 ti Engineering Ingegneria Informatica S p A 2005 This work is licensed coetrea Ive under the Creative Commons Attribution NonCommercial ShareAlike e commons License To view a copy of this license visit t C OCM MONS D EED http creativecommons org licenses by nc sa 2 0 SpoqeB SpagoBI Web Application Jboss 4 0 3SP1 lt p Installation Manual 1 0 0 http lt lt localhost gt gt 8080 the Tomcat default home page should appear Before proceed stop the server 1 We choose to install Jboss in the home spagobi spagobi 194 2 Copy the file jboss 4 0 3SP1 targz in the home spagobi spagobi 194 directory or a directory that you choose for installing 3 Go in the home spagobi spagobi 194 directory and uncompress the jboss 4 0 3SP1 tar gz file with tar ang gzip command line 4 remove all the libraries contained into home spagobi spagobi 194 jboss 4 0 3SP1 lib endorsed resolver jar xalan jar xercesImpl jar xml apis jar 5 Here we have now the home spagobi spagobi 194 jboss 4 0 3SP1 directory for the jboss home directory Connect to the SpagoBI page on the OW2 Forge http forge objectweb org proj
45. y that configuration files are suitable for the previous choices Edit JBOSS HOME server default deploy spagobi war WEB INF conf sbiwa_Idap_authorizations xml and check the information it contains lt CONFIG gt lt USER_DN gt cn ou People dc spagobi dc com lt USER_DN gt lt ADMIN_USER gt cn root dc spagobi dc com lt ADMIN_USER gt lt ADMIN_PSwW gt lt ADMIN_PSW gt lt ATTRIBUTES_ID name nome gt description lt ATTRIBUTES_ID gt lt ATTRIBUTES_ID name cognome gt sn lt ATTRIBUTES_ID gt ATTRIBUTES ID name userId gt cn lt ATTRIBUTES_ID gt ATTRIBUTES ID name titolo gt title lt ATTRIBUTES_ID gt ATTRIBUTES ID name telefono gt telephoneNumber lt ATTRIBUTES_ID gt HOST localhostc HOST lt PORT gt 389 lt PORT gt lt OBJECTCLASS gt person lt OBJECTCLASS gt lt SEARCH_ROOT gt ou People dc spagobi dc com lt SEARCH_ROOT gt lt OU_ATTRIBUTE gt ou lt 0U_ATTRIBUTE gt lt SEARCH_ROOT_GROUP gt ou Group dc spagobi dc com lt SEARCH_ROOT_GROUP gt lt OBJECTCLASS_GROUP gt organizationalUnit lt OBJECTCLASS_GROUP gt lt ATTRIBUTES_ID_GROUP gt description lt ATTRIBUTES_ID_GROUP gt lt ATTRIBUTES_ID_GROUP gt OU lt ATTRIBUTES_ID_GROUP gt lt CONFIG gt where USER_DN it is the users DN format character will be substitued by user identifier ADMIN_USER administration LDAP user used for connection ATTRIBUTES_ID attributes list that will be retrieved by the LDAP system and loaded into user p
46. you use a unix based environment you have to adjust also your Java installation directory Using the SpagoBI administration web application define a new External Engine with see chapter 4 7 Configure external engines SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 22 of 29 ti Engineering Ingegneria Informatica S p A 2005 This work is licensed coetrea Ive under the Creative Commons Attribution NonCommercial ShareAlike lt Y commons License To view a copy of this license visit t C OCM MONS D EED http creativecommons org licenses by nc sa 2 0 X SpagsB SpagoBI Web Application Jboss 4 0 3SP1 lt p Installation Manual 1 0 0 Odocument type ETL Oengine type External Odriver class it eng spagobi drivers talend TalendDriver Ourl http lt server gt lt port gt SpagoBITalendEngine JobRunService Pay attention at the path form also for Windows system it must contain only separator and it must start with no c for example SpagoBI Web Application Jboss 4 0 3SP1 Installation Manual ver 1 0 0 October 2 2008 page 23 of 29 ti Engineering Ingegneria Informatica S p A 2005 This work is licensed coetrea Ive under the Creative Commons Attribution NonCommercial ShareAlike AN commons License To view a copy of this license visit t C OCM MONS D EED http creativecommons org licenses by nc sa 2 0 X SpagsB SpagoBI Web Appl

SpagoBI Installation Manual

Contents

Download Pdf Manuals

Related Search

Related Contents