How do we import data from Delphix to Hadoop Environment?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
How do we import data from Delphix to Hadoop Environment? Curious to know what format Delphix is store the data internally like whether its database of flat files or something else. My requirement is need to import the data from Delphix to hadoop. Appreciate your assistance
Photo of Arun

Arun

  • 122 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
Official Response
Hey Arun, the short answer is you spin up VDB's of the data you want to put into Hadoop and then use the same tools you would use for those physical data sources. For example, if you have an Oracle DB you want to get into Hadoop, you would create an Oracle VDB and then use something like Hadoop Loader to load the data into Hadoop. 
Delphix stores all data as filtered, compressed, deduped blocks and that data is not externally accessible to any systems. There is no way to directly pump the blocks from Delphix into Hadoop.  
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
Official Response
I will attempt to clarify: You cannot directly connect to Delphix data from Hadoop. Delphix is a data virtualization engine. Your client must first create a virtual data copy of every data source that your client wants to place into Hadoop. That virtual copy will be provisioned and accessible to an external server, for example an Oracle 11G Database server. You would then connect to the virtual data on that Oracle database via the same methods you would use to connect to any other Oracle Database. I hope this clarifies my answer.