wintersrd / pipelinewise-tap-mssql

Pipelinewise tap for Microsoft SQL Server
GNU Affero General Public License v3.0
14 stars 48 forks source link

Linked Server #13

Closed visch closed 2 years ago

visch commented 3 years ago

Trying to connect via a Linked Server. Having some issues, trying to define the database as "Linkedservername.Database" https://docs.microsoft.com/en-us/sql/t-sql/language-elements/transact-sql-syntax-conventions-transact-sql?view=sql-server-ver15#multipart-names

Anyone done this before with this tap?

visch commented 2 years ago

Ended up using DBT and 3 part names select * from "Server"."DB"."Table" instead of using a tap like this. We could probably make it work but not a big requirement for me.