I want to execute a simple job that gets all the data from the salesforce account object, and inserts it into an Azure SQL server database. Now the problem is that the job keeps failing because the Ip that is used by Talend to connect to Azure, keeps changing. We whitelist an ip and, then the job runs succesful, then i try it with an other job and the Ip is changed.
Any idea how to managed the static ip's that are used by theTalend integration cloud engine?
I am using the Talend Integarion cloud 30 day Trial.
Thank you in advance.
I did some research on my own and concluded that it is not possible to set a static ip adress for a cloud engine when you use the trial version of Talend Integration cloud.
I know this is a pain, but you could potentially use an intermediary machine as a proxy and route all of your cloud calls through that. You would then be able to control the IP address of the proxy and all calls to Azure would appear to be through that.
This would slow things down a little, but it would prevent you having the issues you have now.
It is not really an option in my situation.
But it could definantly work. Thank you for sharing this. I will keep this in mind if I ever have this issue again.
Now my organisation will soon get there licence and then this issue will be resolved.
@jurgenandries it is generally a good idea to read the whole thread before wasting your time posting something that is totally irrelevant. The question was regarding accessing an Azure SQL server database with the Cloud Trial. See @Jvid's second post. Jvid stated that they understand it is only a problem with the Cloud Trial. This link may be useful (https://help.talend.com/reader/4ghjK9KsJCzsAAqMsfGL3g/opOxBU4_TLQ8SJp4l97Igg).
My workaround was to mitigate for the issue of not being able to have a static IP during the trial. I was in no way suggesting it as a permanent fix. Talend provides this functionality (as seen in the link above) so this would never be needed as a permanent fix. It was patently clear that it was a workaround for the trial.
I suggest that you read the thread and comprehend the context before posting something that looks like you are simply trying to find fault :-)
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Move from On-Premises to the Cloud by following the advice of experts
Learn about modern data engineering in the Cloud
Learn how to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud registries