automate transfer to a mysql database
Hi all
I receive regularly delimited files and I want to transfer them into a MySQL database. Ideally speaking, I would like the transfer to execute itself on a regular basis.
I heard that etl tools were able to do such a thing, is that right ?
Michael James Swan posted this at 21:10 — 20th August 2008.
He has: 400 posts
Joined: May 2008
I believe that the PMA should have some tools that could be used which are built in to your MySQL server.
This is not always the case so you may need to look around.
pr0gr4mm3r posted this at 21:14 — 20th August 2008.
He has: 1,502 posts
Joined: Sep 2006
A simple PHP script would take care of that. If you pull these CSV files from a specific location every time, PHP + a cron job would automate it nicely. Do you have any programming experience?
Tdgu posted this at 11:59 — 21st August 2008.
They have: 5 posts
Joined: Aug 2008
That's what I was going to ask...
If you have any some programming experience you will be able to take care of that with a simple script.
On the contrary , if you are a business user or if you are planning to perform other operations that data integration encompasses, you may want to use an ETL tool.
Some are user-friendly and open source.
You can have a look at Talend Open Studio for example, it is very easy to use even for non-technical users.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.