Thank you,
@Stephen Donovan.
As I understand your workaround, I should use Variables in database connection fixed attributes, like <server>, <type>, <access>, etc.
This is what I did. However, I need to support different database engines, like MySQL, SQL Server, etc. Therefore, I need to set up different database connection custom attributes. I cannot combine them into one single XML file.
For example, MySQL needs
- EXTRA_OPTION_MYSQL.defaultFetchSize
- EXTRA_OPTION_MYSQL.useCursorFetch
- etc
SQL Server needs
- MSSQLUseIntegratedSecurity
- MSSQL_DOUBLE_DECIMAL_SEPARATOR
- etc
In PDI-CE 8.0, I had two different Shared objects files. Those two files have the same database connection (the same name) but different attributes for MySQL and SQL Server separately. And I use a Variable in all ktr files Shared objects file field, so I can decide which database engine to connect to at runtime.
But it does not work now.
Do you think there will be a bug fix and a patch release sometime? Or there won't?
Thank you.
Regards,
Albert