Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Code Block
languageyaml
# A sample S2PX config.yml file for
# Data Migrators' Server-to-Parallel conversion tool
# See http://s2px.mettleci.io/
# --------------------------------------------------
# This file is described here:
# https://datamigrators.atlassian.net/wiki/spaces/S2PX/pages/2074247196
# --------------------------------------------------

transfer:                                  # General S2PX settings
  strategy: RENAME_PARALLEL_JOB            # The job naming strategy: Valid values are RENAME_PARALLEL_JOB or BACKUP_SERVER_JOB 
  suffix: Px                               # The job name suffix to be used when using the
  
decomposition:
  bufferDirectory: /data/project/sv2px/transient      # A directory for the storage of temporary information during conversion 
  mode: OPTIMIZE_RUNTIME                              # (OPTIONAL) Optimise performance or minimize jobs. Valid values are OPTIMIZE_RUNTIME and MINIMIZE_JOBS
  
hashedFiles:                               # Special settings for handling the translation of Server Hashed Files
  type: ORACLE                             # The type settings to be used for the generated DRS Connector stages.  Valied values are DB2,ORACLE or	ODBC
  variant: 11                              # the DRS variant setting
  connection: MCIDEMO                      # the DRS connection name
  username: MCITESTDEV                     # the DRS database username (this can also be a job parameter name if required)
  password: '{iisenc}CeGmkL8fluDU7OVw=='   # the DRS database password (this can also be a job parameter name if required)
  schema: myuser                           # (OPTIONAL) Prefix all hashed File tablename with the schema (e.g. myuser.tablename)

customRoutines:                            # A list of mappings from legacy Server functions to Parallel equivalent expressions
  mapping:                                 #
    AddOneToNum: '{0} + 1'                 # 'AddOneToNumber(myParam)'   --becomes--> 'MyParam + 1'
    GetBalanceInUSD: '{0} * 0.75'          # 'GetBalanceInUSD(MyParam)'' --becomes--> 'MyParam * 0.75'

  libraries:                               # A list of libraries within which custom routines are defined
    - 
      name: mylib                          # The name of a library: 'mylib'
      path: /path/to/lib                   # The location of the mylib library
      type: SHARED_LIBRARY                 # The library type.  VAlid values are SHARED_LIBRARY (for .so files) and OBJECT_FILE (for .o files)
      
      routines:                            # A list of the routines available within the mylib library
        ACustomRoutine:                    # A routines within the mylib library:
          type: STRING                     #
          externalName: a_custom_func      # Name of the C/C++ function in the specified library
          arguments:                       # The arguments (parameters) to the function, descrbied as pairs of...
            - 
              name: arg1                   # parameter names, and
              type: FLOAT                  # parameter datatype.  Valid values are CHAR, STRING, DOUBLE, FLOAT, INT, LONG, SHORT, UCHAR, UINT, ULONG or USHORT.
            - 
              name: arg2                   # etc.
              type: STRING                 # etc.

        AnothCustomRoutineAnotherCustomRoutine:                # Another routines within the mylib library:
          type: STRING                     #
          externalName: aanother_custom_func       # Name of the C/C++ function in the specified library
          arguments:                       # The arguments (parameters) to the function, descrbied as pairs of...
            - 
              name: arg1                   # parameter names, and
              type: FLOATCHAR                   # parameter datatype.  Valid values are CHAR, STRING, DOUBLE, FLOAT, INT, LONG, SHORT, UCHAR, UINT, ULONG or USHORT.
            - 
              name: arg2                   # etc.
              type: INT STRING                   # etc.