Adapter descriptions for Instance Data Replication
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.
| Parameter and value | Source data | Adapter output |
|---|---|---|
| Operation: MultiplyConstant Value: 1.08 | 10 | 10.80 |
| Operation: MaxConstant Value: 1000 | 1020 | 1000 |
| Operation: FloorConstant 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.
| 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.
| 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.
| 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.
| 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.
| 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.
| 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.
| 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.
| Parameter and value | Source data | Adapter output |
|---|---|---|
| Output time zone: PDT | 07:00:00 am GMT | 00:00:00 am PDT |
Parent Topic:Instance Data Replication reference
Related topics
Data privacy in Instance Data Replication
Excluded tables in Instance Data Replication