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
      • Note : This URL is from http://host:port/sabrix/services/
    • 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

• Open http://host:port/dfi-installer

• 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

• Open http://host:port/data-file-integrator/

• 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