Product documentation Docs
    • English
    • Deutsch
    • 日本語
    • 한국어
    • Français
  • More Sites
    • Now Community
    • Developer Site
    • Knowledge Base
    • Product Information
    • ServiceNow.com
    • Training
    • Customer Success Center
    • ServiceNow Support Videos
  • Log in

Product documentation

  • Home
How search works:
  • Punctuation and capital letters are ignored
  • Special characters like underscores (_) are removed
  • Known synonyms are applied
  • The most relevant topics (based on weighting and matching to search terms) are listed first in search results
Topics are ranked in search results by how closely they match your search terms
  • A match on the entire phrase you typed
  • A match on part of the phrase you typed
  • A match on ALL of the terms in the phrase you typed
  • A match on ANY of the terms in the phrase you typed

Note: Matches in titles are always highly ranked.

  • Release version
    Table of Contents
    • Now Platform capabilities
Table of Contents
Choose your release version
    Home New York Now Platform Capabilities Now Platform capabilities Instance Data Replication (IDR) Transform replication data for Instance Data Replication (IDR)

    Transform replication data for Instance Data Replication (IDR)

    • Save as PDF Selected topic Topic & subtopics All topics in contents
    • Unsubscribe Log in to subscribe to topics and get notified when content changes.
    • Share this page

    Transform replication data for Instance Data Replication (IDR)

    Transform the producer instance data to tables or table columns that are named differently on consumer instances.

    Before you begin

    • Create and activate a producer replication set.
    • Create, activate, and seed one or more consumer replication sets.
    • Role required: admin or idr_admin

    About this task

    By default, replicated data from producer tables and table columns goes into tables and table columns of the same name on consumer instances. You can, however, map producer data into any table or table column on consumer instances. You might replicate the data to a different table or table column because existing tables or table columns you replicate to have different names.

    You can also use adapters to modify producer data during replication, for example, to localize the data, or to populate data that has been labeled differently in consumer tables.

    Transformations have the following limitations:
    • sys_created, sys_created_by, sys_domain, sys_updated_by, sys_id, and sys_mod_count are automatically mapped to the consumer and cannot be remapped.

      No other sys_ fields can be replicated.

    • Adapters cannot operate on the sys_journal field type, for example, on Comments or Worknotes columns in a Task table.
    • Calculated fields cannot be transformed.

      For example, sys_user is a combination of first and last name fields. If the source and target fields have the same names, the calculated fields are replicated. Attempting to remap calculated fields breaks the calculation.

    Procedure

    1. On the consumer instance, click Instance Data Replication > Consumer Replication Sets and click a consumer replication set.
    2. On the Consumer Replication Entries tab, click a consumer replication entry.
      The Consumer Replication Entry form appears.
      Enable transforms
    3. Select the Enable Transform check box.
    4. In Target Table Name, select the table into which to replicate the source table data and click Update.
    5. On the Consumer Replication Entries tab, click the same consumer replication entry.
    6. Click the lock icon next to Transform Map to unlock it.
      The Transform Map appears. Field names from the source table appear in the left column. The middle column shows matching field names in the target table. All fields that do not have the same names in both tables appear in the – choose source field – or – choose target field – drop-downs.
      Transform different fields
      Note: If a table in a producer replication set is not on a consumer instance, the table is created on the consumer instance. If there are no entries in the – choose source field – and – choose target field – columns, the producer and consumer tables do not have identically named columns. Grayed out values are not configurable.
    7. To map a producer column to a consumer column that has a different name:
      1. Click – choose source field – and select the source field you want to map.
      2. Click – choose target field –, select the target field into which you want to map the data, and then click Add.
      3. If you want to remove a field from replicating from the producer to the consumer, click the X at the end of the row to delete the field.
    8. To modify the producer data before replicating it in the consumer instance, click Add Adapter.
      The What kind of Adapter Rule do you want to create? page appears.
      Adapters
    9. Click the adapter you want to use and configure it.
      For more information about configuring adapters, see Adapter descriptions.

    Result

    Producer data replicates into different tables or table columns on the consumer instance, or the data is modified, or both.
    Note: Adapters do not modify data on the producer instance.

    Tags:

    Feedback
    On this page

    Previous topic

    Next topic

    • Contact Us
    • Careers
    • Terms of Use
    • Privacy Statement
    • Sitemap
    • © ServiceNow. All rights reserved.

    Release version
    Choose your release version

      Transform replication data for Instance Data Replication (IDR)

      • Save as PDF Selected topic Topic & subtopics All topics in contents
      • Unsubscribe Log in to subscribe to topics and get notified when content changes.
      • Share this page

      Transform replication data for Instance Data Replication (IDR)

      Transform the producer instance data to tables or table columns that are named differently on consumer instances.

      Before you begin

      • Create and activate a producer replication set.
      • Create, activate, and seed one or more consumer replication sets.
      • Role required: admin or idr_admin

      About this task

      By default, replicated data from producer tables and table columns goes into tables and table columns of the same name on consumer instances. You can, however, map producer data into any table or table column on consumer instances. You might replicate the data to a different table or table column because existing tables or table columns you replicate to have different names.

      You can also use adapters to modify producer data during replication, for example, to localize the data, or to populate data that has been labeled differently in consumer tables.

      Transformations have the following limitations:
      • sys_created, sys_created_by, sys_domain, sys_updated_by, sys_id, and sys_mod_count are automatically mapped to the consumer and cannot be remapped.

        No other sys_ fields can be replicated.

      • Adapters cannot operate on the sys_journal field type, for example, on Comments or Worknotes columns in a Task table.
      • Calculated fields cannot be transformed.

        For example, sys_user is a combination of first and last name fields. If the source and target fields have the same names, the calculated fields are replicated. Attempting to remap calculated fields breaks the calculation.

      Procedure

      1. On the consumer instance, click Instance Data Replication > Consumer Replication Sets and click a consumer replication set.
      2. On the Consumer Replication Entries tab, click a consumer replication entry.
        The Consumer Replication Entry form appears.
        Enable transforms
      3. Select the Enable Transform check box.
      4. In Target Table Name, select the table into which to replicate the source table data and click Update.
      5. On the Consumer Replication Entries tab, click the same consumer replication entry.
      6. Click the lock icon next to Transform Map to unlock it.
        The Transform Map appears. Field names from the source table appear in the left column. The middle column shows matching field names in the target table. All fields that do not have the same names in both tables appear in the – choose source field – or – choose target field – drop-downs.
        Transform different fields
        Note: If a table in a producer replication set is not on a consumer instance, the table is created on the consumer instance. If there are no entries in the – choose source field – and – choose target field – columns, the producer and consumer tables do not have identically named columns. Grayed out values are not configurable.
      7. To map a producer column to a consumer column that has a different name:
        1. Click – choose source field – and select the source field you want to map.
        2. Click – choose target field –, select the target field into which you want to map the data, and then click Add.
        3. If you want to remove a field from replicating from the producer to the consumer, click the X at the end of the row to delete the field.
      8. To modify the producer data before replicating it in the consumer instance, click Add Adapter.
        The What kind of Adapter Rule do you want to create? page appears.
        Adapters
      9. Click the adapter you want to use and configure it.
        For more information about configuring adapters, see Adapter descriptions.

      Result

      Producer data replicates into different tables or table columns on the consumer instance, or the data is modified, or both.
      Note: Adapters do not modify data on the producer instance.

      Tags:

      Feedback

          Share this page

          Got it! Feel free to add a comment
          To share your product suggestions, visit the Idea Portal.
          Please let us know how to improve this content

          Check any that apply

          To share your product suggestions, visit the Idea Portal.
          Confirm

          We were unable to find "Coaching" in Jakarta. Would you like to search instead?

          No Yes
          • Contact Us
          • Careers
          • Terms of Use
          • Privacy Statement
          • Sitemap
          • © ServiceNow. All rights reserved.

          Subscribe Subscribed Unsubscribe Last updated: Tags: January February March April May June July August September October November December No Results Found Versions Search preferences successfully updated My release version successfully updated My release version successfully deleted An error has occurred. Please try again later. You have been unsubscribed from all topics. You are now subscribed to and will receive notifications if any changes are made to this page. You have been unsubscribed from this content Thank you for your feedback. Form temporarily unavailable. Please try again or contact  docfeedback@servicenow.com  to submit your comments. The topic you requested does not exist in the release. You were redirected to a related topic instead. The available release versions for this topic are listed There is no specific version for this documentation. Explore products Click to go to the page. Release notes and upgrades Click to open the dropdown menu. Delete Remove No selected version Reset This field is required You are already subscribed to this topic Attach screenshot The file you uploaded exceeds the allowed file size of 20MB. Please try again with a smaller file. Please complete the reCAPTCHA step to attach a screenshot
          Log in to personalize your search results and subscribe to topics
          No, thanks Login