Exploring Existing Database Implementations
PDI sources are invaluable when seeking example implementations of databases. Each of the PDI core database support classes is located in the org.pentaho.di.core.database
package found in the core/src folder.
For example, here are the classes that define behavior for some major database systems.
Database | DatabaseInterface Class |
---|---|
MySQL | org.pentaho.di.core.database.MySQLDatabaseMeta |
Oracle | org.pentaho.di.core.database.OracleDatabaseMeta |
PostgreSQL | org.pentaho.di.core.database.PostgreSQLDatabaseMeta |
When implementing a database plugin for a new database system, we recommended starting from an existing database class that already shares characteristics with the new database system.