Adapter descriptions for Instance Data Replication

  • リリースバージョン: Australia
  • 更新日 2026年03月12日
  • 所要時間：8分

    • Adapters modify the producer data before inserting the data on consumer instances in Instance Data Replication (IDR).

    Adapter fields

    Each adapter has Name and Description fields. The name appears in the Adapter column. Use the Description field to explain the purpose of the data conversion.

    Calculation adapter

    Use the calculation adapter on the producer data to specify the operation and the value that is used in the operation.
    表 : 1. Parameter examples
    Parameter and value Source data Adapter output
    Operation: Multiply

    Constant Value: 1.08

    		 10 10.80
    Operation: Max

    Constant Value: 1000

    		 1020 1000
    Operation: Floor

    Constant Value: 0

    		 5.5 5
    Max specifies the highest and Min specifies the lowest possible values. Values above or below those limits are set to those limits. Value types such as int and long have maximum and minimum values. Values above or below those limits cause precision errors.

    Concatenate String adapter

    Use the concatenate string adapter to append a specified string to the source data.
    表 : 2. Parameter example
    Parameter and value Source data Adapter output
    String: _v2 Patch10236 Patch10236_v2

    Fixed-width format adapter

    Use the fixed-width format adapter to reformat fixed-width input data. Use # to represent any positive integer, @ to represent any character, and \ as the literal escape character.
    表 : 3. Parameter examples
    Parameter and value Source data Adapter output
    Match: ##########

    Output: (###) ###-####

    		 7605551212 (760) 555-1212
    Match: #####

    Output: ###.##

    		 10000 100.00
    Match: ##\,###

    Output: #####

    		 10,000 10000

    Map adapter

    Use the map adapter for comma-separated pairs of literals to map source-to-target conversions. Matches must be exact. For example, PRB=TASK would not convert PRB1000 to TASK1000.
    表 : 4. Parameter examples
    Parameter and value Source data Adapter output
    Map: PRB=TASK, done=complete PRB TASK
    Map: PRB=TASK, done=complete done complete
    Map: PRB=TASK, done=complete PRB1000 (no mapping)

    Pattern adapter

    Use the pattern adapter for regular expressions to identify input patterns. Use parentheses in the Regex to identify groups. In Output Pattern, use $ to specify groups. $0 represents the entire input, $1 represents the first group, $2 represents the second group, and so on. You can also insert, prefix, and append literal characters, including spaces so they appear in the adapter output.
    表 : 5. Parameter examples
    Parameter and value Source data Adapter output

    Regex: (.*),(.*)

    Output pattern: $2 $1

    		 Smith, John John Smith

    Regex: (ABC[a-zA-z][a-zA-z])(ABC[a-zA-z][a-zA-z])

    Output pattern: $1 $0

    		 ABCDEABCFG ABCDE ABCDEABCFG

    Regex: (ABC[a-zA-z][a-zA-z])(ABC[a-zA-z][a-zA-z])

    Output pattern: $1 release $0

    		 ABCDEABCFG ABCDE release ABCDEABCFG
    In the second example, the match is ABC followed by two letters, followed by ABC and two letters. $1 of this input is ABCDE. $2 of this input is ABCFG. $0 is the entire input string. So $1 $0 is ABCDE ABCDEABCFG.

    Replace adapter

    Use the replace adapter to replace a specified input string or substring with a specified string. Use $ to replace only some of the occurrences of the string. $1 replaces only the first occurrence; $2 replaces only the second. Use curly braces to replace the first N occurrences. For example, ${3} replaces the first three occurrences.
    表 : 6. Parameter examples
    Parameter and value Source data Adapter output

    Find: London

    Replace: Madrid

    		 The product is London. The product is London. The product is London. The product is Madrid. The product is Madrid. The product is Madrid.

    Find: $2 London

    Replace: Madrid

    		 The product is London. The product is London. The product is London. The product is London. The product is Madrid. The product is London.

    Find: ${2} London

    Replace: Madrid

    		 The product is London. The product is London. The product is London. The product is Madrid. The product is Madrid. The product is London.

    Split adapter

    Use the split adapter to break a string into two or more strings using a specified delimiter made up of letters, numbers, or special characters (no spaces). In Output Pattern, use $ to specify groups. $0 represents the entire input, $1 represents the first group, $2 represents the second group, and so on. You can repeat a group in an output pattern, for example, $2, $1, $1. Multiple instances of a delimiter in source data create three or more groups.

    表 : 7. Parameter examples
    Parameter and value Source data Adapter output

    Delimiter: -

    Output Pattern: $2, $1

    		 John-Smith Smith, John

    Delimiter: -

    Output Pattern: $2, $1, $1

    		 John-Harry-Smith Harry, John, John

    Delimiter: -

    Output Pattern: $3

    		 John-Harry-Smith Smith

    Task number adapter

    Use the task number adapter to add a prefix or suffix to a task number or replace the task number's prefix.
    表 : 8. Parameter examples
    Parameter and value Source data Adapter output

    Modification: Replace

    Number Prefix: PRB

    New Number Prefix: STRY

    		 PRB80899 STRY80899

    Modification: Add Prefix

    Prefix: STRY

    		 08099 STRY80899

    Time zone conversion adapter

    Use the time zone conversion adapter to convert one time zone to another.

    表 : 9. Parameter example
    Parameter and value Source data Adapter output
    Output time zone: PDT 07:00:00 am GMT 00:00:00 am PDT