promoting the ODI package from Dev to UAT
starakAug 16 2012 — edited Aug 16 2012Hi Guru's,
This is the first time I am trying to make the dev code work in UAT.
Quite a novice. Need help.
We don’t have a separate Dev server.
So we were provided with a Dev Database in the same UAT server. So we have one ODI server installation pointing to 2 DB instances.
Basically we have:-
1 Master Rep (in Dev DB)
1 Work Rep (in Dev DB)
1 Work Rep (in UAT DB)
To test:-
I have created an ODI package to upload data from flat file to Oracle Table (target_tab) in Dev DB. It executes successfully.
Same table (target_tab) has been created in UAT database.
Now I want to execute the same in UAT. How to promote the ODI Package/scenario code to UAT.
What should I be exporting .....
1) Work Rep
2) ODI Project
3) Model
4) Topology
5) Agents
6) what else?
Note: Though the Table name is same in both Dev and UAT but the schema name is different in both these DB environments.
I am concerned that will the imported code work successfully in UAT since the schema names of the target table is different in UAT?
Regards
starak