Skip to Content

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

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

  • Install tomcat (Same as other products)
  • Run \Docs\database-creation-scripts\sql-server\CreateSqlServerUserAndDatabase.bat (Change log file location as per standard)
  • Copy \Docs\application-server-files\logback.xml in to ‘conf’ folder of tomcat
  • Copy Docs\application-server-files\tomcat\jmxremote.access and jmxremote.password to conf folder of tomcat
  • Copy content of \tomcat\datasource-files\SQL Server DataSource Template.txt paste in server.xml (line 40 and 41)
<Resource name="jdbc/DataFileIntegratorDataSource" 
    auth="Container"
    type="javax.sql.DataSource"
    username="sbxdfi"
    password="password"
    driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
    url="jdbc:sqlserver://HOSTNAME:1433;databasename=SBXDFI;"
    validationQuery="select 1"
    maxTotal="10"
    maxIdle="4"/>
  • Copy \Docs\application-server-files\dataFileIntegrator.properties to tomcat’s ‘lib’ folder
      • Edit file and add determination.service.authentication.url=http://host:port/sabrix/services/userservice/2011-09-01/userservice?wsdl
      • determination.service.authentication.iscloud=false
#
# Copyright 2016 Thomson Reuters/ONESOURCE. All rights reserved.
#

# WSDL location for determination user service. Do not forget '?wsdl' at the end
determination.service.authentication.url=http://HOSTNAME:PORT/sabrix/services/userservice/2011-09-01/userservice?wsdl

# Indicate if the authentication service mentioned above is cloud service or not. (Accepted valules: true/false)
determination.service.authentication.iscloud=false

# Integer value of session timeout time for the application, in minutes. Max allowed value: 10080 (1 Week), default: 30, if property is omitted.
application.timeout.time=30

Note: Change URL as you required for : determination.service.authentication.url

  • Open tomcat configuration and change memory to 2048 and 2048 (Set as per your requirments)
    • Add java options as below
      • -Dcom.sun.management.jmxremote=True
      • -Dcom.sun.management.jmxremote.ssl=False
      • -Dcom.sun.management.jmxremote.authenticate=True
      • -Dis.tomcat=True
      • -Djava.rmi.server.hostname=Servername
      • -Dcom.sun.management.jmxremote.password.file=../conf/jmxremote.password
      • -Dcom.sun.management.jmxremote.access.file=../conf/jmxremote.access
      • -Dlogback.configurationFile=../conf/logback.xm
  • Copy sqljdbc4.jar to tomcat’s ‘lib’ folder
  • Copy \WarFiles\ dfi-installer.war to tomcat’s ‘webapp’ folder
  • Start Tomcat
  • Stop tomcat once you see OK message on installer
  • Delete installer folder and war file from tomcat webapp folder
  • Copy all another job-consumer-app.war, file-watcher-app.war, data-file-integrator.war to webapp of tomcat
  • Copy folder “ DataFileIntegrator “ from Docs\file-watcher-directory-structure to ROOT of DFI installation
    • Rename company A folder inside to “ Your Company Name” (You have assigned this company to User with ‘Certificate Manager Admin’ role)
  • Start Tomcat
  • Login with created user
  • Click configure
    • Provide created user and password
    • Open determination service URLand paste in Base URL of configuration
    • Certificate manager Base URL : http://host:port/cm-soap-service-app/
    • File Source Directory : J:\ (As you copy ‘DataFileIntegrator’ folder)
    • File processing threads : 2
    • Email configuration:

  • Under Services Dropdown select : UserService – FindUser
    • Under Input TAB
      • User: name
      • Default: DBA
      • Test: DBA
    • Save mapping name as: FindUser
    • Output TAB
      • Select Message move over and save mapping
      • Test to see if you can find users or not
  •  Share DataFileIntegrator folder root of J:\ so functional users can perform data load.

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

 

Thank you

Yogesh

Be the first to leave a comment
You must be Logged on to comment or reply to a post.