Wednesday, June 17, 2020

FiveTran Auth Error in Connecting Oracle RDS Database

Fivetran toolpromises to reduce technical debt with scalable connectors managed from source to destination. Model your business logic in any destination using SQL, the industry standard. Change data capture delivers incremental updates for all your sources. Built with analysts in mind, our connectors allow data teams to concentrate on asking the right questions.

I was trying to connect from fivetran to Oracle database hosted on AWS RDS and was getting Auth error while connecting through ssh tunnel. I was following fivetran instructions to create ssh user, give its rights set up the keys etc but even then Auth error was appearing.

The solution is to allow fivetran user and its group in /etc/ssh/sshd_config file and restart the ssh daemon.

Only then you would be able to connect.

No comments: