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

[patelyogesh]

You successfully installed Data File Integrator (DFI) and now you are on next step to install Reporting

• Install 7.ZIP (This is what extract files faster)

• Extract installation files using 7zip
  
  
  
  • Data Services
  
  
  • BOBj
  
  
  
  

• Run \scripts\CreateReportingUsersAndTablespaces_SQLServer.bat to create DB and users


• Create ODBC connection to RPT_REPO database using c:\Windows\System32\odbcad32.exe (Native)
  
  
  
  • System DSN
  
  
  • Name: RPT_REPO
  
  
  • Server : hostname
  
  
  • SQL Authentication
    
    
    
    • User : RPT_REPO and Password
    
    
    
    
  
  
  
  

• Run Setup.exe of BOBJ installation : DC00R-6WE0G3M-W70WP04-GA200WC-7D
  
  
  
  • Custom install
  
  
  • Software selection (Installation Guide)
  
  
  • Start New
  
  
  • No Auditing DB
  
  
  • RPT_REPO and Select Reset Existing DB
  
  
  
  

Select Components as shown below:



Installation is successful

• Copy sqljdbc4.jar to tomcat’s lib folder of business object

• Edit SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\CRConfig.xml
  
  
  
  • In line 15 add = R:\Program Files (x86)\SAP BusinessObjects\tomcat\lib\sqljdbc4.jar;
  
  
  
  

<Classpath>R:\Program Files (x86)\SAP BusinessObjects\tomcat\lib\sqljdbc4.jar;R:\Program Files (x86)\SAP .................. </Classpath>

• Add “R:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\sapjvm\bin” to System environment variable PATH

• Open CMC
  
  
  
  • Don’t show and close
  
  
  • Servers and open Server lists
  
  
  • Open Adaptive Job Server and open properties
  
  
  • In Command line parameters add:
    

    -RequestTimeout 6000000​

    
    
  
  
  • Restart server Service
  
  
  
  

• Log off CMC

 

You successfully installed Certificate Manager software. Now we are going to install Data Services

Thank you

Yogesh