DB2 database using SSH tunnel.

One Star

DB2 database using SSH tunnel.

Hi All,
I have a scenario to connect DB2 LUW using ssh tunnel . Please help me by providing steps to implement the same.

Forteen Stars

Re: DB2 database using SSH tunnel.

2 variants
[list=*]
  • check on exchange ssh tunnel  component and add it to Job

  • create túnel outside You Job - hundreds programs for this available. tell with Your system admins if have them

  • -----------
    One Star

    Re: DB2 database using SSH tunnel.

    vapukov wrote:
    2 variants
    [list=*]
  • check on exchange ssh tunnel  component and add it to Job

  • create túnel outside You Job - hundreds programs for this available. tell with Your system admins if have them


  • Hi,
    For first variant :
    There is no proper documentation to follow the steps. 

    I need to extract data from DB2 which sat beside firewall system (AWS) . 

    1)How to Crete metadata connection?

    Second variant:

    Can you please suggest best method to implement out side?
    Forteen Stars

    Re: DB2 database using SSH tunnel.

    [list=*]
  • first variant


  • really self documented, so it must not be a problem
    metadata connection - You can create with this method, but not test and not retrieve structure, 
    because tunnel will be created in feature (on run stage) but connection You create before tunnel 


    [list=*]
  • second variant - best choice, talk with Your system (network) admin, for them it regular tasks and depending from Your environment it could be different. 



  • I use on Mac - SSH Tunnel (name of program)
    on Linux it could be - http://www.revsys.com/writings/quicktips/ssh-tunnel.html
    On Windows - https://www.bitvise.com/port-forwarding
    this is just examples, in which direction search.
    -----------

    2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

    Talend named a Leader.

    Get your copy

    OPEN STUDIO FOR DATA INTEGRATION

    Kickstart your first data integration and ETL projects.

    Download now

    What’s New for Talend Summer ’19

    Watch the recorded webinar!

    Watch Now

    Best Practices for Using Context Variables with Talend – Part 4

    Pick up some tips and tricks with Context Variables

    Blog

    How Media Organizations Achieved Success with Data Integration

    Learn how media organizations have achieved success with Data Integration

    Read

    APIs for Dummies

    View this on-demand webinar about APIs....

    Watch Now