I have two PostgreSQL databases, I want to transfer a table from the source database to the target database, but I don’t know what to do for this. I’m very new to Knime. [image]

@yusufINC if you do not want to use streaming you can download the data from one database to knime and then load it into the second DB with one of these nodes like in your screenshot. You might have to configure them. [image] DB Insert Inserts data rows into the selected database table based on the values from the selected KNIME input table columns. All selected column names need to exactly m… [image] DB Insert Inserts data rows into the selected database table based on the values from the selected KNIME input table columns. All selected column names need to exactly m… [image] DB Loader This node uses database specific bulk loading functionality that only some databases (e.g. Hive, MySQL, PostgreSQL and H2) support to load large amounts of dat… If you are looking for more examples about SQL databases and knime I can offer this article .

@yusufINC welcome to the KNIME forum. You could check these examples with streaming: [image] Copy data from mysql to postgresql KNIME Analytics Platform @mgiammarco concerning the transfer you might want to think about streaming like in this example. Then depending on the database it might support UUIDs so you could create them in the DB, maybe after storing the table after transfer in a temporary table. Postgres seems to support uuids: The Basics Of PostgreSQL UUID Data Type Another option would be to create uuid in KNIME. You would have to see how to then insert them into the target DB

Hey Hi, my goal is to have 2 different PostgreSQL databases, one is the source db and the other is the target db, now here I want to get the data from the source db using Knime and send it to the target db. I didn’t understand how to do this with the resources you gave and it didn’t meet my needs.

@yusufINC I would suggest that you take a look at this sample workflow. [image] Transferring data between databases – tobias.koetter This workflow demonstrates how data can be transferred between two different databases using the KNIME Streaming Execution. When using the KNIME Streaming Exec… Otherwise you might describe in more details what you want to do.

Sir, first of all, I appreciate your help. I should not use the Streaming data node we gave above because if you explain my process . I have two databases, one is Source and the other is Target. My only purpose is to make an insert here, that’s it in short.

So, actually, I will create the target db in PostgreSql and insert the data from the Source Db into it.

greetings sir, I used to use 1 different database, but now I reduced it to 1 and used another way to transfer the data, but I want to ask whether this method has the same logic as Insert into in PostgreSQL. My point here is Connect to PostgreSQL, then pull the table with Custom query, then transfer this table to another table with DB Connection Table Writer. This is the whole thing, but I don’t know if the operation I did and the insert operation are the same, can you explain this to me? [image]

@yusufINC if you already have the database in the same environment then you could use the DB Connection Table Writer to create or append your second database. [image] [image] DB SQL - H2 Database, create database and additional tables – mlauber71 DB SQL - H2 Database, create database and additional tables

Table transfer

KNIME Analytics Platform

mlauber71 March 15, 2024, 9:32am 2

@yusufINC welcome to the KNIME forum. You could check these examples with streaming: