How do we povision a VDB for peoplesoft.

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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?
Photo of Mohan Krishna Ballu

Mohan Krishna Ballu

  • 100 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,732 Points 4k badge 2x thumb
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
Photo of Mohan Krishna Ballu

Mohan Krishna Ballu

  • 100 Points 100 badge 2x thumb

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.

Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,732 Points 4k badge 2x thumb
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/pierrefor...

Regards,

Mouhssine
Photo of Mohan Krishna Ballu

Mohan Krishna Ballu

  • 100 Points 100 badge 2x thumb

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.

Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,732 Points 4k badge 2x thumb
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
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,732 Points 4k badge 2x thumb
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
Photo of Mohan Krishna Ballu

Mohan Krishna Ballu

  • 100 Points 100 badge 2x thumb

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.


Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,732 Points 4k badge 2x thumb
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
Photo of Gene Patton

Gene Patton

  • 60 Points
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