DB2 database using SSH tunnel.

[Anonymous]

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

[vapukov]

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

[_AnonymousUser]

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?

[vapukov]

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