Delphix Products

Expand all | Collapse all

How do we povision a VDB for peoplesoft.

  • 1.  How do we povision a VDB for peoplesoft.

    Posted 11-28-2016 04:44:00 PM
    If the schemas that hold metadata info in peoplesoft is different across the environments. How do we provision VDB from prod source so that peoplesoft team doesn't need to change any config?
    #Reporting


  • 2.  RE: How do we povision a VDB for peoplesoft.

    Posted 11-28-2016 04:52:00 PM
    Hi Mohan, You have to implement post clone operations of ps schema as hooks of the vdb "at config time". This way once the vdb is created the hooks will fire up and change the schema to sweet the non-prod application server. (Meaning the app team will have no work to do just go and connect). Regards, Mouhssine


  • 3.  RE: How do we povision a VDB for peoplesoft.

    Posted 11-28-2016 05:00:00 PM

    Hi Mouhssine,

    People soft application has meta-data info and a table with login credentials in the PS schema. Now that PS schema has suffix P in prod and suffix D/T/A in LE how do we implement it? if we have script to preserve the metadata tables it will go into suffix D/T/A will that work as the PS schema is coming from prod which has suffix P.


    Thanks

    Mohan k.



  • 4.  RE: How do we povision a VDB for peoplesoft.
    Best Answer

    Posted 11-28-2016 06:05:00 PM
    Hi Mohan, This a 100% oracle operations and delphix has nothing to do with it. So the idea is to rename the PS schemas to switch the environment, I can perpose 2 way do achieve your need : 1- do export / import with schema remap (this is a full schema export/import) 2- you can use export / import with exporting only tablespace metadata and reasign the tablespace data file to the new schema (e.g. https://www.google.fr/amp/s/pierreforstmanndotcom.wordpress.com/2015/02/27/how-to-rename-an-oracle-schema-without-exporting-and-importing-all-schema-data Regards, Mouhssine


  • 5.  RE: How do we povision a VDB for peoplesoft.

    Posted 11-28-2016 06:17:00 PM

    Hi Mouhssine,

    Thanks for the update. but that will take off the delphix benefits as we end up spending time with export/import.


    Thanks

    Mohan k.



  • 6.  RE: How do we povision a VDB for peoplesoft.
    Best Answer

    Posted 11-28-2016 06:33:00 PM
    Hi Mohan, Not agree with you. Delphix still allow clone in minutes, branch vdb, mask data, accelerat testing and développement cycles and so ... Regards, Mouhssine


  • 7.  RE: How do we povision a VDB for peoplesoft.

    Posted 11-29-2016 05:34:00 AM
    Hi Mohan, The easiest way I found is : a) create schema with good prefix on new vdb b) fill it with synonyms pointing to tables with production prefix (to avoid doing exp/imp) And try every feature delphix and vdbs can provide you with. If your are happy with product you should work on the question of schema with prefix do you need to have as prerequisite or avoid it to ease cloning ops. regards, Mouhssine


  • 8.  RE: How do we povision a VDB for peoplesoft.

    Posted 11-29-2016 02:56:00 PM
    Macys refreshes existing Peoplesoft Virtual Databases every morning using the Delphix scheduler. The process takes minutes to complete, it's near real-time production DB replacement and provides huge storage savings.

    The app layer is already customized for that particular database, so only a post sql script (we call it a hook) needs to be issued, to customize the data content, after the data refresh completes.  You already have that script created so you can just place the code in our hook operation.

    Gene


  • 9.  RE: How do we povision a VDB for peoplesoft.

    Posted 12-13-2016 02:31:00 PM

    Hi Mouhssine,


    Yes I added a script to run as part of the post refresh to create synonyms and grant Lower environment schema to access the source schema objects via synonyms.

    But unfortunately there are inbuilt peoplesoft process and custom written code which is trying to truncate temp tables but it cannot truncateas it will not work against synonym.

    Now if we have different schema names across the environment then looks like it is not possible to make delphix work with peoplesoft.


    Do you see any other options which we can use?


    Thanks

    Mohan k.




  • 10.  RE: How do we povision a VDB for peoplesoft.

    Posted 12-13-2016 02:50:00 PM
    Hi Mohan, It's really specific to you case, because of the prefix used on your standard naming Unfortunately, the only way I see is to stay on standard meaning avoir personalizing schema names with prefix, this way you will have the same name for every environment. Please take in consideration that delphix have no knowledge Schema, tables, synonym... , and per standard database we can't rename shema with a simple "alter command ..." beceause there is no command like this. As we say "personnalisation is the enemy of automation" Regards, Mouhssine