Pentaho Data Integration Community Edition 9.4 - Shared objects file feature of transformation doesn't support variable
Our company used Pentaho Data Integration Community Edition (PDI-CE) 8.0 (Linux). We are upgrading to the PDI-CE 9.4. In the process, we met an issue.
To reproduce the issue, clone the project https://github.com/albertwangnz/reproduce-shared-objects-file-issue-pdice-9.4.
When we used PDI-CE 8.0, we used the feature Shared objects file in the transformation Miscellaneous tab. We defined database connections in different files to support different database engines. We set up a variable DB_CONN_SHARED_FILE in a previous transformation step. The value of the variable is the location of a shared object file (XML), like sharefiles/database-connections-mysql.xml. Then we used the variable as the value of the Shared objects file field as shown below. So, we could dynamically support various database engines, like MySQL, SQL Server, with the same *.ktr files.
It used to work in PDI-CE 8.0. But after we upgraded to PDI-CE 9.4, it does not work anymore. If we hard-code the value in the Shared objects file field, as shown below, like sharefiles/database-connections-mysql.xml, it works. But the variable does not work anymore.
How can I fix it?
* The version of PDI-CE is 9.4.0.0-343
** The version of Linux is Ubuntu 18.04.6 LTS
Confirmed by Pentaho support this was a bug and there was no fix plan.
- Create a near real time DWH with Pentaho Community edition
- Set the charset for Firebird connection from Pentaho DI
- "RecursionError: maximum recursion depth exceeded" from ssl.py: `super(SSLContext, SSLContext).options.__set__(self, value)`
- Pentaho Data Integration Community Edition 9.4 - Shared objects file feature of transformation doesn't support variable
- Pentaho Data Integration 9.3 - Postgres Incremental load
- How to find unique values from set of rows using pentaho kettle?
- How to add zero in front of single digit values using REGEX in pentaho
- Pentaho File Repository Moves Jobs & Transformations to root
- Use a field from a previous hop as a parameter in a Table input using Pentaho Kettle
- Pentaho kettle Can't run transformation due to plugin missing
- Waiting for Transformations in a Job
- Pentaho CDE: Is there a way to debug the sql command being executed?
- Pentaho Kettle replace cell value if value exists in other two columns
- Git Not In Sync with Local Branch
- How to find where KETTLE HOME is defined
- REST API calls through Pentaho Data Integration (Spoon)
- Pentaho PDI || Windows Current User
- Pentaho check if at least one row LDAP is 0
- Get row number from stream to perform concat
- How input data in line chart in Pentaho?
- Pentaho-carte rest api?
- How to run Pentaho transformations in parallel and limit executors count
- Pentaho to kill all running transformations if any one them fails
- Pentaho Business Inteligence Automation
- How to delete rows which were deleted in source table (Pentaho data integration)
- Pantaho MySQL 8 connection error Driver class 'org.gjt.mm.mysql.Driver' could not be found
- No MongoDB option in Pentaho
- Pentaho metastore location when connecting to repository
- How to pass variables between steps inside a transformation in Pentaho
- How to run anaconda python with "execute a process" in Pentaho(PDI) in windows?