DB2 database using SSH tunnel.

Highlighted
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.

Highlighted
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

  • -----------
    Highlighted
    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?
    Highlighted
    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 GARTNER 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

    Best Practices for Using Context Variables with Talend – Part 1

    Learn how to do cool things with Context Variables

    Blog

    Migrate Data from one Database to another with one Job using the Dynamic Schema

    Find out how to migrate from one database to another using the Dynamic schema

    Blog

    Best Practices for Using Context Variables with Talend – Part 4

    Pick up some tips and tricks with Context Variables

    Blog