idea Re: SSH tunnel connectivity for source Amazon RDS endpoint to replicate from source Amazon RDS to target Oracle - Status changed to: Open - Collecting Feedback in Suggest an Idea

SSH tunnel connectivity for source Amazon RDS endpoint to replicate from source Amazon RDS to target Oracle

adershb — Mon, 07 Jun 2021 15:01:46 GMT

We are trying to replicate data from Amazon RDS for Oracle (source) to Oracle (target). As this Amazon RDS for oracle is on a private network, we tried to establish connection through ssh tunnel.

We tried the below command: ssh -o GatewayPorts=true -N -L 15521:dev-itmp-globi-gdw-db.aztecse-agcs-dev.ec1.aws.aztec.cloud.allianz:1521 ec2-user@dev-itmp-globi-staging.aztecse-agcs-dev.ec1.aws.aztec.cloud.allianz -i .ssh/dev.pem

when this command is active, our test connection (source end-point)using AEM works. But when it is timed out as below, end-point connection fails.

Connection to dev-itmp-globi-staging.aztecse-agcs-dev.ec1.aws.aztec.cloud.allianz closed by remote host.

Also used ssh -o GatewayPorts=true -o ServerAliveInterval=60 -N -L 15521:dev-itmp-globi-gdw-db.aztecse-agcs-dev.ec1.aws.aztec.cloud.allianz:1521 ec2-user@dev-itmp-globi-staging.aztecse-agcs-dev.ec1.aws.aztec.cloud.allianz -i .ssh/dev.pem

How can we we configure a ssh tunnel (a permanent configuration) when we use Amazon RDS for oracle as a source end-point?

Replicate version used: 6.6.0.426

AEM version used: 6.6.0.694

Ref: Qlik support case opened: 02181133 - CONNECTING TO SOURCE END-POINT- AMAZON RDS FOR ORACLE

Thanks, Adersh

Re: SSH tunnel connectivity for source Amazon RDS endpoint to replicate from source Amazon RDS to target Oracle - Status changed to: Open - Collecting Feedback

Shelley_Brennan — Mon, 14 Jun 2021 13:09:37 GMT

Thank you for the suggestion. We will collect feedback from others and consider for a future release.

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 16:31:57 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: SSH tunnel connectivity for source Amazon RDS endpoint to replicate from source Amazon RDS to target Oracle - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 16:31:59 GMT