Automating MySQL Import

More
12 years 8 months ago #1418 by Scott
Once I've set up a process to load a text file into my MySQL DB,
can I save that process inside Advanced ETL Processor so that all I have to do it load it and run it to do the exact same process again?

I have one manual ETL process that I run against multiple exports of the same text file every month.

The layout of the file and the MySQL table are exactly the same, so I don't want to have to set up that process every time, I want to set it up once and just "run" it every time.

Steve

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

More
12 years 8 months ago #1419 by admin
Replied by admin on topic Re: Automating MySQL Import
Steve

Yes, you can save data transformation script into the file and execute it later.

Perhaps Professional version would be a better option for you.
It stores all the scripts the in the database.

Peter

Mike
ETL Architect

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