I designed a ktr file for transformation. I need to configure the database connection details of production environment. How can I do this? Any suggestions?
相关问题
- Pentaho Data Integration (newest version) - Not de
- Error setting up initial repository in Pentaho Ket
- Pentaho CDE “All” option in “Select” component
- Create Datasource Hive on Pentaho hadoop
- Integrating Pentaho Reporting web frontend with cu
相关文章
- java调用kettle,main方法不报错,tomcat下运行报错,但不影响kettle的
- Data loading is slow while using “Insert/Update” s
- The system cannot find the path specified (Batch f
- Pentaho CDE reset parameter
- Refresh all components of Pentaho CDE dashboard
- Pentaho reportviewer URL not loading in iframe
- Pentaho DI - JSON Nested File Output
- JSON path parent object, or equivalent MongoDB que
I use environment variables.
Kettle home is just a link to directory. By default i have directory specially devoted to data-integration suite. It contains several versions of kettle.
Example
then there is a link to current default (something like alternatives in debian). It helps to have several versions of kettle on same machine.
now
is a link to main suite which will be used by default. This is made for jdk compbility reasons. Since 4.4.0 is jdk6 based, 5.2.0 jdk7 (and doesn't work on jdk8 since there is a bug in xstream xml library, but may be fixed already, 6.0 branch works well on jdk8 even it is built on jdk7)
Variables configured in /etc/profile. File jdbc.properties is located in
and shared by all jobs. This file, with connection settings, generated by puppet if network configuration changes. If administrators do something, puppet automatically will make new file in case of migrations.
For connection definitions I use naming rules
and so on ...