Export and Import of mappings/process flows etc

Advertisement
Hi,
We have a single repository with multiple projects for DEV/UAT and PROD of the same logical project. This is a nightmare for controlling releases to PROD and in fact we have a corrupt repository as a result I suspect. I plan to split the repository into 3 separate databases so that we have a design repos for DEV/UAT and PROD. Controlling code migrations between these I plan to use the metadata export and subsequent import into UAT and then PROD once tested. I have used this successfully before on a project but am worried about inherent bugs with metadata export/imports (been bitten before with Oracle Portal). So can anyone advise what pitfalls there may be with this approach, and in particular if anyone has experienced loss of metadata between export and import. We have a complex warehouse with hundreds of mappings, process flows, sqlldr flatfile loads etc. I have experienced process flow imports that seem to lose their links to the mappings they encapsulate.
Thanks for any comments,
Brandon
Advertisement

Replay

This should do the trick for you as it looks for "PARALLEL" therefore it only removes the APPEND PARALLEL Hint and leaves other Hints as is....
#set current location
set path "C:/TMP"
# Project parameters
set root "/MY_PROJECT"
set one_Module "MY_MODULE"
set object "MAPPINGS"
set path "C:/TMP
# OMBPLUS and tcl related parameters
set action "remove_parallel"
set datetime [clock format [clock seconds] -format %Y%m%d_%H%M%S]
set timestamp [clock format [clock seconds] -format %Y%m%d-%H:%M:%S]
set ext ".log"
set sep "_"
set ombplus "OMBplus"
set omblogname $path/$one_Module$sep$object$sep$datetime$sep$ombplus$ext
set OMBLOG $omblogname
set logname $path/$one_Module$sep$object$sep$datetime$ext
set log_file [open $logname w]
set word "PARALLEL"
set i 0
#Connect to OWB Repository
OMBCONNECT .... your connect tring
#Ignores errors that occur in any command that is part of a script and moves to the next command in the script.
set OMBCONTINUE_ON_ERROR ON
OMBCC "'$root/$one_Module'";      
#Searching Mappings for Parallel in source View operators
puts "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Searching for Loading/Extraction Operators set at Parallel";
puts "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Module: $one_Module, Object_type: Mapping";
puts $log_file "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Searching for Loading/Extraction Operators set at Parallel";
puts $log_file "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Module: $one_Module, Object_type: Mapping";
foreach mapName [OMBLIST MAPPINGS] {
foreach opName [OMBRETRIEVE MAPPING '$mapName' GET TABLE OPERATORS] {
foreach prop1 [OMBRETRIEVE MAPPING '$mapName' OPERATOR '$opName' GET PROPERTIES (LOADING_HINT)] {
if { [ regexp $word $prop1] == 1 } {
incr i
puts "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Mapping: $mapName, Loading Operator: $opName, Property: $prop1"
puts $log_file "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Mapping: $mapName, Loading Operator: $opName, Property: $prop1"
OMBALTER MAPPING '$mapName' MODIFY OPERATOR '$opName' SET PROPERTIES (LOADING_HINT) VALUES ('');
OMBCOMMIT;
foreach prop2 [OMBRETRIEVE MAPPING '$mapName' OPERATOR '$opName' GET PROPERTIES (EXTRACTION_HINT) ] {
if {[regexp $word $prop2] == 1 } {
     incr i
puts "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Mapping: $mapName, Extraction Operator: $opName, Property: $prop2"
puts $log_file "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Mapping: $mapName, Extraction Operator: $opName, Property: $prop2"
OMBALTER MAPPING '$mapName' MODIFY OPERATOR '$opName' SET PROPERTIES (EXTRACTION_HINT) VALUES ('');
OMBCOMMIT;
foreach opName [ OMBRETRIEVE MAPPING '$mapName' GET DIMENSION OPERATORS ] {
foreach prop1 [OMBRETRIEVE MAPPING '$mapName' OPERATOR '$opName' GET PROPERTIES (LOADING_HINT) ] {
if {[regexp $word $prop1] == 1 } {
     incr i
puts "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Mapping: $mapName, Loading Operator: $opName, Property: $prop1"
puts $log_file "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Mapping: $mapName, Loading Operator: $opName, Property: $prop1"
OMBALTER MAPPING '$mapName' MODIFY OPERATOR '$opName' SET PROPERTIES (LOADING_HINT) VALUES ('');
OMBCOMMIT;
foreach prop2 [OMBRETRIEVE MAPPING '$mapName' OPERATOR '$opName' GET PROPERTIES (EXTRACTION_HINT) ] {
if {[regexp $word $prop2] == 1 } {
     incr i
puts "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Mapping: $mapName, Extraction Operator: $opName, Property: $prop2"
puts $log_file "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Mapping: $mapName, Extraction Operator: $opName, Property: $prop2"
OMBALTER MAPPING '$mapName' MODIFY OPERATOR '$opName' SET PROPERTIES (EXTRACTION_HINT) VALUES ('');
OMBCOMMIT;
foreach opName [ OMBRETRIEVE MAPPING '$mapName' GET CUBE OPERATORS ] {
foreach prop1 [OMBRETRIEVE MAPPING '$mapName' OPERATOR '$opName' GET PROPERTIES (LOADING_HINT) ] {
if {[regexp $word $prop1] == 1 } {
     incr i
puts "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Mapping: $mapName, Loading Operator: $opName, Property: $prop1"
puts $log_file "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Mapping: $mapName, Loading Operator: $opName, Property: $prop1"
OMBALTER MAPPING '$mapName' MODIFY OPERATOR '$opName' SET PROPERTIES (LOADING_HINT) VALUES ('');
OMBCOMMIT;
foreach prop2 [OMBRETRIEVE MAPPING '$mapName' OPERATOR '$opName' GET PROPERTIES (EXTRACTION_HINT) ] {
if {[regexp $word $prop2] == 1 } {
     incr i
puts "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Mapping: $mapName, Extraction Operator: $opName, Property: $prop2"
puts $log_file "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Mapping: $mapName, Extraction Operator: $opName, Property: $prop2"
OMBALTER MAPPING '$mapName' MODIFY OPERATOR '$opName' SET PROPERTIES (EXTRACTION_HINT) VALUES ('');
OMBCOMMIT;
foreach opName [ OMBRETRIEVE MAPPING '$mapName' GET VIEW OPERATORS ] {
foreach prop1 [OMBRETRIEVE MAPPING '$mapName' OPERATOR '$opName' GET PROPERTIES (LOADING_HINT) ] {
if {[regexp $word $prop1] == 1 } {
     incr i
puts "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Mapping: $mapName, Loading Operator: $opName, Property: $prop1"
puts $log_file "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Mapping: $mapName, Loading Operator: $opName, Property: $prop1"
OMBALTER MAPPING '$mapName' MODIFY OPERATOR '$opName' SET PROPERTIES (LOADING_HINT) VALUES ('');
OMBCOMMIT;
foreach prop2 [OMBRETRIEVE MAPPING '$mapName' OPERATOR '$opName' GET PROPERTIES (EXTRACTION_HINT) ] {
if {[regexp $word $prop2] == 1 } {
     incr i
puts "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Mapping: $mapName, Extraction Operator: $opName, Property: $prop2"
puts $log_file "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Mapping: $mapName, Extraction Operator: $opName, Property: $prop2"
OMBALTER MAPPING '$mapName' MODIFY OPERATOR '$opName' SET PROPERTIES (EXTRACTION_HINT) VALUES ('');
OMBCOMMIT;
if { $i == 0 } {
          puts "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Module: $one_Module, Object_type: Mapping";
          puts "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Not found any Loading/Extraction Operators set at Parallel";
          puts $log_file "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Module: $one_Module, Object_type: Mapping";
          puts $log_file "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Not found any Loading/Extraction Operators set at Parallel";
     } else {
          puts "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Module: $one_Module, Object_type: Mapping";
          puts "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Fixed $i Loading/Extraction Operators set at Parallel";
          puts $log_file "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Module: $one_Module, Object_type: Mapping";
          puts $log_file "[clock format [clock seconds] -format "%Y%m%d %H:%M:%S"] --> Fixed $i Loading/Extraction Operators set at Parallel";
close $log_file;
Enjoy!
Michel

Query on Database Export and Import

Hi Techies, Currently we are running our Database on Oracle 10g and SAP on4. and OS is HP UX 11.11. We have a plan to migrate our HW from PA-RISC to Itanium and at the time of Production migration we are planning to use Export and Import method to ge

Export and import of 3 Gb table

Dear , I have table with more than 3 million records, i need to export this table and import into a different database . can you please help me with the export and import options options so that i can speed up the process... for you information this

Possible to convert Raw to JPEG without exporting and importing?

I have about 4,500 raw photos that I need to print on contact sheets (or print contact sheets to a PDF). I took the photos all in Raw format. Aperture, or my computer, is not powerful enough to process all of these photos onto contact sheets from the

Export and import XMLType table

Hi , I want to export one table which contain xmltype column form oracle 11.2.0.1.0 and import into 11.2.0.2.0 version. I got following errors when i export the table , when i tried with exp and imp utility EXP-00107: Feature (BINARY XML) of column Z

Export and Import of Schemas (PY and TM)

Hi All, Is there a way to Export and Import Schemas (PY and TM)? Do exist a report standard, or custom , to do it? Or if somebody knows all the tables behind a schema. Because we have tried to load some tables but when we see the schema some descript

Export and import of an table data

Hi All, I have a situation where i need to append/import  the production table ( X )  data to test table ( X ) which has some data already in it and should not be lost  during the operation. The record count is around 6 million . Any expert suggestio

Exporting and Importing Destination Controls Error

When I export table within destination control and import the table to another Ironport again within destination control I receive error - "Wrong format of the destination config file: ip_sort_pref is required for the global settings." We are up

WSUS - Server 2012 R2 - Export and Import

Greetings, I have a Server 2012 R2 system with the WSUS role installed.  This server resides on a disconnected network so we must bring updates from an online WSUS server.  I have experience performing successful exports and imports in the past with

How I can Export and Import tables using BRTOOL ?

Dear All, Since we upgrade the oracle from 9.0.2 to 10.2.2 we not using SAPDBA any more. please help me if you now how to export and import tables in sapr3 using brtools? thanks and Best regards, ChrisnaDear Chrisna, first of all you should get the r

Data Export and Import

Hello, I need a suggestion. I have two databases namely DB1 and DB2 and they are on different servers S1 and S2 respectively. What could be my approach to move data from DB1 to DB2. 1:-Do i need a database link to do this. 2:-Can i do this without DB

Steps to export and import oracle 10g databse from AIX to AIX and LINUX

Hi, I need the steps to export the oracle 10g database from AIX server to AIX server and LINUX server. Please give me all the steps as this is my first exort an import activity. thanks,For 10g there exist two ways to do so. 1) Regular exp/imp. 2) Dat

Require help in understanding exporting and importing statistics.

Hi all, I am bit new to this statistics. Can anyone please explain me in detail about these commands. 1) exec DBMS_STATS.GATHER_TABLE_STATS (ownname => 'MRP' , tabname => 'MRP_ATP_DETAILS_TEMP', estimate_percent => 100 ,cascade => TRUE); 2) ex

XML Export and Import

Hi      I knew that BW  metadata can be trasformed using XML Using export and Imoport but how to make selection of set of  BW objects through metadata export and import in XML format.      For example i would like to export some 10 infoobjects to the

Scripting Oracle export and import dumps

Hello, I would like to know if it is possible to script oracle export and import dump commands in a PL/SQL package rather than at command prompt. Also, how can i copy the export dump files across the network to a specific location. I would really app

How export and Import ADF-BC

Hi all, How i do to export and import ADF-BC, of one project to other ? Thank's AlexandreHi, may be this thread helps: Linking two projects TimoRead other 2 answers

Export and import the windows phone contacts as .vcf file to the application

Hi, I need to export the windows phone contacts as .vcf file and import it to my windows phone application. I'm unable to import the full details of a contact. Is there any sample code to export and import phone contacts programmatically. Please help

Exporting and Importing OIM Groups

Hi I am trying to export and import OIM Groups from one environment to another. It looks like some of the details of the groups (such as Administrative Groups details) are missing after the import. Any ideas? I will assign Points. Thanks Regards Vija

How to export and import from AIX to solaris a whole schema with different

how to export and import from AIX to solaris a whole schema with different character set import done in US7ASCII character set and AL16UTF16 NCHAR character set import server uses WE8ISO8859P1 character set (possible charset conversion) Import termin

Audio Export and Import

I recorded audio of about 30 slides. I found some HUM and Buzzing in audio so i exported it out via the export and edited the audio in audition. Can i import all the audio back in one shot? Also when i export it says SLIDE 1 - RECORDING 150 and then,