PDI supports over 50 database types natively (Oracle, MySQL, PostgreSQL, SQL Server, etc.). Furthermore, it handles Big Data ecosystems natively, connecting easily with Hadoop HDFS, Hive, Spark, Cassandra, and MongoDB.
Table Input → Filter Rows → Sort Rows → Table Output pentaho data integrator
Create a simple transformation that reads a CSV file and outputs it to an Excel sheet. Conclusion PDI supports over 50 database types natively (Oracle,