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?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
The Talend Cloud Developer Series was created to give you a solid foundational understanding of Talend’s Cloud Integration Platform
An integration platform-as-a-serviceto help enterprises collect, govern, transform, and share data from any data sources
Move from On-Premises to the Cloud by following the advice of experts