Hi all, Here is my problem: I have several delimited files and I want to transfer their content to a MySQL database. Before asking on this forum, I've been browsing the net and I heard about ETL tools that are open source and easy to use for non technical users. Can these products really be used by people who don't have much technical background and which one do you think is the most user-friendly ? Thanks.
Hello, truster, indeed, ETL tools are able to perform the transfer you're describing. And Talend, my employer, produces such a tool. 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 which is easy to learn for a non-technical user. But what really distinguishes Talend Open Studio 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 (excel sheets for instance) ?
Thanks for your answer. I'm going to have a look at Talend Open Studio, and try to give a feedback asap. And yes the files I want to load in the MySQL database are all csv files.
Well ok then. By the way, if you have only csv files you may also import them directly in your mySQL database with : LOAD DATA INFILE 'path/file.txt' INTO TABLE your_table;
Hi there, I've been trying Talend Open Studio and it can do much more things than I thought... What's more, with such a nice GUI (and the "job designer" part) it is really easy to understand the transfer/transformation/loading/synchronization/... you're implementing. Really a nice program, but it may be difficult to use on an old pc.
Did you manage to do what you wanted ? I am glad to hear that you were able to use the program smoothly. Concerning the "old pc" matter, you can use Talend Open Studio on old computers but the jobs will take more time to execute themselves, that's all.
Yes I managed to do it ! The program is really easy to use for business users, but some friend of mine (more of a technical user than me) told me that there was a "java debugger". Is that right ?
Indeed Talend Open Studio does have a "java debugger". But such features as "java debugger" or "code injection" are more intended for technical users (that's why your friend noticed it straightaway). Simply put, TOS is to be used by business users (for it has a user-friendly GUI, easy to master) but also by technical users (for it has features like a "java debugger") If you need extra information about the "java debugger" you can have a look at the User Guide. And don't hesitate if you have other questions
Thanks for everything, I won't hesitate if I have other projects needing the use of Talend Open Studio.
Yeah don't hesitate, since it has many features and encompasses the whole ETL process you might need to use TOS again in future projects ;-)
For more information and to get answers about Talend, I would suggest you look at Talendforge. The site, well documented, will be able to help you : http://www.talendforge.org/