Remote Table Replication Error(SAP tutorial)

nao_ito · ‎2023 Aug 30

Hello community,

I was trying HANA Cloud Replicate with SAP tutorial and I get an error and can't resolve it.

Can someone please give me a hint?

■What I want to do

I want to replicate S/4HANA tables to SAP HANA Cloud.

■SAP tutorial I referred to

The following is a reference for setting up the Cloud Connector.

"Use the Cloud Connector to Connect SAP HANA On-Premise to SAP HANA Cloud, SAP HANA Database".

After setting up the Cloud Connector, I configured the settings in SAP HANA Database Explorer, referring to the following.

"Remote Table Replication".

When I tried to create a remote source in this STEP1 "Establish a remote source to replicate data", I got this error message.

The various parameters set until this error occurs are as follows.

・HANA Cloud

・Cloud Connector

・remote source

・SQL statement

CREATE REMOTE SOURCE LOCAL_RS ADAPTER "hanaodbc"

CONFIGURATION 'ServerNode=replicationtest:8000;use_haas_socks_proxy=true;scc_location_id=HANA001'

WITH CREDENTIAL TYPE 'PASSWORD' USING 'user=~;password=~';

(User and Password use DBADMIN of the HANA Cloud instance)

Looking forward for your help.

Best regards

Ito