Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: "union" several .DB files into a single mysql table

"union" several .DB files into a single mysql table 2 years 10 months ago #15610

  • Andrew
  • Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 51
  • Thank you received: 0
We have an accounting software that keeps its internal database in Borland Paradox.
Using Data Exchange Wizard we can browse through the tables of the BDE data source, so this part is OK.

I need to be able to "union" several .DB files into a single mysql table.
Each month the accounting software creates a new file that needs to be part of the model.

So basically my questions are:
1. How can we add data from more .DB files to a single mysql table
2. How can we automate the process in such a manner that the new .DB files produced by the software are automatically added in the ETL process, without human intervention each month

The reason we want to automate is because there are hundreds of this ETL processes that need manual intervention.

Thank you,
Andrew

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

"union" several .DB files into a single mysql table 2 years 10 months ago #15611

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7572
  • Karma: 33
  • Thank you received: 415
Data Exchange Wizard is very old software.
It is still supported
It was not designed for automation.
Advanced ETL Processor is a better option for your case.
Give us couple of hours and we will create a working example for you
Mike

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

"union" several .DB files into a single mysql table 2 years 10 months ago #15613

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7572
  • Karma: 33
  • Thank you received: 415
Hi Andrew.

We have created this WIKI page for you
www.etl-tools.com/wiki/knowledgebase:using_variables
Mike

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

  • Page:
  • 1

We have 173 guests and no members online