LogoLogo
Ctrlk
Try Pentaho Data Integration and Analytics
  • Pentaho Documentation
  • Pentaho Data Integration 10.2
  • Get started with the PDI client
  • Use a Pentaho Repository in PDI
  • Scheduler perspective in the PDI client
  • Streaming analytics
  • Data Integration perspective in the PDI client
  • Advanced Pentaho Data Integration topics
  • Troubleshooting possible data integration issues
    • Troubleshooting transformation steps and job entries
    • Troubleshooting database connections
      • Unsupported databases
      • Database locks when reading and updating from a single table
      • Force PDI to use DATE instead of TIMESTAMP in Parameterized SQL queries
      • PDI does not recognize changes made to a table
    • Jobs scheduled on Pentaho Server cannot execute transformation on remote Carte server
    • Cannot run a job in a repository on a Carte instance from another job
    • Troubleshoot Pentaho data service issues
    • Kitchen and Pan cannot read files from a ZIP export
    • Using ODBC
    • Improving performance when writing multiple files
    • Snowflake timeout errors
    • Log table data is not deleted
  • PDI transformation steps
  • PDI job entries
Powered by GitBook
On this page
  1. Troubleshooting possible data integration issues

Troubleshooting database connections

If you have issues with database connection in PDI, check to see if any the following conditions apply to your situation.

  • Unsupported databases

  • Database locks when reading and updating from a single table

  • Force PDI to use DATE instead of TIMESTAMP in Parameterized SQL queries

  • PDI does not recognize changes made to a table

PreviousStep is already on canvas errorNextUnsupported databases

Last updated 4 months ago

LogoLogo

About

  • Pentaho.com

Support

  • Pentaho Support

Resources

  • Privacy

© 2025 Hitachi Vantara LLC