Update the Data Provisioning Agent - Administration Guide for SAP HANA Smart Data Integration a

You can update the Data Provisioning Agent by running the installation program in update mode.

Prerequisites

Before you update the Data Provisioning Agent, ensure that your SAP HANA server has already been updated to the same revision.

If your agent has remote subscriptions for real-time data capture, you must also suspend capture before upgrading the agent. To suspend active remote source subscriptions, use the SQL console in the SAP HANA Studio or Web-based Development Workbench:

ALTER REMOTE SOURCE <remote_source_name> SUSPEND CAPTURE

Note

To verify the success of the upgrade for log reader adapters, you should also set the adapter framework logging level to INFO. To change the adapter framework logging level, choose Preferences Adapter Framework Logging Level in the SAP HANA Data Provisioning Agent Configuration tool.

Procedure

1. Download and extract the software to an empty directory. 2. Stop the existing SAP HANA Data Provisioning Agent service.

○ On Windows, use the Services manager in Control Panel. ○ On Linux, run ./dpagent_service.sh stop.

3. Navigate to the directory where you unpacked the software. 4. Call the installation manager.

○ On Windows, run hdbsetup.exe.

○ On Linux, run ./hdbsetup with root privileges. For example, sudo ./hdbsetup.

Tip

To upgrade the agent in command-line mode, use hdbinst.exe on Windows or ./hdbinst on Linux. 5. Choose Update SAP HANA Data Provisioning Agent and select the path of the existing agent that you want to

update.

In command-line mode, enter the number of the existing agent as listed by the installation program.

P U B L I C

Administration Guide for SAP HANA Smart Data Integration and SAP HANA Smart Data Quality

6. On Linux, update the adapter configurations to the latest version and restart the Agent service. a. Stop any running dpagent processes.

b. Navigate to the <DPAgent_root>/bin directory. c. Run ./dpagent_upgrade.sh.

7. On Linux, restart the Agent service.

a. Navigate to the <DPAgent_root>/bin directory. b. Run ./dpagent_service.sh start.

8. Apply new adapter capabilities.

To allow SAP HANA to detect any new adapter capabilities, use the SQL console in the SAP HANA Studio or Web-based Development Workbench.

a. Retrieve a list of the adapters configured in your environment.

select * from "SYS"."ADAPTERS" where "IS_SYSTEM_ADAPTER" like 'FALSE'

b. Refresh each adapter listed by the previous command.

ALTER ADAPTER "<adapter_name>" REFRESH AT LOCATION "<agent_name>"

Note

If you have multiple agents in your SAP HANA environment, you only need to refresh each adapter a single time with an upgraded agent. Refreshing the adapters with each agent is not necessary.

Results

The Data Provisioning Agent is updated to the new version.

Next Steps

If you suspended capture for remote source subscriptions on the agent, you can now resume capture.

Caution

Before resuming capture, you must first upgrade all agents in your SAP HANA environment. If you have not upgraded all agents, do that first and then return to this section.

After all agents have been upgraded, use the SQL console in the SAP HANA Studio or Web-based Development Workbench to resume capture:

ALTER REMOTE SOURCE <remote_source_name> RESUME CAPTURE

Repeat the command for each remote source subscription in your environment.

Administration Guide for SAP HANA Smart Data Integration and SAP HANA Smart Data Quality

Update the Data Provisioning Agent

Tip

After you resume a remote source subscription, additional automatic upgrade steps take approximately 10 minutes to complete. To verify that the process has completed successfully, view the Data Provisioning Agent framework log:

● When the adapter upgrade has been completed, you should see the message <instance_name> has been upgraded successfully.

● When the real-time replication has been resumed, you should see the message <instance_name> is resumed successfully.

5.1 Update the SAP ASE Adapter Preferences

After updating the Data Provisioning Agent, you must update the SAP ASE Adapter Preferences before you can use it in SAP HANA smart data integration processes.

Procedure

1. Add the following line to <DPAgent_root>/adapters/cppframework.props:

ASEAdapter.ld_library_path=<installpath>/Sybase/ci/64bit,<installpath>/Sybase/ OCS-16_0/lib,<installpath>/Sybase/OCS-16_0/lib3p64

Replace <installpath> with the actual path to the Data Provisioning Agent installation. 2. Add the following lines to <DPAgent_root>/bin/dpagent_env.sh:

SYBASE=<installpath>/Sybase export SYBASE

SYBASE_OCS=OCS-16_0 export SYBASE_OCS

Replace <installpath> with the actual path to the Data Provisioning Agent installation. 3. Add the following lines to <DPAgent_root>/Sybase/interfaces:

ASEAdapterOCSServer

master tcp ether <hostname> <adapterAgentPort >

query tcp ether <hostname> <adapterAgentPort>

Replace <hostname> with the host name or IP address of the Data Provisioning Agent host machine, and <adapterAgentPort> with the port number configured for the Data Provisioning Agent.

P U B L I C

Administration Guide for SAP HANA Smart Data Integration and SAP HANA Smart Data Quality

In document Administration Guide for SAP HANA Smart Data Integration and SAP HANA Smart Data Quality (Page 54-57)