SE-1861 # Adding a new column to an existing table when a default value needs to be set results in SQL to update the entire table. For a table with a large number of rows, this causes a large transaction log in Microsoft SQL Server. To prevent this, large table updates on Microsoft SQL Server will be batched into increments of 10k rows when the Optimized Schema is in use. ...
The Life MTK CSV File Utilities consist of two parts, the export utility and the helper utility. The export utility is meant as an aid in the migration process. A domain object (business, business partner, bank, etc.) can be exported from the SICS system to a CSV file. This file can then be used as an example of how a CSV file should be constructed. The helper utility can be used to view the structure of the parts of a domain object. ...
In this document the term "MTK" will be an alias for "Migration Tool Kit". This document explains the concepts of the MTK and how to load data from a CSV file into SICS. Performance # It is possible to execute data migrations on more than one machine at a time; however, each set of data has to be independent of any other migration. e.g. Split the input file containing business partners into several files where all information related to one single business partner is gathered in one file. ...
Purpose # MTK Splitter tool is a utility to split large CSV migration upload files into a set of smaller files of manageable size which can be easily uploaded by the MTK loader. Abbreviation # In this document the term "MTK" will be an alias for "Migration Tool Kit". This document explains the concepts of the MTK Splitter and how to load data and Split Files from a CSV file into SICS. ...
This section describes to setup database connections to various database systems for SAP BusinessObjects Enterprise. Note: The SAP BusinessObjects Enterprise install directory is referred to as <install directory>. Microsoft SQL Server # Note: The newest possible version of Microsoft SQL Server JDBC Driver that can be used by SAP BusinessObjects Enterprise is 6.4 because JRE 7 support was dropped in version 7.0. Download the Microsoft JDBC Driver Version 6.4 from: Release Notes for the JDBC Driver: 6. ...
The following actions are required to export a domain object: Choose the type of domain object to export in the root objects drop-down list. You must provide the object ID unless the unique criteria of the record are unique in the database. Select a filename to export to. Press Start Export. A file with the name that was designated in the field Output file will be generated. Figure 2 - Migration Manager Window
Start the MTK Loader # Start the SICS Life Administration Utility as explained in the installation procedure. Open the Inbound Interfaces Folder and Migration Toolkit Folder and double click on the Migration Utility icon. This procedure will then start the Migration Manager. Figure 1 - Life System Admin Desktop SICS Migration Manager # Figure 2 - SICS Migration Manager Input File The name of the file containing the data that you want to migrate into SICS. ...
Starting the Tool # Start the SICS P&C Administration Utility as explained in the installation procedure. Open the Inbound Interfaces Folder and Migration Toolkit Folder and double click on the Split Input File Utility icon. This starts the Migration Toolkit File Splitter. Figure 1 - SICS System Admin Desktop
This section describes to setup database connections to various database systems for SAP BusinessObjects BI 4.3. Note: The SAP BusinessObjects BI 4.3 install directory is referred to as <install directory>. Microsoft SQL Server # Note: SAP BusinessObjects BI 4.3 is using JRE 8, therefore, the JRE 8 version of the Microsoft JDBC Driver need to be used. Download the Microsoft JDBC Driver from: Download Microsoft JDBC Driver for SQL Server. ...
The helper utility can be used to view the structure of the CSV definitions. It is possible to navigate down from a root object and view its parts. When an object is selected in the tree view the row definition is displayed in the Details view at the bottom. It is also possible to view a sample output line for the row definition by selecting the Example Line page. Figure 3 - Helper Utility Tab