Skip to Content

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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply