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.
Table 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.
Table 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.
Table 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.
Table 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.
Table 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.
Table 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 for a specified delimiter, such as a space, to break a string into two or more strings. 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.

Table 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.
Table 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.

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