LogoLogo
Ctrlk
Try Pentaho Data Integration and Analytics
  • Pentaho Documentation
  • Pentaho Data Integration
  • Get started with the PDI client
  • Use a Pentaho Repository in PDI
  • Data Integration perspective in the PDI client
  • Schedule perspective in the PDI client
  • Streaming analytics
  • Advanced 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
    • Data Catalog searches returning incomplete or missing data
  • 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