HomeForum
Welcome, Guest

Automating MySQL Import
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Automating MySQL Import

Automating MySQL Import 1 year, 3 months ago #1418

  • Scott
  • OFFLINE
  • Junior Boarder
  • Posts: 24
  • Karma: 0
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

Re: Automating MySQL Import 1 year, 3 months ago #1419

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2174
  • Karma: 12
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
  • Page:
  • 1
Time to create page: 0.15 seconds

Testimonials

Advanced ETL Processor's ability to validate and tranform data without actually loading it into the datawarehouse has saved us a lot of time. We were able to see how data will look like, once it is transformed and which records would fail during data validation.

Antony Clark,
RBS 

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top