Hortonworks Sandbox Forum

Connect Teradata from HDP sandbox

  • #50658

    Hi,
    I’m new to Hadoop Technology and I’m evaluating using of HDP for my project.
    In my project all the data resides on Teradata and hence I need to move the data from Teradata into HDP intially to start with.I’m testing this data move.
    I understood that using sqoop I can connect to the Databae and import data + HDP also provides Teradata connector for this.
    I’ve installed HDP sandbox (that runs on CentOS on the Oracle Virtual Box) on my laptop.
    I’ve installed a 2GB verion of Teradata on my laptop on the Host operating system -windows 7 OS.
    Now How can i connect the HDP that is running on the virtual box to my Teradata database that is running on HostOS ?
    Could you help me how to say access a table from teradata DB that is on hostOS -so that I can import it -I’m bit worried that ports needs to be mapped between my laptop and virtual box.How is that possible ?
    Any Idea on this is very much appreciated
    Thanks and Regards,
    Jerome

to create new topics or reply. | New User Registration

  • Author
    Replies
  • #50827
    iandr413
    Moderator

    Hi Jerome,
    Please have a look at this documentation -> http://hortonworks.com/wp-content/uploads/2014/03/bk_HortonworksConnectorForTeradata-1.1.1.pdf. There is port forwarding that takes place within the sandbox but you should still be able to connect. I hope this helps.

    Ian

You must be to reply to this topic. | Create Account

Support from the Experts

A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.

Enterprise Support »

Become HDP Certified

Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world

Training »

Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.