# 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 thegenerating or renaming files
decomposition:
bufferDirectory: /data/project/sv2px/transienttmp # A directory for the storage ofS2PX conversion temporary informationdirectory during
conversion mode: OPTIMIZE_RUNTIME # (OPTIONAL) Optimise performance or minimize jobs. Valid values are OPTIMIZE_RUNTIME andor MINIMIZE_JOBS
hashedFiles: # Special settingsSettings for handlingdatabase theused translationto ofrepalce Server Hashed File Filesstages
type: ORACLE # TheType type settings to be used for of the generated DRS Connector stages. Valied values are : DB2,ORACLE or ODBC
variant: 11 # theThe DRS variant setting
connection: MCIDEMO # theThe DRS connection name
username: MCITESTDEV # theThe DRS database username (this can also be a or job parameter name if required)
password: '{iisenc}CeGmkL8fluDU7OVw=CeGmkDU7Ow=' # theThe DRS database password (this can also be a or job parameter name if required)
schema: myuser # (OPTIONAL) Prefix all hashed File tablenameReference tablenames with the schema (e.g. myuser.tablename)
customRoutines: # A list of mappings from legacy Mapping Server functions to equivalent Parallel equivalent expressions
mapping: #
AddOneToNum: '{0} + 1' # 'AddOneToNumber(myParam)' --becomes--> 'MyParammyParam + 1'
GetBalanceInUSD: '{0} * 0.75' # 'GetBalanceInUSD(MyParammyParam)'' --becomes--> 'MyParammyParam * 0.75'
libraries: # AThe list of libraries within which custom routines are definedimplemented
-
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) andor 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 # The function return type
#
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/type
-
name: arg1 # Parameter names and datatype. Types #are parameterCHAR, namesSTRING, andDOUBLE,
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 # The function return #type
externalName: aanother_custom_func # Name of the C/C++ function in the specified library
arguments: # The arguments (parameters) to the function, descrbieddescribed as pairs of...name & type
-
name: arg1 # Parameter names and datatype. Types #are parameterCHAR, namesSTRING, andDOUBLE,
type: FLOATCHAR # parameter datatype. Valid values are CHAR, STRING, DOUBLE, FLOAT, INT, LONG, SHORT, UCHAR, UINT, ULONG or USHORT.
-
name: arg2 # etc.
type: STRING INT # etc. | 
