Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: How to do a bulk Load ??

  1. #1
    Join Date
    Dec 2012
    Posts
    5

    Default How to do a bulk Load ??

    Hi, I am a newbie at PDI and wanted to know if there is a way to do a buld load from access databse (*.mdb)
    to One table sql server

    More detailed...
    I have 10 Access databases in which i have 5 tables (tblVendor, tblSales, tblOrder, tblInventary and tblEmployee)
    I want all the the Vendors form Access(*.mdbs) in MS SQL table (tblVendor) - 1 transformation
    Sales form Access(*.mdbs) in MS SQL table (tblSales) - 2 transformation
    .
    . so on into one .job


    My Question:
    Instead of doing each Access Input set ten time and SQL output tbl ten time
    is there a way to do one bulk update of all the Access tables into SQL tables

  2. #2
    Join Date
    Jan 2013
    Posts
    10

    Default

    same problem has also made me tensed me too finding a solution for such type of solution.. any help would be appreciated a lot
    Last edited by LidiaSchreck; 05-20-2013 at 07:59 AM.
    check this link >>> Harbor Freight Coupon


  3. #3
    Join Date
    Apr 2008
    Posts
    4,680

    Default

    Assuming that you have:
    DB1.mdb
    DB2.mdb
    DB3.mdb

    And each file has in it: tblVendor, tblSales, tblOrder, tblInventory, tblEmployee

    **AND** you don't want to make any other changes to the data...

    Build a Job:

    Job1 (Master):
    - Start
    - Transform (Get Files to Load)
    - - Get File Names (.*\.mdb)
    - - Copy Rows to Result
    - Job 2 (Set Vars and Process) **Execute for each row**
    - - Start
    - - Transform (Get Row and Set Vars)
    - - - Get Row From Results
    - - - Set Variable
    - - Transform (Process Row)
    - - - MDB Input (x5 - one for each table, source= ${ThisFile} )
    - - - Table Output (x5 - one for each table)
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

  4. #4
    Join Date
    Jun 2013
    Posts
    44

    Default

    i'm also juggling with the same kind of trouble and looking forward for some apt solutions may come to my way soon

  5. #5

    Default

    Anyone help me how to load bulk data into db2 through kettle

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2017 Pentaho Corporation. All Rights Reserved.