ONESOURCE – Tax & Accounting – Thomson Reuters:- DataServices (MS SQL/Windows) Installation

[patelyogesh]

You successfully installed Reporting and now you are on next step to install Data Services

• Run setup.exe from extracted source
  
  
  
  • Use same CMS and business object you installed previously
  
  
  • Install with default configuration
  
  
  • Select next on components selection screen
  
  
  • Registration Name of CMS: ETL_REPO
  
  
  • DB:ETL_REPO
  
  
  • User: ETL_REPO
  
  
  • Password:
  
  
  • Run as system account
  
  
  
  

 

• Stop SIA and restart Server after installation completed

 

• Login to Data Service Server and open Data Service Server Manager
  
  
  
  • Open Configuration Editor> job server > edit
    
    
    
    • Uncheck Use SSL Protocol for…. (2^nd option)
    
    
    • Checked Support adapter…(1^st option)
    
    
    
    
  
  
  • On miscellaneous tab
    
    
    
    • Configure email settings
    
    
    
    
  
  
  • Click close and restart
  
  
  
  

 

• Stop and Start SIA (SAP BusinessObject)

 

• Open CMC

 

• Open Servers in CMC and open properties of EIMAdaptiveProcessingServer (Server)
  
  
  
  • In Command line edit between -server….-Djava.awt.headless=true {-Dcom.sun.net.ssl.enableECC=false} "-Dbobj.enterprise.home
  
  
  • Restart Server Service
  
  
  
  

 

• Add Administrator user in to all Data Services * groups

• Open Data services http://host:port\DataServices and login with Administrator user

 

• Open Administration > web services > web Services configuration (right side)
  
  
  
  • Change remove to disable session security (Make sure you select all check boxes)
  
  
  
  

 

• In Adaptive > job adapter configuration > web services
  
  
  
  • Adapter retry = 5
  
  
  • 30000 = 150000
  
  
  
  

• TAB (Adapter Instance Status)
  
  
  
  • Web service select > shutdown and start
  
  
  
  

 

• Open reporting installation source and run install\ONESOURCEInstallationConfigurator.jar
  
  
  
  • Reporting Server DB, Version, Server Name
  
  
  • Password, DB Name, Create DB URL, Test DB Connection (sqlijdbc4.jar from tomcat lib folder)
  
  
  • Uncheck Use Reporting Database, Server name (If this is not on same server)
  
  
  • Password, DB Name, Create DB URL, Test DB Connection
  
  
  • Server Name (CMS), Password, Tomcat Server Name, Test Web Service
  
  
  • Create ‘recon’ folder in Program Files (x86)\SAP BusinessObjects
    
    
    
    • Source : R:\Program Files (x86)\SAP BusinessObjects\recon
    
    
    • Error : R:\Program Files (x86)\SAP BusinessObjects\recon
    
    
    
    
  
  
  • Server name, Create URL
  
  
  • Save and close
  
  
  • Provide file name ‘installation-config’
  
  
  • Copy Documents\installation-config.xml to ONESOURCEIDTReporting_6600\
  
  
  • Copy sqljdbc4.jar to C:\temp
  
  
  • Edit install.bat
    
    
    
    • scripts\reporting-install.bat -o "C:\temp\sqljdbc4.jar" -c "C:\source\TAX\Reporting\ONESOURCEIDTReporting_6600\install\Installation-config.xml"
    
    
    
    
  
  
  • Run query on SBXAUD DB: alter table sbxaud.RS_INVOICE_LINE_TAXES ADD COMPLIANCE_AREA_UUID varchar(32)
  
  
  • Run install.bat in administrator mode
  
  
  
  

 

• Stop Reporting tomcat

 

• Copy reporting.war and reporting-private-ws.war from deployments\tomcat to tomcat’s webapp

 

• Copy reporting-configuration.jar from deployments\tomcat to tomcat’s lib

 

• Open deployments\tomcat\reporting-combined-context.xml and copy content between line 6 to 30 to tomcat\conf\context.xml at line 34

 

• Stop Data Service through windows services
  
  
  
  • Open C:\ProgramData\SAP BusinessObjects\Data Services\conf\admin.xml
  
  
  • Edit admin.xml
    
    
    
    • Line 43 <js-socket-timeout> 900000</js-socket-timeout>
    
    
    
    
  
  
  • Edit DSConfig.txt
    
    
    
    • Line 136 Replace_Substr_Max_Return_Size_Characters = 500500
    
    
    
    
  
  
  • Start Data Services service on window
  
  
  
  

 

• Start Reporting Tomcat

 

• Open Sabrix http://host:port/sabrix/
  
  
  
  • Menu > System > Config> change : REPORTING_URL =
  
  
  • Open reporting from menu on sabrix
  
  
  
  

 

• Login to data services
  
  
  
  • Administration > Batch > ETL_REPO > Batch job configuration > SBX_STAGE_Load (Run this once)
    
    
    
    • Type: ‘CUSTOM’
    
    
    • Start date: ‘yyyy.mm.dd’ (According to requirement)
    
    
    • End date: ‘yyyy.mm.dd’ (According to requirement)
    
    
    • G_PERFORM_JOB_AUDIT has value N
    
    
    
    
  
  
  • Administration > Batch > ETL_REPO > Batchjob configuration > OP_User_Access_Load > execute > execute button (Run this once)
  
  
  
  

 

Note: Make sure functional consultant schedule jobs as per requirements.

 

You successfully installed DataServices software. Now we are going to configure SAP and ONESOURCE integration

Thank you

Yogesh