Skip to Content
0
Aug 30, 2023 at 11:28 AM

Remote Table Replication Error(SAP tutorial)

161 Views Last edit Aug 30, 2023 at 07:05 PM 2 rev

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".

Use the Cloud Connector to Connect SAP HANA On-Premise to SAP HANA Cloud, SAP HANA Database | Tutorials for SAP Developers

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

"Remote Table Replication".

Remote Table Replication | Tutorials for SAP Developers

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

image.png

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

・HANA Cloud

image.png

・Cloud Connector

image.png

image.png

・remote source

image.png

・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

Attachments

image.png (294.6 kB)
image.png (109.6 kB)
image.png (71.1 kB)
image.png (142.9 kB)
image.png (159.7 kB)