We had made a project in Talend Open Studio 6.2 which uses a Amazon RDS MySQL Database as a source. Our local system on which Talend Open Studio was installed was connected with RDS via VPN.
Now we have purchased TCI and have published that job to TCI but the job gives an error as TCI is not connected with VPN, hence SOURCE.
I want to know that is there any way we can connect with our RDS using a VPN as without VPN connection RDS refuses connection.
It is unclear to me how you have achieved it. I am on a similar scenario and would need help.
I have a mysql db over VPN connection. This will serve as a source, how can i achieve to connect to this database from TALEND. For job execution we are using unix servers. I am using the Enterprise edition in talend 5.6.1
Edit 1: Outside Talend and manual connection is explained as below.
We usually connect with "Global Protect" to establish the VPN connection and using sql server we set up the db connection and query the source records.
In Global protect, we use details of the "Portal, Username and Password". A registered mobile number using the duo mobile app that receives a notification to authenticate the login (This requires to open the app and press allow). I guess this is a 2 FA (Two Factor Authentication).
I guess we should try and create a tunnel connection to reach the source in Talend's unix box (job/execution server) but unclear of the exact steps. Would appreciate inputs from anyone who had any similar efforts put in earlier.
I have the same issue, did you find a way to connect Talend to a database via VPN ?
Yes, the internal firewall team had to enable the port to access the source DB over the VPN for our talend job server. I dont find any specific talend components for this though.
Watch the recorded webinar!
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.
Practical steps to developing your data integration strategy.