# 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 generating or usingrenaming thefiles
decomposition:
bufferDirectory: /data/project/sv2px/transient tmp # A directory for the storage ofS2PX conversion temporary information during conversiondirectory
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 # The type settings to be used forType 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 aor 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: # A list ofThe 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.
AnotherCustomRoutine: # Another routines within the mylib library:
type: STRING # The function return #type
externalName: another_func # Name of the C/C++ function in the specified library
arguments: # The arguments (parameters) to the function, descrbieddescribed as name pairs of...& type
-
name: arg1 # Parameter names and datatype. Types #are parameterCHAR, namesSTRING, andDOUBLE,
type: CHAR # parameter datatype. Valid values are CHAR, STRING, DOUBLE, FLOAT, INT, LONG, SHORT, UCHAR, UINT, ULONG or USHORT.
-
name: arg2 # etc.
type: INT # etc. | 
