Hi! I'm quite new to Meltano and I've a project th...
# troubleshooting
w
Hi! I'm quite new to Meltano and I've a project that is extracting data from SQL Server to a Postgres database using the tap-mssql extractor. I could run it smoothly with no big problems. Now I need to extract data from a second database in the same SQL Server and I couldn't manage how to do that, since the extractor configs only allow me to define one database. I tried to insert a second tap-mssql extractor to connect with this second database, but meltano did not allow me to do that. Someone can help me out?
a
Hi, @wanderson_diego. I think the feature you are looking for is plugin inheritance: https://docs.meltano.com/concepts/plugins#plugin-inheritance Assuming example DB names of "sales" and "finance", a common practice would be to add additional plugin instances as inheriting from the base plugin, for example
tap-mssql-sales
and
tap-mssql-finance
.
m
Was going to suggest the same ^