User Tools

Site Tools


multiple_encryption_modes

Multiple Encryption Modes

v3.2.3

A new property is now available to describe how data is encrypted when being shared our of your ServiceNow instance, as shown in the following screenshot.

The available modes are:

  • unencrypted - data is sent unencrypted and unencoded
  • encrypted - data is encrypted and base64 encoded
  • encrypted_multibyte - base64 encode the data before encrypting for utmost compatibility

Foreign Language Replication between ServiceNow instances

To ensure that foreign language strings are replicated properly between ServiceNow instances require at least version 3.2.3 of the Update Set to be installed and that encrypted_multibyte encryption mode is selected on the source instance.

Foreign Language Replication to SQL Replication Agents

To ensure that foreign language strings are replicated properly to your target database via a SQL Replicator Agent, you must configure your database connection string for UTF-8 character encoding. For example, agent.xml config is modified with <database_parms> for MySQL subscriber to add the parameter characterEncoding=UTF-8.

If you have selected unencrypted or encrypted_multibyte encryption modes on the source ServiceNow instance, you must first install and configure a SQL Replicator Agent version 3.2.3 or later.

        <subscribe>
            <task>
            	<task_name>multibyte_tester</task_name>
            	<handler>com.perspectium.replicator.sql.SQLSubscriber</handler>
             	<amqp_queue>psp.out.replicator.dloo_mac</amqp_queue>             
                <decryption_key>The cow jumped over the moon</decryption_key>
                
                <database_server>127.0.0.1</database_server>
                <database_user>xxx</database_user>
                <database_password>xxx</database_password>
                <database_port>3306</database_port>
                <database_type>mysql</database_type>
                <database_parms>autoReconnect=true&amp;characterEncoding=UTF-8</database_parms>
                <database>psp_repl</database>
            </task>
        </subscribe>

For additional help see the Agent Troubleshooting page for multibyte encrytion/decryption.

multiple_encryption_modes.txt · Last modified: 2016/07/25 14:31 by jackson