Skip to main content

Install Deploy Utility

The ‘Deploy’ utility included in the SAP Central Finance Master Data Replication by insightsoftware for SAP S/4HANA enables the deployment of virtual database objects in the target SAP HANA database that hosts SAP S/4 HANA.

Note: This new method for deploying virtual objects that does not require XSA runtime was introduced in version 6.0 SP01. You can refer to the Virtual Deployment Guide available on the Partner Product page for more information.

The utility package includes the following components:

  • \data folder containing .sql statements for views, virtual tables, user creation and role creation with grant permissions.
  • \lib folder containing hdbsql.exe, the SAP HANA database command line utility.
  • config.xml.
  • Install.bat for Windows operating system.
  • Install.sh for Linux Red Hat and SUSE operating systems.
  • \log folder containing the logs generated by utility post installation. These log files follow the naming pattern ‘install_log_DDMMYYYY_HHMMSS.txt’.

Architecture

The following architecture diagram depicts the overall user journey and role of each component in the process.

Detailed Process for Deploying Virtual Objects using the ‘Deploy’ Utility

This section covers the procedures that you must follow to deploy the virtual objects on SAP HANA database.

Note: This method serves as an alternative to the ‘Install Multitarget Application (MTA)’ process outlined in the SAP Central Finance Master Data Replication by insightsoftware Installation and Configuration Guide. If you have already completed the deployment of virtual objects using the MTAR on XSA runtime successfully, you may disregard this procedure.

To deploy virtual objects on SAP HANA using Windows

  1. Download the S4_HANA_DB_Objects_MasterData_Windows.zip file placed in the product folder.
  2. Extract the zipped file contents to a folder and navigate to it.
  3. Edit the config.xml file as directed in the following screenshots.

    Note: If you do not enter passwords or any other values while editing the config.xml file, you will be prompted to enter them during run time.

    Enter the CFIN admin credentials to log in as admin. Enter the desired user name and password to create a new user.

    <admin_credentials> Admin credentials for connecting to CFIN database.

    <cfin_admin_username> Admin username for CFIN database usually SYSTEM

    <cfin_admin_password> - Password for admin user

    <isw_user_credentials> - User credentials which will be used for creating the virtual objects. Here you can provide a new username (if you want to create a new user) or you can use existing user credentials.

    Note: If you are redeploying the objects that were created earlier using XSA then you must enter the SYSTEM user credentials for these tags.

    <cfin_isw_username> - Enter ISW username or SYSTEM

    <cfin_isw_password> - Password of the user

    <cfin_schema> - Enter the schema name under which the virtual objects must be created. For example, MAGSW_SC.

    <cfin_server> - Server details for CFIN database

    <cfin_port> - Port for CFIN database

    Upon running the mentioned commands, a new user is created with the role that has the following permissions.

    For SAP HANA as the staging database, enter the values according to your specific configuration.

    <stage database=”HANA”>

    <stage username> - username to login to staging username

    <stage password> - password to login to staging database

    <stage server> - server details for staging database

    <stage port> - port details for staging database

    <stage_remote_source> - Name of the remote source connection that will be created. For example, MAGSW_STAGE.

    For Microsoft SQL as the staging database, enter the values according to your specific configuration.

    For MSSQL staging database, enter the following new fields:

    • <stage_dsn_name> - Name of the data source (From the following example, HYDDEVSCT09)
    • <stage_database> - Name of the stage database (From the following example, SCT_STAGE)

    The aforementioned details can be found in the .odbc.ini file, which is a prerequisite to create remote source connection to MSSQL stage, a sample file appears as follows:

  4. Run the following command to install the utility.
    ./Install.bat
  5. Check the logs and re-run the utility after resolving the errors that may be present.

To deploy virtual objects on SAP HANA using Linux

  1. Download the S4_HANA_DB_Objects_MasterData_Linux.tar.gz file placed in the product folder.

    Note: If you are deploying virtual objects for both Transaction Replication and Master Data Replication products, it is advised to extract the artefacts of each and store them in different folders.

  2. Run the following command to extract the .tar.gz file contents to a folder:
    tar -xvf S4_HANA_DB_Objects_MasterData_Linux.tar.gz

    Note: Make sure your Linux package includes the dos2unix software. To install it, run the following commands:

    For Red Hat Enterprise Linux:sudo yum install dos2unix -y
    For SUSE Linux:sudo zypper install dos2unix
  3. Navigate to the folder and run the following command to convert the EOL characters in the shell script for both Red Hat and SUSE Linux.
    dos2unix Install.sh
  4. Run the following command to grant the execute permission for the shell script.
    sudo chmod 755 Install.sh
  5. Run the following command to grant the required permissions to all the files and folders.
    sudo chmod -R 755 <folder name>

  6. Edit the config.xml file as directed in the following screenshots.

    Note: If you do not enter passwords or any other values while editing the config.xml file, you will be prompted to enter them during run time.

    Enter the CFIN admin credentials to log in as admin. Enter the desired user name and password to create a new user.

    <admin_credentials> Admin credentials for connecting to CFIN database.

    <cfin_admin_username> Admin username for CFIN database usually SYSTEM

    <cfin_admin_password> - Password for admin user

    <isw_user_credentials> - User credentials which will be used for creating the virtual objects. Here you can provide a new username (if you want to create a new user) or you can use existing user credentials.

    Note: If you are redeploying the objects that were created earlier using XSA then you must enter the SYSTEM user credentials for these tags.

    <cfin_isw_username> - Enter ISW username or SYSTEM

    <cfin_isw_password> - Password of the user

    <cfin_schema> - Enter the schema name under which the virtual objects must be created. For example, MAGSW_SC.

    <cfin_server> - Server details for CFIN database

    <cfin_port> - Port for CFIN database

    Upon running the mentioned commands, a new user is created with the role that has the following permissions.

    For SAP HANA as the staging database, enter the values according to your specific configuration.

    <stage database=”HANA”>

    <stage username> - username to login to staging username

    <stage password> - password to login to staging database

    <stage server> - server details for staging database

    <stage port> - port details for staging database

    <stage_remote_source> - Name of the remote source connection that will be created. For example, MAGSW_STAGE.

    For Microsoft SQL as the staging database, enter the values according to your specific configuration.

    For MSSQL staging database, enter the following new fields:

    • <stage_dsn_name> - Name of the data source (From the following example, HYDDEVSCT09)
    • <stage_database> - Name of the stage database (From the following example, SCT_STAGE)

    The aforementioned details can be found in the .odbc.ini file, which is a prerequisite to create remote source connection to MSSQL stage, a sample file appears as follows:

  7. Run the following command to install the utility.
    ./Install.sh
  8. Check the logs and re-run the utility after resolving the errors that may be present.

Was this article helpful?

We're sorry to hear that.