topic Re: DB2 database using SSH tunnel. in Talend Studio

DB2 database using SSH tunnel.

Anonymous — Wed, 08 Mar 2017 06:57:31 GMT

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

Re: DB2 database using SSH tunnel.

vapukov — Wed, 08 Mar 2017 11:26:40 GMT

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

Re: DB2 database using SSH tunnel.

_AnonymousUser — Thu, 09 Mar 2017 11:27:53 GMT

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?

Re: DB2 database using SSH tunnel.

vapukov — Thu, 09 Mar 2017 12:29:16 GMT

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