Data Migration - Using delphix for a ETL project

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Hi community,
A customer that has to start a migration project uses delphix to mantain his environments.
now, starting to understand the tool to use, I would to know (I never have seen delphix how works) if it's possible to use delphix for the extraction part. 
basically the idea is to create in a staging area the virtual copy of the production database and after another tool will read and trasform that data into the new data model.
my doubt is about the performance. 
how works the virtual DB ? is it possible to create index (or are inherited from source DB) ?
thanks for the answer, and sorry for mi ignorance, but I just discovered the existence of delphix and really fascinate me!!!
Photo of silvio


  • 80 Points 75 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 21,126 Points 20k badge 2x thumb
Official Response
Silvio, great question. Very much as Mouhssine said, A virtual database is functionally identical to a physical database. We don't do the ETL, but you can use any of your existing processes to perform the ETL. You can index the database, etc, just like you would a non-virtualized copy.