Delphix Products

Hello all, 

I'm doing some research into Delphix in order to see if it can be a viable solution for my team's problem with synchronizing our data between multiple databases in different environments.

Our problem statement is as follows:

We have an application that is hosted in multiple nonprod environments and then one production environment. We would like to utilize Delphix so that our production database propagates down to our lower environment databases so that we have consistent data.  

However, we want to make sure that if new records are created in the lower environment tables, those records are not overwritten by the production table when the databases are synched up.

Reading the documentation, it's unclear to me what the behavior of the Database synchronization is in this case. 

Any help on this matter is greatly appreciated.

------------------------------
Zachary Hirschman
Delphix Community Members
------------------------------

Hi Zachary,
I've reached out to @Rebecca Karch and she will be in touch with you. If you get an answer you can share back here on the community, I'm sure it would be greatly appreciated by others with the same question(s).
Thank you and please let me know if I can help get you in touch with our team or if there is something else I can do.

Michael​​

------------------------------
Michael Torok
Community Mgmt & Experience, Sr. Director
DelphixMichael Torok
Community Mgmt & Experience, Sr. Director
Delphix
------------------------------

Original Message:
Sent: 03-09-2022 12:52:55 PM
From: Zachary Hirschman
Subject: Merging without overwriting new data in lower environment databases

Hello all,

I'm doing some research into Delphix in order to see if it can be a viable solution for my team's problem with synchronizing our data between multiple databases in different environments.

Our problem statement is as follows:

We have an application that is hosted in multiple nonprod environments and then one production environment. We would like to utilize Delphix so that our production database propagates down to our lower environment databases so that we have consistent data.

However, we want to make sure that if new records are created in the lower environment tables, those records are not overwritten by the production table when the databases are synched up.

Reading the documentation, it's unclear to me what the behavior of the Database synchronization is in this case.

Any help on this matter is greatly appreciated.

------------------------------
Zachary Hirschman
Delphix Community Members
------------------------------

Zachary, 
That's an interesting scenario, I'm very interested to hear more. 
What version of Delphix are you on, are your working w/relational DBs, on what platform?  Lastly, is there any Masking of the data? 
Please keep us posted, and best of luck with your challenge.
Cheers, Michelle

------------------------------
[Shelby] [Conway]
[Data Analyst | Delphix Admin]
[mconway@amerihealthcaritas.com]
[ACFC][United States]
------------------------------

Original Message:
Sent: 03-09-2022 12:52:55 PM
From: Zachary Hirschman
Subject: Merging without overwriting new data in lower environment databases

Hello all,

I'm doing some research into Delphix in order to see if it can be a viable solution for my team's problem with synchronizing our data between multiple databases in different environments.

Our problem statement is as follows:

We have an application that is hosted in multiple nonprod environments and then one production environment. We would like to utilize Delphix so that our production database propagates down to our lower environment databases so that we have consistent data.

However, we want to make sure that if new records are created in the lower environment tables, those records are not overwritten by the production table when the databases are synched up.

Reading the documentation, it's unclear to me what the behavior of the Database synchronization is in this case.

Any help on this matter is greatly appreciated.

------------------------------
Zachary Hirschman
Delphix Community Members
------------------------------

Since Delphix is keeping track of changes at the data block level on disk, I doubt this would be possible.  You could create a clone of production and then programmatically compare/merge changes.  You can also use a product like Oracle Goldengate, HVR, IBM Datastage, etc, to capture (extract) and propagate (replicate to non-prod) changes.

------------------------------
Lisa Garczynski
Database Engineer III
Paychex, Inc.
------------------------------

Original Message:
Sent: 03-09-2022 12:52:55 PM
From: Zachary Hirschman
Subject: Merging without overwriting new data in lower environment databases

Hello all,

I'm doing some research into Delphix in order to see if it can be a viable solution for my team's problem with synchronizing our data between multiple databases in different environments.

Our problem statement is as follows:

We have an application that is hosted in multiple nonprod environments and then one production environment. We would like to utilize Delphix so that our production database propagates down to our lower environment databases so that we have consistent data.

However, we want to make sure that if new records are created in the lower environment tables, those records are not overwritten by the production table when the databases are synched up.

Reading the documentation, it's unclear to me what the behavior of the Database synchronization is in this case.

Any help on this matter is greatly appreciated.

------------------------------
Zachary Hirschman
Delphix Community Members
------------------------------

Based on some of the research I've done it sounds to me like the way to accomplish this is by doing what @Lisa Garczynski mentioned and that's using Pre and Post refresh hooks to capture the beginning state of the nonprod databases and then programmatically compare/merge changes after the refresh. Will update here if another solution comes up, thanks for all the responses!​

------------------------------
Zachary Hirschman
Delphix Community Members
------------------------------

Original Message:
Sent: 03-11-2022 12:10:31 PM
From: Lisa Garczynski
Subject: Merging without overwriting new data in lower environment databases

Since Delphix is keeping track of changes at the data block level on disk, I doubt this would be possible.  You could create a clone of production and then programmatically compare/merge changes.  You can also use a product like Oracle Goldengate, HVR, IBM Datastage, etc, to capture (extract) and propagate (replicate to non-prod) changes.

------------------------------
Lisa Garczynski
Database Engineer III
Paychex, Inc.

Original Message:
Sent: 03-09-2022 12:52:55 PM
From: Zachary Hirschman
Subject: Merging without overwriting new data in lower environment databases

Hello all,

I'm doing some research into Delphix in order to see if it can be a viable solution for my team's problem with synchronizing our data between multiple databases in different environments.

Our problem statement is as follows:

We have an application that is hosted in multiple nonprod environments and then one production environment. We would like to utilize Delphix so that our production database propagates down to our lower environment databases so that we have consistent data.

However, we want to make sure that if new records are created in the lower environment tables, those records are not overwritten by the production table when the databases are synched up.

Reading the documentation, it's unclear to me what the behavior of the Database synchronization is in this case.

Any help on this matter is greatly appreciated.

------------------------------
Zachary Hirschman
Delphix Community Members
------------------------------