Please kindly reply , is there any possibilities to use the MySQL as target ? And then if this thing is possible , please suggest me a way @pat_nadolny

I dont see a mysql target on MeltanoHub right now but its possible that theres one thats just not listed.@visch did I remember you using an mysql target?

I wrote an mssql target that only does full table inserts. https://gitlab.com/autoidm/autoidm-target-mssql @keith_siilats forked it for mysql here https://github.com/siilats/siilats-target-mysql He said it was worked so you could give it a shot

Also the Meltano SDK has a new feature to use SQLAlchemy and connect to any supported DB. I'm not sure if this translates to targets yet https://github.com/MeltanoLabs/tap-sqlalchemy. @aaronsteers do you know more about this?

@visch is there any step by step instruction to get the target-mysql as loader

no

okay @visch thank you

Answer is really yes as the readme has step by step instructions

@rajkumar_b - To confirm, are you looking for a MSSQL target or and MSSQL tap, or both?

@aaronsteers i need MYSQL

Oh, got it. My mistake. Thanks.

MySQL is a pretty popular RDBMS for Transactional systems. A lot of companies tend to specialise in 1 RDBMS technology too. So it's not unusual to have a MySQL as source and MySQL as target, like in our situation, where our ODS is also using MySQL as technology, and for the time being our DataWarehouse will as well. Similarly, Oracle to Oracle or MSSQL to MSSQL, etc... Having said that, MySQL is not blessed with much in the shape of UPSERTS/MERGE functionality, so that's maybe where the limitation truly lies. So one for customisation/bespoking i suppose, building on top of what @keith_siilats has done.