How to transfer ETL sources from one repository to another repository

[haru0202]

Hi all

Help me.

I can't transfer ETL source correctly.

I have two kettle repositories.

One is developing and testing environment(DEV).
Another is production environment(PRD).

I want to transfer ETL sources from DEV to PRD.

Following is my procedures.

1. Open ETL source from DEV repository.
2. Change repository to PRD repository. (Display shows Step 1 's ETL source.)
3. Save ETL source to PRD repository.

If there are same name ETL source, I can save it.
But if not, even though I can save it, database connection in transfered ETL source is broken.

Please tell me how to transfer ETL source from DEV repository to PRD repository.

Regards.

[aghuge]

To transfer transformations/jobs from one repository to another, you have to first export them from dev environment to an xml file (File->Export to an xml), save it as .ktr on your desktop/machine.

Then change the repository to prod repository and import the xml file from the desktop, edit the database connections, and save.

You want to check/change the database connection settings as you must be using different databases for dev and prod!

Hope this helps.
Good luck,