Any targets for mssql? Or suggestions for how to m...
# plugins-generalv
visch
03/19/2021, 2:28 PMAny targets for mssql? Or suggestions for how to make that happen?
t
taylor
03/19/2021, 2:29 PMv
visch
03/19/2021, 2:29 PMLooking for a target to mssql 😮
t
taylor
03/19/2021, 2:30 PMI can’t read 😆
v
visch
03/19/2021, 2:30 PMCustomer wants to setup a data mart with mssql
visch
03/19/2021, 2:30 PMnot sure why but that's what they want!
t
taylor
03/19/2021, 2:31 PMv
visch
03/19/2021, 2:34 PMGood find! Yeah his argument about sums it up for this client. I can probably find a hack with CSV imports or something if I try hard enough
a
aaronsteers
03/19/2021, 3:50 PM@visch, If you’ve got a little runway on this, it would be great to collaborate on the Singer SDK Target class as you are building out the target for SQL Server. Along the way, you can also get some practices for MSSQL integration from the python-based tap here: https://github.com/wintersrd/pipelinewise-tap-mssql
aaronsteers
03/19/2021, 3:52 PMAlthough this fork of the tap is not broadly used (yet), I spoke with the author and he’s been using in production for almost a year now.
v
visch
03/19/2021, 4:06 PMYeah the project hasn't started yet so there is some runway available. If you'll collaborate with me on this I'll push harder to get the client to accept using Meltano / DBT 😄
visch
03/19/2021, 4:07 PMI think I could start with a CSV import even though it's a hack
a
aaronsteers
03/19/2021, 4:09 PMYeah, we of course don’t want SDK work to be in the critical path when you need a fast turnaround but if you do decide to build a new MSSQL target, would be great to work together on that in the hopes of building out the initial target framework.