CSV to Database

Four Stars

CSV to Database

How to insert table and table data from CSV File to Database,please provide solution step by step


Accepted Solutions
Highlighted
Moderator

Re: CSV to Database

You're going to need 3 major components:

 

1.tFileInputDelimited

2.tMap

3.a Database output component

 

  • Use the tFileInputDelimited component to insert your CSV file.
  • Connect the tFileInputDelimited to the tMap component and map the columns you want to insert into your database.
  • Connect the tMap component to the Database output component using the output you created in tMap and ensuring all the database information is correct within the Database output component. 

Should look something like this when done.

csv to database example.JPG


All Replies
Thirteen Stars

Re: CSV to Database

  1. Start Talend Studio
  2. Click Import Demo Project
  3. Select Integration

Go thru huge number of examples

 

check site - https://www.talendbyexample.com

Screen Shot 2018-02-05 at 1.06.06 AM.pngScreen Shot 2018-02-05 at 1.05.36 AM.png

-----------
Highlighted
Moderator

Re: CSV to Database

You're going to need 3 major components:

 

1.tFileInputDelimited

2.tMap

3.a Database output component

 

  • Use the tFileInputDelimited component to insert your CSV file.
  • Connect the tFileInputDelimited to the tMap component and map the columns you want to insert into your database.
  • Connect the tMap component to the Database output component using the output you created in tMap and ensuring all the database information is correct within the Database output component. 

Should look something like this when done.

csv to database example.JPG

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.