Can ETL tools transfer some delimited files into a MySQL database?

[SuperTom]

Hi everybody.

I have several delimited files and want to transfer their content to a MySQL database. Before asking on this forum, I've been browsing the net, talking to people and heard about open source ETL tools easy to use for non technical users. Can these products really be used by people who dont have much technical background like me and which one do you think is the most user-friendly ?

Thanks a lot for your feedback.

[shokosugi]

Yes there are dozens of ETL tools and even MySQL GUI front-ends that you can use to import/export CSV files to/from a a MySQL database. SQLYog is one.

[Gtal]

Hello!

ETL tools are able to perform the transfer you're describing.
Working for Talend, we have an ETL tool you can use.
Since you describe yourself as a non-technical user, I won't waste your time with technical considerations. Simply put, Talend Open Studio is an open source ETL tool with a user-friendly GUI, easy to learn for a non-technical user.

But what really distinguishes Talend from other tools, when it comes to business users, is the tMap component which allows the user to get a graphical and functional view of integration processes.
Now back to your question, do you only have CSV files or also other files?

[SuperTom]

Thanks for your answer. I'm going to have a look at Talend Open Studio, and try to give feedback asap.
Yes the files I want to load in the MySQL database are all csv files.

[Charlie630]

I am not sure if have finished your project yet or found the right program for your use, but I just wanted to put in my two cents about a project I just did using Pervasive ETL tools. It worked really well, and I was able to learn how to use it fairly easily, without ripping a hole in my wallet. I hope this helps.

[ejboy]

I'd recommend to give Scriptella ETL a try. It's the only open source tool I know licensed under commercial friendly Apache License.
See Load CSV data into a database (Scriptella ETL tool) [database] [csv] [JDBC] [scriptella] for a simple example on how to load CSV data into a database.

[angeldemon]

you can use Informatica if you have the budget or SQLYog or even phpMyadmin.