Dealing with external resources

Before starting with the development, make sure that you have access to all the external resources needed for your project. For example, if you work with a database, you will need the connection settings, the proper JDBC drivers to connect from PDI, and permissions to perform create, read, update, and delete known as CRUD operations. If you will access a remote server, for example, to upload or download files, verify the full paths to the remote folders and check for permissions to read and write. If you will send emails, verify the settings of the SMTP server.

Then, in the kettle.properties file, you could add variables pointing to all these resources:

# source data baseDB_HOST= DB_NAME= ...# warehouseDW_HOST= ...

Get Learning Pentaho Data Integration 8 CE - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.