I need to achieve the following:
1. Connect Pentaho Data Integration to our Primavera P6 system (Oracle backend) and extract data
2. Connect to our JIRA system (Oracle backend) and extract data
3. Transfer data between these two systems.
NOTE: connecting directly to the Oracle databases is not an option, we need to connect through a plugin or custom driver to both P6 and JIRA.