在 Pentaho PDI 中迁移转换 [英] Migrating Transformations in Pentaho PDI

问题描述

我们使用两台服务器，一台作为预生产，另一台作为生产.当我们将作业或转换从 preprod 迁移到 Prod 时，它也会复制其连接属性，这会影响我们的生产作业执行.有人可以让我知道如何迁移转换而不处理它与另一台服务器的连接.

We are using two servers, one as preprod and other as Production. When we are migrating jobs or Transformations from preprod to Prod it copies its connection properties as well and this affects our Production job execution. Can someone let me know how to migrate transformations without coping it's connections to another server.

推荐答案

从工具"->选项"菜单中，有两个复选框会影响 PDI 的导入行为:在打开/导入时替换现有对象"和替换对象前询问"".

From the Tools->Options menu, there are two checkboxes that effect PDI's import behavior: "Replace existing objects on open/import" and "Ask before replacing objects".

通常在环境之间迁移时，我将第一个选项设置为 false.这样，如果连接定义已经存在，则不会被替换.另一种方法是选中两个选项并在要求替换现有定义时回答否".

Normally when migrating between environments, I set the first option to false. That way if a connection definition already exists, it is silently not replaced. The other way to go is to check both options on and answer 'No' when asked to replace an existing definition.

通过这种方式，在 pre-prod 上运行的转换/作业可以简单地导出并导入到 prod 中而无需更改任何内容，并且只要连接的名称相同，它就可以在新环境中针对 prod 运行.

In this way, a transform/job that runs on pre-prod can simply be exported and imported into prod without changing anything, and it runs against prod in the new environment as long as the connections are named the same.

唯一需要注意的是第一次导入新的连接定义.将不会有新的连接对象正在创建的警告，并且在导入后，它仍然会指向 pre-prod.每次导入新连接后，您都需要更改连接定义以指向新环境.好消息是你只需要做一次.

The only thing to watch out for is importing a new connection definition for the first time. There will be no warning that a new connection object is being created, and after import, it will still point to pre-prod. After each new connection import, you need to change the connection definition to point to the new environment. The good new is you only have to do that once.

我希望他们有一个选项，或者只是一个信息对话框来显示由于导入而创建的所有新连接对象；这样你就会确切地知道你需要改变什么.但唉——耳垢.

I wish they had an option, or just an info dialog to show all new connection objects created as a result of the import; that way you would know exactly what you need to change. But alas -- earwax.

这篇关于在 Pentaho PDI 中迁移转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！