Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Microsoft Access ODBC Slow

  1. #1

    Default Microsoft Access ODBC Slow

    Hi, is there an option within the database connection for a Microsoft Access ODBC that might speed up inserts?

    Inserting data into an Access table is torture. I've tried to use the "Access Output" step but when the option to "create database" is unchecked and the option to "create table" is checked, kettle seems to forget and actually unchecks the option to "create table". Also, leaving both options unchecked is just as slow as using a "Table Output" step with an ODBC connection to Microsoft Access.


  2. #2
    Join Date
    May 2006


    For the "unchecks create table" raise a defect at

    For the slowness, I don't know I mostly use Oracle and DB2.


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.