Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: write in ms access db

  1. #1
    Join Date
    Mar 2009
    Posts
    26

    Default write in ms access db

    hi :-)

    i want to write some data in ms access db

    i don't know very well how to use ms access
    i succeeded in make a table with some fields in ms access, and then put some data in with pantaho

    is it possible to create a ms access table directly with pantaho ?
    if not, is it possible to delete the content to overwrite with pantaho, when there is already some data in the table ?

  2. #2
    pstoellberger Guest

    Default

    How do you load the data into MS Access?
    Via ODBC connection or Access Output Step?
    ODBC: Just tick the "truncate table" checkbox
    Access output: You can't delete the content there, but you can create a new table given a name value and tick the "Create Table" checkbox

  3. #3
    Join Date
    Mar 2009
    Posts
    26

    Default

    Quote Originally Posted by pstoellberger View Post
    Access output: You can't delete the content there, but you can create a new table given a name value and tick the "Create Table" checkbox
    OK, thank you :-)

    since it is able to create a ms access db from scratch, i don't understand why it's not able to overwrite
    maybe is there a step which allow to delete a file ? and i could use it just before re-create the db ?

  4. #4
    pstoellberger Guest

    Default

    Try to have a closer look at the tool! :-)
    Delete File is on Job Level in PDI: http://wiki.pentaho.com/display/EAI/Delete+a+file

    Kettle Documentation: http://wiki.pentaho.com/display/EAI

  5. #5
    Join Date
    Mar 2009
    Posts
    26

    Default

    Quote Originally Posted by pstoellberger View Post
    Try to have a closer look at the tool! :-)
    Delete File is on Job Level in PDI: http://wiki.pentaho.com/display/EAI/Delete+a+file

    Kettle Documentation: http://wiki.pentaho.com/display/EAI
    OK, i hadn't have a look to jobs, i made only a transformation :-)

    all is fine, thank you very much :-))

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 - 2019 Hitachi Vantara Corporation. All Rights Reserved.