--- sourceDocument: Zurich ServiceNow AI Platform Capabilities sourceDocumentLink: https://www.servicenow.com/docs/r/zurich/servicenow-platform Release : - zurich ft:locale : - en-US ft:publication_title : - Zurich ServiceNow AI Platform Capabilities ft:clusterId : - platcap bundleId : - platcap workflow : - Platform --- # Adapter descriptions # Adapter descriptions for Instance Data Replication {#ariaid-title1} * Release version: Zurich * * Updated July 31, 2025 * * ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read Summarize ![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) Summarized using AI This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete. ## Summary of Adapter Descriptions for Instance Data Replication The Instance Data Replication (IDR) feature in ServiceNow utilizes various adapters to modify producer data before it is inserted into consumer instances. Each adapter is characterized by a name and a description that conveys its function in data conversion. Show full answer Show less ## Key Features * **Calculation Adapter:** Performs operations like multiplication or applying maximum/minimum limits on numerical data. * **Concatenate String Adapter:** Appends specified strings to source data. * **Fixed-width Format Adapter:** Reformats fixed-width input data using placeholders for integers and characters. * **Map Adapter:** Maps source data to target data using exact matches for comma-separated pairs. * **Pattern Adapter:** Utilizes regular expressions to identify and manipulate input patterns, allowing for complex transformations. * **Replace Adapter:** Replaces specified substrings within the input string, with options for controlling the number of replacements. * **Split Adapter:** Breaks strings into multiple parts based on specified delimiters. * **Task Number Adapter:** Modifies task numbers by adding or replacing prefixes or suffixes. * **Time Zone Conversion Adapter:** Converts time between different time zones. ## Key Outcomes By utilizing these adapters, ServiceNow customers can efficiently manipulate and format data during the replication process, ensuring accuracy and consistency across instances. This capability is critical for maintaining data integrity in enterprise environments. Adapters modify the producer data before inserting the data on consumer instances in Instance Data Replication (IDR). ## Adapter fields {#adapter-descriptions__section_gn4_xpw_qfb} 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 {#adapter-descriptions__section_tlg_mtp_qfb} Use the calculation adapter on the producer data to specify the operation and the value that is used in the operation. {#adapter-descriptions__table_hcx_ytp_qfb__entry__3} | 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 | [Table 1. Parameter examples] {#adapter-descriptions__table_hcx_ytp_qfb} 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 {#adapter-descriptions__section_jvr_x5p_qfb} Use the concatenate string adapter to append a specified string to the source data. {#adapter-descriptions__table_cyf_bvp_qfb__entry__3} | Parameter and value | Source data | Adapter output | |-|-|-| | String: _v2 | Patch10236 | Patch10236_v2 | [Table 2. Parameter example] {#adapter-descriptions__table_cyf_bvp_qfb} ## Fixed-width format adapter {#adapter-descriptions__section_mc3_3vp_qfb} 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.{#adapter-descriptions__table_vhj_yvp_qfb__entry__3} | Parameter and value | Source data | Adapter output | |-|-|-| | Match: ########## Output: (###) ###-#### | 7605551212 | (760) 555-1212 | | Match: ##### Output: ###.## | 10000 | 100.00 | | Match: ##\\,### Output: ##### | 10,000 | 10000 | [Table 3. Parameter examples] {#adapter-descriptions__table_vhj_yvp_qfb} ## Map adapter {#adapter-descriptions__section_q1b_qwp_qfb} 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.{#adapter-descriptions__table_hcd_twp_qfb__entry__3} | 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) | [Table 4. Parameter examples] {#adapter-descriptions__table_hcd_twp_qfb} ## Pattern adapter {#adapter-descriptions__section_dr3_bxp_qfb} 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.{#adapter-descriptions__table_h5n_dxp_qfb__entry__3} | 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 | [Table 5. Parameter examples] {#adapter-descriptions__table_h5n_dxp_qfb}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 {#adapter-descriptions__section_vr3_lyp_qfb} 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.{#adapter-descriptions__table_ghm_nyp_qfb__entry__3} | 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. | [Table 6. Parameter examples] {#adapter-descriptions__table_ghm_nyp_qfb} ## Split adapter {#adapter-descriptions__section_mjg_zyp_qfb} 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. {#adapter-descriptions__table_hxv_jkq_qfb__entry__3} | 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 | [Table 7. Parameter examples] {#adapter-descriptions__table_hxv_jkq_qfb} ## Task number adapter {#adapter-descriptions__section_lzc_4s1_sfb} Use the task number adapter to add a prefix or suffix to a task number or replace the task number's prefix.{#adapter-descriptions__table_mx4_xs1_sfb__entry__3} | 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 | [Table 8. Parameter examples] {#adapter-descriptions__table_mx4_xs1_sfb} ## Time zone conversion adapter {#adapter-descriptions__section_ing_tkq_qfb} Use the time zone conversion adapter to convert one time zone to another. {#adapter-descriptions__table_hsb_blq_qfb__entry__3} | Parameter and value | Source data | Adapter output | |-|-|-| | Output time zone: PDT | 07:00:00 am GMT | 00:00:00 am PDT | [Table 9. Parameter example] {#adapter-descriptions__table_hsb_blq_qfb} **Related concepts** * [Data privacy in Instance Data Replication](https://www.servicenow.com/docs/vxFJ9IH0Ib499jhXYyCwMQ "The ability of replication sets to host multiple remote consumers in Instance Data Replication (IDR) means that there are potential data privacy issues to consider.") * [Domain separation and IDR](https://www.servicenow.com/docs/eoVqarWYRGe6TTxPrOCffQ "Instance Data Replication (IDR) functions at the data level, which means it does not explicitly support domain separation.") **Related reference** * [Excluded tables in Instance Data Replication](https://www.servicenow.com/docs/Me1gOzwgDeWwuV1v7SU~_w "You can't replicate certain tables in Instance Data Replication (IDR). Child tables of tables in the exclusion list are also excluded.") * [Instance Data Replication system properties](https://www.servicenow.com/docs/VeaFS~NOA1NdpIsfgu6ldg "These system properties control the behavior of the Instance Data Replication (IDR) application.") * [Instance Data Replication roles](https://www.servicenow.com/docs/z66_3tRVS9Kpu4Rs9EMUpw#instance-data-replication-roles "Instance Data Replication (IDR) is installed with these roles.")