Installing Operational Ledger

Operational Ledger comes in two distinct installation packages, suitable for different usage:

  • Operational Ledger, a stand-alone product that can be installed to be used with other Lighthouse or Northstar products.

  • Operational Ledger Add-On, an add-on to be installed on top of the Core Banking & Operational Ledger packages with the same version.

The installation for both packages is a process of running two install_SysPack.bat files on your environment.

NOTE  
You must run the scripts on the machine where Innovation Studio is installed. Make sure you have access rights to Studio's database.

This page contains the installation steps specific to the Operational Ledger packages available for the v3.3 release:

Follow the steps described below to perform an automatic installation of the Operational Ledger v3.3.

Dependencies

In order to install Operational Ledger v3.3, first you need to install the following:

  • Innovation Studio minimum version v22.1.1

  • SySDigitalSolutionPackages minimum version v22.1.1000

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

Pre-Installation Checklist

The SysPack has a unique constraint 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.3 is imported.

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

Installation Steps

  1. Unzip your Operational Ledger v3.3 archive file.

  2. Locate the FtosSysPkgDeployer folder in the FintechOS installation kit (the path is <unzipped_install_archive>\Tools\FtosSysPkgDeployer). You need it to install the Operational Ledger v3.3.

  3. Select and copy the FtosSysPkgDeployer folder.

  4. Navigate to the location where you have unzipped the Operational Ledger v3.3 (let’s call this location <pckg_deployer_dir>), then paste the FtosSysPkgDeployer folder there, within each and every zip file that comes with the package.


    IMPORTANT!  
    Each zip file within the Operational Ledger v3.3.zip must be extracted and installed separately, in the given order!

  5. Create a new or edit a previous install_Syspack.bat file. Replace the parameters described in the install_SysPack.bat Parameters Explanation section with your own values. Save and close the file.

  6. Right-click install_SysPack.bat » Run, for each package.

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:

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

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>\01 DeploymentPackages\*.zip"

 

Copy

install_SysPack.bat syntax for Data import

FtosSysPkgDeployer.exe -g -s "<StudioLink>" -u <AdminStudioUser> -p <user_password> -r "<syspack_path>\02 ConfigurationDataDeploymentPackages\*.zip"
NOTE  

The syntax presented here is for information purposes only. Please run the actual install_SysPack.bat file.

  • <StudioLink> - The web URL of the Innovation Studio installation, for example http://localhost/ftos_studio.

  • <AdminStudioUser> - The username of the Innovation Studio user under which this import is executed. The user has to exist in Innovation Studio prior to this operation.

  • <user_password> - The password for the Innovation Studio user.

  • <DataBaseServer> - The name of the database server where the FintechOS installation database was created.

  • <DB_user> - The username of the SQL Server user with administration rights on the FintechOS installation database.

  • <DB_user_password> - The password for the above mentioned SQL user.

  • <TheNameOfTheDataBase> - The name of the database where the Operational Ledger v3.3 is deployed.

  • <syspack_path> - The physical path to the unzipped Operational Ledger v3.3 previously downloaded.

HINT  

For more information about the script, please run FtosSysPackageDeployer.exe without any arguments to see the built-in help.
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.

Follow the steps described below to perform an automatic installation of the Operational Ledger Add-On.

Dependencies

In order to install Operational Ledger Add-On v3.3, first you need to install the following:

  • Innovation Studio minimum version v22.1.1

  • SySDigitalSolutionPackages minimum version v22.1.1000

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

  • Core Banking v3.3

  • Operational Ledger v3.3.

Installation Steps

  1. Unzip your Operational Ledger AddOn v3.3 archive file.

  2. Locate the FtosSysPkgDeployer folder in the FintechOS installation kit (the path is <unzipped_install_archive>\Tools\FtosSysPkgDeployer). You need it to install the Operational Ledger AddOn v3.3.

  3. Select and copy the FtosSysPkgDeployer folder.

  4. Navigate to the location where you have unzipped the Operational Ledger AddOn v3.3 (let’s call this location <pckg_deployer_dir>), then paste the FtosSysPkgDeployer folder there, within each and every zip file that comes with the package.


    IMPORTANT!  
    Each zip file within the Operational Ledger AddOn v3.3.zip must be extracted and installed separately, in the given order!
    If you decide not to use the default security roles that come with the package, simply skip the General Ledger Security Roles zip file.

  5. Create a new or edit a previous install_Syspack.bat file. Replace the parameters described in the install_SysPack.bat Parameters Explanation section with your own values. Save and close the file.

  6. Right-click install_SysPack.bat » Run, for each package.