Add the <uppercase_columns/> directiveWithin the <subscribe> → <task> directive(s), nest the <uppercase_columns/> directive to enforce proper column formatting in SAP Hana. Your agent.xml file should look similar to the example shown below: Code Block |
---|
| <?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<config>
<agent>
<share>
</share>
<subscribe>
<task instances="4">
<task_name>test_hana2_subscribe</task_name>
<message_connection password="encrypted:vlOtU71yu8NvlOtU71sdfs/EFIJH85SSBtaIt7qEEfvqiqft9VZyYEdfdafBtaIt7qEEfvqiqft9VZyYE=" use_basic_consume="false" user="adminuser" queue="psp.out.testhana2replicator.testhana">https://labtesting.perspectium.net</message_connection>
<instance_connection password="encrypted:vlOtU71yu8N/EFIJH85SSPN9aF0P5/YViVwPEVFcGW4YVFEID87FcGW4=" user="admin">https://dev17175yourinstance.service-now.com</instance_connection>
<handler>com.perspectium.replicator.sql.SQLSubscriber</handler>
<decryption_key>The cow jumped over the moon</decryption_key>
<database_type>hana</database_type>
<database_server>192.168.0.61<00</database_server>
<database_port>39013</database_port>
<database_user>SYSTEM<user>user</database_user>
<database_password>Perspectium123<password>dbpassword</database_password>
<database_params>characterEncoding=UTF-8</database_params>
<database>SystemDB</database>
<uppercase<enable_columnsupsert/>
</task>
</subscribe>
<max_reads_per_connect>4000</max_reads_per_connect>
<polling_interval>5</polling_interval>
<skip_message_set_processing/>
</agent>
</config> |
|