You can translate the question and the replies:

Denodo cross database insert

Hi, Is it possible to insert records in denodo from a base view of database vdb1 into another base view of database vdb2. Insert records into vdb1 from select * from vdb2; if the records exists we need to update those records.
user
17-09-2019 02:41:10 -0400

1 Answer

Hi, At the moment in Denodo Platform, inserting rows from one table to another is supported only for [Materialized tables](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/materialized_tables/inserting_data_into_materialized_tables/inserting_data_into_materialized_tables) and [Temporary tables](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/temporary_tables/creating_temporary_tables/creating_temporary_tables). Other ways to insert data is by creating [Remote table](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/remote_tables/managing_remote_tables/managing_remote_tables#managing-remote-tables) or by using [Scheduler](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/postprocessing_section_exporters). You could refer to the following similar community questions for more information: * [How to insert data into base view](https://community.denodo.com/answers/question/details?questionId=90670000000CcfFAAS&title=How+to+insert+data+into+base+view) * [Plans for "insert into select"?](https://community.denodo.com/answers/question/details?questionId=90670000000Ccn4AAC&title=Plans+for+%22insert+into+select%22%3F) Hope this Helps!
Denodo Team
17-09-2019 08:30:45 -0400
You must sign in to add an answer. If you do not have an account, you can register here