search

airbytehq / airbyte

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
https://airbyte.com
Other
15.39k stars 3.97k forks source link

Source IBM Db2: add SSH tunnel connectivity #16837

Open philippeboyd opened 1 year ago

philippeboyd commented 1 year ago

Tell us about the problem you're trying to solve

Unable to connect to a DB2 instance behind a private network.

Describe the solution you’d like

Same as MSSQL or MySQL, add the option to connect to a DB2 instance using an SSH tunnel

philippeboyd commented 1 year ago

I've seen the following in the the Docs:

Note. Unfortunately SSL and SSH are incompatible because SSH changes the visible name of the target.

Not sure I fully understand that note, isn't it an SSH port forwarding after all? Why would SSH change the visible name of the target?

marcosmarxm commented 1 year ago

@andriikorotkov could you help here?

andriikorotkov commented 1 year ago

@philippeboyd Yes, that is a false note. It's good that you noticed it. I removed it so as not to mislead users. Thank you.

philippeboyd commented 1 year ago

@marcosmarxm @andriikorotkov any news on this feature? Do you guys know if it's being worked internally at Airbyte?

philippeboyd commented 1 year ago

As Thanos once said:

Fine I'll do it myself.

I'm currently implementing and testing the SSH tunnelling option for DB2, which will also close airbytehq/airbyte-internal-issues#1080