Overview
The data setup utility (DSU) is designed to help the user with the
FTM database:
- Initialization and Configuration
- The DSU minimizes the amount of time that is required to initialize and configure a new installation of the FTM database. The DSU allows the user to consolidate the configuration data into spreadsheets instead of having to browse through multiple user interface screens to provide it manually.
- Migration
- The DSU assists the user in migrating Payment Feature Services base and Business Rules configuration data from one environment to another. After the user has a test environment that is configured and running, the tested configuration can be replicated in a different environment, such as a development or production environment. The DSU is used to export the configuration from the test environment and then import it into the different environment.
- Importing and Exporting Participant Versions
- The DSU assists the user in migrating participant directory configuration data. The DSU manages the versions of participant data based on the ID, version, and effective dating when data is imported and exported. When data is exported and imported, effective calendar date (ECD) timestamps are imported and exported as UTC timestamps. When data is imported, if no effective business date (EBD) or ECD data is provided, then the current UTC timestamp is used for ECD. When a participant is imported with the same ID, version, and ECD or EBD, then the tool performs an update. If the dates are different, then the DSU creates a new participant version.
The DSU is a command line utility and does not have a user
interface. Each import, export, delete, and validate operation of
the DSU is controlled by a properties file and a set of workbooks.
The purpose of these files is as follows:
- Configuration Data Workbook
- This workbook contains worksheets with the actual data that is used for the import and created by the export operations. For more information, see Configuration Data Workbook.
- Map Workbook
- This workbook maps the column names that are used in the configuration data worksheets to the column names in the actual database tables. For more information, see Map Workbook.
- Cross Reference Workbook
- This workbook controls which map and configuration data worksheets are used for a specific DSU operation. For more information, see Cross Reference Workbook.
- Properties File
- The properties file specifies the file names of the workbooks to be used for DSU operations. It also contains environment and logging properties. The user specifies the properties file name when the utility is started. This location of the properties file is a required command line parameter. For more information, see Configuring the properties files for the utility.