airbytehq / airbytehq/airbyte

Source MSSQL: MSSQL Named Instance with CDC

Offen
#25,919 2 Kommentare 0 Reaktionen 0 zugewiesene Personen Auf GitHub ansehen
area/connectors community connectors/source/mssql connectors/sources-database frozen releaseStage/alpha team/db-dw-sources type/bug
Vorherrschende Sprache
Python
Sterne
22.1k
Forks
5.3k
PR-Merge-Kennzahlen
PR-Kennzahlen ausstehend

Beschreibung

### Connector Name

mssql

### Connector Version

1.0.16

### What step the error happened?

During the sync

### Revelant information

We have a SQL Server Named Instance.
When configuring the source, we specify the following hostname:
`.internal.example.com\`
The port is typically 38000.

This works perfect for the non-cdc source. When we use CDC though, we get the following error:
```
INFO i.a.i.d.i.DebeziumRecordPublisher(lambda$start$1):74 Connector configuration is not valid. The 'database.hostname' value is invalid: ourinstance.internal.example.com\TST_Gen1 has invalid format (only the underscore, hyphen, dot and alphanumeric characters are allowed)
```

The error is correct. The problem is that debezium expects the instance name (TST_Gen1 in my example) in the `database.instance` attribute and not as part of the hostname:
https://debezium.io/documentation/reference/stable/connectors/sqlserver.html#sqlserver-property-database-instance

Thus, we should either add an `Instance Name` field to the Source configuration mask, or parse the \ from the hostname.

### Relevant log output

```shell
INFO i.a.i.d.i.DebeziumRecordPublisher(lambda$start$1):74 Connector configuration is not valid. The 'database.hostname' value is invalid: ourinstance.internal.example.com\TST_Gen1 has invalid format (only the underscore, hyphen, dot and alphanumeric characters are allowed)
```

### Contribute

- [ ] Yes, I want to contribute

Beitragsleitfaden

Beitragsleitfaden öffnen

Bewertung

Dieses Issue wurde noch nicht bewertet.

Neue Issues direkt in Ihr Postfach

Eine kurze Übersicht über anfängerfreundliche GitHub-Issues.