-
Santosh P
-
Topic Author
-
Offline
-
Posts: 6
-
-
|
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.
|
Please Log in or Create an account to join the conversation.
|
-
FlowHeater-Team
-
-
Offline
-
Posts: 391
-
-
-
-
|
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
-
Merging CSV and Excel data using an SQLite database
-
Migrating data to MySQL
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
|
Please Log in or Create an account to join the conversation.
|
-
Santosh P
-
Topic Author
-
Offline
-
Posts: 6
-
-
|
In that case how can we join two tables created in Inmemory Database
|
Please Log in or Create an account to join the conversation.
|
-
FlowHeater-Team
-
-
Offline
-
Posts: 391
-
-
-
-
|
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.
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
|
Please Log in or Create an account to join the conversation.
|
Time to create page: 0.163 seconds