Talend ETL: Data Migration to SQL from Excel

Talend ETL Tutorial:

How to Migrate and Transform Excel Data to Load into Microsft SQL Server

The Excel spreadsheet has first and last name in one cell and the amount column contains values that are not written in a consistent format. The SQL server  database that we want to load it into a a first name column, a last name column, an account name column and an amount column. Since we want the Excel data to correlate with the formatting in the SQL database we will use Talend to transform the data within a few clicks. Find out how Talend extracts data, transforms it and eliminates the inconsistencies for the data can properly be loaded into the SQL Server database.  

Need Help with Talend?

[gravityform id="51"]

Get Started

Want a FREE on-site discovery session with your team?  Receive a FREE data management evaluation session with one of our veteran data architects. Reap the benefits of an expert’s outlook on taking control of your business insights and data. Stop missing out on data-driven opportunities,  and start making smarter, more profitable decisions today.