I’ve finally spent some development/brain cycles working on automating our babel updates here at UNMC. It now takes about 2.5 minutes for our babel update to happen now – using some of the same ideas used to move our Oracle data into Postgresql to construct the new identified warehouse. I have shell access to babel, so I may have some options that other places do not, but I think my code could be used by other sites (or perhaps others have the process well honed already, and I am trailing the pack here). The code exports the metadata, copies it to babel, and generates and executes the update statements for babel’s table_access table.
If it is of interest, I’ll put something up on bitbucket or elephant. Hubert Hickman Systems Sr. Analyst [email protected] (402) 559-4838 ________________________________ Nebraska Medicine E-mail Confidentiality Disclaimer The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender. _______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
