Suggest an Idea

[adershb]

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

[Shelley_Brennan]

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

[Meghann_MacDonald]

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.