Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

Hello,

i need to connect to sql server database that have in instance, does i need to add the name of instance with the Host ( exemple "localhost\myinstance" ) or in JDBC URL Params (exemple "InstanceName=myinstance") ?

Hi Sami, you should connect via an <https://docs.airbyte.com/integrations/sources/mysql#connection-via-ssh-tunnel|SSH Tunnel>, have you set that up?

image.png

Hi Nataly

why i need SSH Tunnel ? i try to ping the sql server database from airbyte instance and I can reach, this mean i can connecte to the hostname.
so if i use SSH tunnel i need to add the name of the instance with the host name ?

image (3).png

Hi <@U03J7N20YAF>

i can reach the hostname with Airbyte instance, but i can't reach the instnace , what do i need to do or add in the source configuration to say i want to connect to this specific instance that contain this database ?

rId17.png

i will do the same thing i just need to know where to add the "instance=SQLEXPRESS" ?? any help please

The SSH Tunnel Server Host can be an IP address, as per the docs:
`SSH Tunnel Jump Server Host` refers to the intermediate (bastion) server that Airbyte will connect to. This should be a hostname or an IP Address.

Hi <@U03J7N20YAF> ,

Why we need bastion for connect to the instance SQL? I don't unterstand.
We have setup a VPN between airbyte and SQL Server, communication is OK. We can connect to the master instance but not to the secondary instance whith the parameters.
Instance we want is named X3V7, how can we reach her from airbyte?