- Posts: 24
- Thank you received: 0
Automating MySQL Import
12 years 8 months ago #1418
by Scott
Automating MySQL Import was created 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
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.
12 years 8 months ago #1419
by admin
Mike
ETL Architect
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
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.