Installing Operational Ledger 3.1

HINT  
This page contains the installation steps for Operational Ledger 3.1.
To install the Operation Ledger Add-On 3.1 version, follow the instructions on this page.

The Operational Ledgerv3.1 comes as a stand-alone product that can be installed to be used with other Lighthouse or Northstar products. This is a process of running two install_SysPack.bat files on your environment. Follow the steps described below to perform an automatic installation of the Operational Ledger.

IMPORTANT!  
You must run the script on the machine where FintechOS Studio is installed.
Make sure you have access rights to Studio's database.

Dependencies

In order to install Operational Ledger 3.1, first you need to install the following:

  • FintechOS Studio minimum version v21.2.2.2

  • Standard SysPack minimum version v21.2.2000

  • Banking Product Factory (Project or Standard Pack) v3.1.

Pre-Installation Checklist

The SysPack has a unique constrain on the FTOS_CB_SystemParameter entity.

If you have already moved data using the Configuration Data Deployment Package menu, then you probably have already configured some unique constraints.

Before running the script, make sure you:

  1. Disable the constraints that you have created on your environment, allowing the system to create the new one after Operational Ledger 3.1 is imported.

  2. Use the new Configuration Data Definitions imported with the Operational Ledger 3.1 file when you export the data.

Installation Steps

  1. Download the Operational Ledger 3.1 archive file and unzip it.

  2. Locate the Operational Ledger.zip archive file.

  3. Unzip the Operational Ledger.zip archive file.

  4. Navigate to the location where you have unzipped Operational Ledger and add the first install_SysPack.bat file.

  5. Then, locate the GL Interfaces Library Scripts and open it.

  6. Add the second install_SysPack.bat file to the CBGLAddon_SystemParameter_v1000.xml file.

    The install_SysPack.bat file allows you to import the data model:

    Copy

    install_SysPack.bat syntax for Data Model import

    FtosSysPkgDeployer.exe -i -s "<StudioLink>" -u <AdminStudioUser> -p <user_password> -z <DataBaseServer> -v <DB_user> -k <DB_user_password> -d "<TheNameOfTheDataBase>" -r "<syspack_path>\*.zip"
    NOTE  
    There is no need to unzip the 01.CBGLAddon_SystemParameter_v1000.zip.

The script start running in your Windows console. Wait for it to finish. If the parameter values were correct, the FintechOS Portal has two new menus, visible after a refresh, the General Ledger Configurations and the General Ledger menus:

NOTE  
The syntax presented here is for information purposes only. Please run the actual install_SysPack.bat file.
IMPORTANT!  
If you're using SQL Server Integrated Authentication, make sure that the Windows user used for running the script has access to the FTOS database, with read/ write rights. Run the command without the SQL username/ password parameters.
If you're using SQL Server Build In Authentication, make sure that the SQL Server user has read/ write access to the FTOS database. Run the command with the SQL username/ password parameters.