You can configure your Perspectium DataSync Agent to share data from ServiceNow or Salesforce to an SAP Hana database by changing some additional configurations in your agent.xml file.
Prerequisites
First, you will need to install a DataSync Agent Agent.
You will also need to create a ServiceNow dynamic share/bulk share or create a Salesforce dynamic share/bulk share.
Make sure to stop running your DataSync Agent before making any Agent configuration changes.
Procedure
To set up your DataSync Agent to share application data to an SAP Hana database, follow these steps:
Add the SAP Hana JDBC driver
Add the ngdbc.jar JDBC driver that was created upon installation of SAP Hana to your DataSync Agent's extlib directory.
Install and configure your DataSync Agent
Follow the steps to install the DataSync Agent for ServiceNow or the DataSync for Salesforce Agent and make sure that your agent.xml file is configured correctly.
Access your agent.xml configuration file
Navigate to the directory where you saved your agent.xml file when installing your DataSync Agent.
Update database directives to point to SAP Hana
Open your agent.xml file in a text editing application. Then, locate the <task> directive(s) within your <subscribe> directive, and update the following database-related directives:
| Directive | Value to enter |
|---|---|
| <database_type> | hana |
| <database_server> | URL/IP address for your SAP Hana database |
| <database_port> | Port number for your SAP Hana database |
| <database_user> | Username used to access your SAP Hana database |
| <database_password> | Password used to access your SAP Hana database |
| <database_parms> | characterencoding=UTF-8 |
| <enable_upsert/> | Enable upserts so the Agent performs an upsert (update or insert) on a record in the database when processing a message. By default, when the Agent receives a .bulk message, it will query for a record to see if it exists and then update it if it does (and insert if it doesn't) but using the upsert action, we let SAP Hana handle it for us. This option can help with better performance on large tables that have hundreds of millions or billions of records. |
Add the <uppercase_columns/> directive
Within 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:
<?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:vlOtU71yu8N/EFIJH85SSBtaIt7qEEfvqiqft9VZyYE=" use_basic_consume="false" user="admin" queue="psp.out.testhana2">https://lab.perspectium.net</message_connection>
<instance_connection password="encrypted:vlOtU71yu8N/EFIJH85SSPN9aF0P5/YViVwPEVFcGW4=" user="admin">https://dev17175.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</database_server>
<database_port>39013</database_port>
<database_user>SYSTEM</database_user>
<database_password>Perspectium123</database_password>
<database_parms>characterEncoding=UTF-8</database_parms>
<database>SystemDB</database>
<uppercase_columns/>
</task>
</subscribe>
<max_reads_per_connect>4000</max_reads_per_connect>
<polling_interval>5</polling_interval>
<skip_message_set_processing/>
</agent>
</config>
Save your agent.xml file
Save the changes you made to your agent.xml file and close the file.
Run your DataSync Agent
After configuring your agent.xml file to support replication to your SAP Hana database, start running your DataSync Agent again.
