I have gone through the article 'Talend Integration Cloud - Architecture', I'm new to Talend and right now exploring Talend Open Studio, Cloud and Remote Engines. I have a question here.
Does Talend Remote Engine support ELT ?
What is the difference between Talend Remote Engine and a normal Talend Server?
Does remote engine always associate with a Spark or it could be any other target database, say Redshift for example?
Can we have multiple remote engine architecture?
on-premise 1: Postgres, Teradata
on-premise 2 (different network, placed in a different country): Netezza
I want to know if I could install two different remote engines (one in my source network 1 and another in my source network2) and they should extract the data using ELT and send it to Snowflake and do all the processing in the snowflake database. Is it possible to get this setup? I did search the community and google in general, but I couldn't get much understanding on ELT using Remote Engines.
Attached my intended architecture diagram. I would be extremely happy if you could help us in understanding this better. Or if you could point to some reference docs, that would be a great help too.
One more -
While using ELT, do i need to ingest using specific ELT input components to the database where I want to do the processing?
Watch the recorded webinar!
Learn about modern data engineering in the Cloud
Learn how to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud registries
Pick up some tips and tricks with Context Variables
Learn how to publish your API Services to Talend Cloud