Delphix Products

Expand all | Collapse all

How do we import data from Delphix to Hadoop Environment?

Jump to Best Answer
  • 1.  How do we import data from Delphix to Hadoop Environment?

    Posted 06-07-2016 07:05:00 AM
    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


  • 2.  RE: How do we import data from Delphix to Hadoop Environment?

    Posted 06-07-2016 07:22:00 AM
    This reply was created from a merged topic originally titled How to import data from delphix to Hadoop?. how to import data from Delphix to Hadoop Environment? Whether Delphic stores the data in database / table formatted and we will get the Jdbc string and required parameters to connect using Sqoop? or its stores as flat file (if its flat file what type of file) formatted to extract the data to HDFS. Please confirm. If


  • 3.  RE: How do we import data from Delphix to Hadoop Environment?
    Best Answer

    Posted 06-07-2016 07:22:00 AM
    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.  




  • 4.  RE: How do we import data from Delphix to Hadoop Environment?

    Posted 06-07-2016 07:43:00 AM
    Hi Adam, I need little more clarity on your response. May be I am pretty much new to Delphix. Let me reframe my question. I understand from my client like Data is already moved from Legacy system to Delphix. Now my question is being a Hadoop person, I need to import data from Delphix to Hadoop Environment... I would like to know how to import this from Delphix.... Just incase if its any RDBMS using JDBC string I can connect and extract. But please let me know how to extract the data from Delphix to Hadoop....


  • 5.  RE: How do we import data from Delphix to Hadoop Environment?
    Best Answer

    Posted 06-07-2016 09:20:00 AM
    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.



  • 6.  RE: How do we import data from Delphix to Hadoop Environment?

    Posted 06-07-2016 09:43:00 AM
    Thanks Adam it helps..