Skip to Content
Author's profile photo Yogesh Patel

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

You successfully installed Determination and now you are on next step to install Certificate Manager

 

Follow steps below to install Certificate Manager

  • Crate SQL DB and users running Docs\database-creation-scripts\sql-server\CreateSqlServerUserAndDatabase.bat (Make sure you extract new from source)
  • Install Tomcat (Same steps as Determination tomcat installation)
  • Copy WarFiles\installer.war to webapp folder of tomcat
  • Copy content of Docs\application-server-files\tomcat\conf\certificate-manager-data-source-mssql-tomcat.txt
    • Paste this content in conf\server.xml between line 40 and 41
<Resource name="jdbc/TaxCertificateManagerDataSource"
	auth="Container"
	type="javax.sql.DataSource"
	username="certmgr"
	password="password"
	driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
	url="jdbc:sqlserver://HOSTNAME:1433;databasename=certmgr;"
	validationQuery="select 1"
	maxActive="10"
	maxIdle="4"/>

<Resource name="jdbc/UserManagementServiceDataSource"
	auth="Container"
	type="javax.sql.DataSource"
	username="sbxtax"
	password="password"
	driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
	url="jdbc:sqlserver://HOSTNAME:1433;databasename=sbxtax;"
	validationQuery="select 1"
	maxActive="10"
	maxIdle="4"/>

<Resource name="jdbc/ContentManagementServiceDataSource"
	auth="Container"
	type="javax.sql.DataSource"
	username="sbxtax"
	password="password"
	driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
	url="jdbc:sqlserver://HOSTNAME:1433;databasename=sbxtax;"
	validationQuery="select 1"
	maxActive="10"
	maxIdle="4"/>
  • Copy files from installer Docs\application-server-files\tomcat\lib to lib folder of tomcat
    • contentManagementService.properties
    • Change the determination.default_schema=sbxtax
    • #
      # Copyright 2016 Thomson Reuters/ONESOURCE. All rights reserved.
      #
      
      #hibernate.show_sql=true
      determination.default_schema=sbxtax
      hibernate.dialect=com.thomsonreuters.ositax.contentmanagement.common.util.CustomSQLServerDialect
      #hibernate.dialect=com.thomsonreuters.ositax.contentmanagement.common.util.CustomDB2Dialect
    • taxCertificateManager.properties
    • default_schema=certmgr
    • #
      # Copyright 2016 Thomson Reuters/ONESOURCE. All rights reserved.
      #
      
      #hibernate.show_sql=true
      tcm.default_schema=certmgr
      hibernate.dialect=com.thomsonreuters.ositax.contentmanagement.common.util.CustomSQLServerDialect
      #hibernate.dialect=com.thomsonreuters.ositax.contentmanagement.common.util.CustomDB2Dialect
      

 

  • Open and edit Docs\application-server-files\tomcat\bin\setenv.bat
    • Copy -Dlogback.configurationFile=../conf/logback.xml”
    • Open Tomcat Configuration manager (from bin folder *.w.exe)
    • Paste line in JAVA config tab
    • Change memory to 6144 and 6144 (As per your requirements)
  • Copy Docs\application-server-files\tomcat\conf\logback.xml to tomcat’s ‘conf’ folder
  • Copy sqljdbc4.jar to tomat’s ‘lib’ folder
  • Start Tomcat
  • You will see installer OK message
  • Stop tomcat
  • Delete installer.war and installer folder from tomcat’s ‘webapps’ folder after some time
  • Copy WarFiles\cm-soap-service-app.war to tomcat’s ‘webapps’
  • Start Tomcat
  • Copy rest of the files to webapps of tomcat
    • content-management-app.war
    • tax-certificate-manager-app.war
    • user-management-app.war
    • cm-soap-service-app.war
  • Stop and Start Tomcat again
  • Perform email configuration
  • Save system configuration
  • Click ‘install’ logout
  • Login to Determination system and open Menu >> system >> user and create new user

Example as below (create user as per your organization requirement)

  • Login with newly created user to Determination
  • Login with newly created user to certificate manager
  • Admin settings > forms > import
    • Brows file and provide CM.2017.03.1MasterForms.zip (As per date you installing)
  • Logout

You successfully installed Certificate Manager software. Now we are going to install DFI (Data File Integrator)

Assigned Tags

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