This article provides information on new functionality provided in the 7.1 release
List of Changes
1. Support for Snowflake as an Archiving Target
The ability to connect to, and migrate data into a Snowflake database for archiving purposes is supported. As for other database targets, it is also possible to generate the archiving tables and to delete the records from the source server following migration. Attachment migration is also supported.
See Configuring Access to a Snowflake database and Configuring a Snowflake Database Server Connection for more information on how to connect to Snowflake.
2. Enhancements to Utilities to extract from Zendesk and ManageEngine
Supports setting a chunk size to limit the size of each individual csv file generated and improve performance. The Zendesk and Manage Engine Export Utilities are now seperately licenced.
See Zendesk to CSV Utility and ManageEngine to CSV Utility for more information.
3. Ability to Save and Load Server Connection Details
It is now possible to save the source and target connection details in a project for re-use in a later project. This makes the task of building and repointing multiple projects easier.
See Managing Server Connections fro more information.
4. Support for Attachment Retrieval from a URL where the Source is CSV
A CSV file can now be used to provide the URL and other attachment details to upload the attachment files from. This is primarily to support uploading CSV files extracted from Zendesk and Manage Engine, but can be extended to other CSV Migrations.
SeeCSV to Service Now - Configuring The Attachment CSV Files and CSV to Service Now - Configuring Attachment Migration on the Form Mapping for more information.
5. Ability to Run Stored Procedure During Oracle Connection
An option has been added to the Oracle Connection to allow the user to specify a stored procedure that should be run when the connection is first made. This allows session parameters to be set, including values that assist with row level security.
See Configuring an Oracle Database Server Connection fro more information.
6. Multi Threading of Insert/Update into Service Now Instances
An option is available to set the number of threads used to insert or update records in Service Now during migration. Migration of attachments (using the Server->Server method) also takes advantage of this. This can significantly improve performance.
See Multi-threading for ServiceNow data creation and updates for more information.
7. Ability to Generate 'Mirror' Tables in Service Now for Source Servers
The Archiving Wizard has been extended to allow Generation of tables on a Service Now target Server. This extension applies to all Source Servers that support Archive Table Generation.
See The Precision Bridge Archiving Wizard for more information.
8. Improved Reporting for Migrated Attachments
When attachments are migrated, the number of attachments or the file names of the attachments will be reported for each migrated record if the 'All Entries' reporting level has been selected in the Execution Options.
9. Additional Log Warning action for No Match and Multiple Match Options
This applies to Lookup Mappings and Reference Mappings. There is now an option to record a warning in the migration report if the mapping produces no match or more than one match for a given record.
See Creating a Lookup Field Mapping and Creating a Reference Field Mapping for Legacy-ServiceNow migrations for further information.
10. Improved Functionality for Ordering Form Mappings
It is now possible to move multiple mappings up or down a single position or multiple positions in the list of form mappings, making re-ordering of mappings in a long list much easier. The functionality also checks first for dependencies, preventing the move if any would be broken.
See Changing the Order of the Mappings List for more information.
11. Additional Key Mapping Validation
Validation during project editing now prevents key mapping being removed if any reference mappings later on depend upon it.
12.Optional Validation at Execution time to check for Unqualified Source Filters
A warning can be configured at execution time to give a warning if a form mapping has no source filtering (including inclusion filtering) and the number of records in the source table is greater than 100,000.
See Defining Validation Options for more information.
13. Prevent Errors when Disabling Mappings Referenced in Inclusion Filters
If a form mapping is disabled and later enabled mappings have an inclusion filter defined that referenced it, the later mapping will not generate an error. Instead, no records will be migrated for the mapping with the inclusion filter.
14. Option to Prevent Existing Values on a Target Record being Overwritten with a NULL Value
When an existing target record is being updated, it is possible to ignore the update of a given field if the mapped value is NULL. This can be used to prevent unexpected removal of existing values. This can be configured at Form Mapping level (via Form Mapping Options) or a default set at Project level (via Execution Options).
See Form Mapping Options and Defining Project Migration Options for more information.
15. Warning when Deletion Options are Applied
Whenever either source deletion or target deletion options are enabled in a project, a warning dialog is presented to the user urging caution since deleted records may not be recoverable.
16. Removal of 'Use Server ID's' Key Mapping Option
This Key Mapping option was deprecated in version 7.0 due to the functionality having been overtaken by improvements in other key mapping methods and its causing confusion to users. The option has now been removed, and any projects using it should be updated to use an alternative key mapping method.
17. Additional Assignment Functions
GENERATE_SNOW_FIELD_NAME
This new assignment function takes a string and transforms it into a string suitable to be used as a Service Now table or field name. Unsupported characters are replaced with underscores. This function is used in the Service Now instance migration Table and Field Migration Projects.
See GENERATE_SNOW_FIELD_NAME Function for more information.
SNOW_REPLACE_ZENDESK_IMG_TAG
This new assignment function takes the HTML string for a Zendesk Article and replaces the embedded image tags that refer to the source Zendesk attachments with image tags that refer to the target Service Now attachments.
See Function SNOW_REPLACE_ZENDESK_IMG_TAG for more information.
18. Improvements to Service Now Table and Field Migration Templates
The two use cases of migrating custom (u_ prefixed) tables and fields only or migrating entire Service Now tables now have two separate supporting templates. The customisations only approach is generally recommended, however for very old source servers, where the u_ prefix may not have been used to identify customisations, the 'Full Table' template may be used.
19. New Table Migration Template to support migration of data for ServiceNow tables where table rotation/extension is used
New template has been added to support creation of rotated/extended tables and to migrate the table rotation configuration before the data for the tables is migrated.
20 Improvements to ServiceNow Service Request Management Instance Migration Templates
Templates that migrate Service Management Configuration and Data between ServiceNow instances have been improved to be consistent with functionality on the Utah Release of ServiceNow.
New and Updated Templates
The following templates are new or updated in Precision Bridge 7.1:
| Template | Description |
|
NEW: CSV to Service Now -> Zendesk -> Foundation |
Migrates Zendesk Foundation Data (Organisational data) from a CSV file (extracted using the Zendesk Export Utility) into Service now |
|
NEW: CSV to Service Now -> Zendesk -> Foundation |
Migrates Zendesk Ticket Data (including notes and attachments) from a CSV file (extracted using the Zendesk Export Utility) into Service now |
|
NEW: Service Now to Service Now -> Table Migration -> Tables and Fields - Full |
Migrates table and field definitions for a given set of tables (including custom and system fields) from one instance to another |
|
NEW: Service Now to Service Now -> Table Migration -> Rotated & Extension Tables |
Migrates Table Rotation and Extension configuration for a given table and creates the additional extension tables on the target. |
|
UPDATED: Service Now to Service Now -> Service and Product Catalog |
Updated to support Multi Row Variables |
|
UPDATED: Service Now to Service Now -> Service Requests |
Updated to support Multi Row Variables |
Advice To Users Upgrading from Precision Bridge 7.0
The Use Server ID's Key Mapping option has been removed from Precision Bridge 7.1. If this Key mapping option has been used in a project built with Precision Bridge 7.0 (or earlier), the Key Mapping option will default to 'No Key Mappings' when opened in Precision Bridge 7.1.
Note that none of the Precision Bridge Templates used this option in earlier or current versions of Precision Bridge. If you have projects that use this option, be sure to select an alternative key mapping option to use (such as by selecting Key Field Mappings) before executing the project with Precision Bridge 7.1. Failure to do this may result in duplicate records being created if the project is run a second time to update existing records.
Other than the above, projects buit using Precision Bridge 7.0 will still work Precision Bridge 7.1 with no changes required.
Licences for 7.0 will still work for 7.1.
Comments
0 comments
Please sign in to leave a comment.