TOPIC:

Hi,

Need to join two tables which are in different sources (one is in postgres and another is in mysql) and insert data to destination table which is in mysql.

looking for assistance.

Hi Santosh,

Is possible but a bit tricky. You need at least two or more processing steps and the help of the InMemory Adapter .

By following the links below you´ll find two examples that explain how to use it more in detail. The examples using different Adapters as you need but it will work with MySQL and PostgreSQL as well. In case you need afterwards more assistance we can digging deeper and finding out the right solution for you.

Examples

1. Merging CSV and Excel data using an SQLite database
2. Migrating data to MySQL

 

In that case how can we join two tables created in Inmemory Database
 

Hi Santosh,

Join Tables are currently not supported by InMemory Adapter Tables. In case you need Joined Tables you could use a temporary SQLite database/tables instead. This scenario is descripted in the first example.

Do you need a 1:n relation? If not you just need one InMemory Adapter Table. It would be possible to import your first table and in a second add more fields and update the related records.