Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
This is a discussion on Can ETL tools transfer some delimited files into a MySQL database? within the Data Warehousing forums, part of the Databases category; 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 and heard about ...
|
|||||||
|
|||
|
Can ETL tools transfer some delimited files into a MySQL database?
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 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. |
| Sponsored Links |
|
|||
|
Re: Can ETL tools transfer some delimited files into a MySQL database?
Hello tomrust.
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? |
| The Following User Says Thank You to Talguru For This Useful Post: | ||
|
|||
|
Re: Can ETL tools transfer some delimited files into a MySQL database?
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. |
|
|||
|
Re: Can ETL tools transfer some delimited files into a MySQL database?
Im sorry for this late reply, I had not seen your answer.
I have spent a week on Talend and am starting to learn the software. Do you think I need to check Pentaho out? What are the pros and the cons of the software compared to Talend? I'm new to ETL tools and would like to get someone's advice on this. Thanks for your help. |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Data Transfer: from Access and Excel to MySQL database | tomrust | Data Warehousing | 4 | 08-10-2009 07:41 AM |
| Transfer files using UDP Protocol | Geek_Guest | Java | 4 | 12-21-2008 05:55 AM |
| Mysql Database connection | vikwin | QTP | 1 | 08-12-2008 04:21 AM |
| need some HELP here, regarding file transfer between 2 pcs | kalana | Networking | 0 | 08-03-2008 01:02 AM |
| Control file syntax to transfer data from multiple data files | Geek_Guest | Oracle Apps | 0 | 06-14-2007 11:35 AM |