FlowHeater - The Data Import / Export Specialist
See also the general examples available, which may answer your question: Hello World 1 / 2 / 3 , format numbers as character strings , simple If-Then-Else , complex If-Then-ElseIf , filtering and grouping data , consolidate grouped values

Two Different Source

  • Santosh P
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 6 months ago #3620 by Santosh P
Two Different Source was created by Santosh P
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.

More
1 year 6 months ago #3621 by FlowHeater-Team
Replied by FlowHeater-Team on topic Two Different Source
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

 

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
  • New Member
  • New Member
More
1 year 6 months ago #3622 by Santosh P
Replied by Santosh P on topic Two Different Source
In that case how can we join two tables created in Inmemory Database
 

Please Log in or Create an account to join the conversation.

More
1 year 6 months ago #3623 by FlowHeater-Team
Replied by FlowHeater-Team on topic Two Different Source
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.370 seconds

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2023 by FlowHeater GmbH.
All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en