FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
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
  • Page:
  • 1

TOPIC:

Two Different Source 1 month 3 weeks ago #3620

  • Santosh P
  • Santosh P's Avatar 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.

Two Different Source 1 month 3 weeks ago #3621

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.

Two Different Source 1 month 3 weeks ago #3622

  • Santosh P
  • Santosh P's Avatar 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.

Two Different Source 1 month 2 weeks ago #3623

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.

  • Page:
  • 1
Time to create page: 0.165 seconds

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en