Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Syed4
Contributor
Contributor

ELT Component

Hello ALL,
MY SCENARIO:
To select data from the one database(source) and insert into another database(target) using ELT components.Help me out.
Thanks in advance.
Thanks&Regards
--------------------
Syed
Labels (2)
2 Replies
Anonymous
Not applicable

ELT is only for "same host" uses. If your source and target are on separate servers, these components will not be very useful to you.
Anonymous
Not applicable

I would like to correct this. ELT use only SQL for its work. Your data must be accessible within the same database connection. For Oracle you can have access to external data with a database link. Other database vendors have probably other similar methods to do this. The same server is not enough because you can run more than one database instance on the same server.