Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • How to insert data from CSV file to MYSQL DB using Pentaho

    @aditya.raturi
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 2.23k
    Comment on it

    Step 1: Create an Input, drag and drop CSV File Input from Input step into your Transformation. Right click, edit the Input file. Provide File Name, click on Get Fields, then Preview to have a look in your input file. Double check the file type, format and length.

    Step 2(optional): To add any transformation such as Sort rows, Calculator, Add Constants etc., expand transformation and select the choice.

    Step 3: Create an Output, drag and drop Table Output from Output step into your Transformation. Create a DB Connection. Create Table in DB.

    Step 4: Map the Input and Output.

    Pentaho ETL Kettle Insert Data from CSV to MySQL
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: