MSSQL table import

Insights
1

Hi, it is possible to get the data from a Microsoft SQL database directly on Insights?

I didn’t find any plugin or MSSQL engine for Frappe. I just want to import table and row on the ErpNext MySQL database to use it in Insights

Thank you

2

There’s no direct integration with the MSSQL database. You can export and import the table data into MySQL or another supported database and connect that to Insights. Or simply export and import as csv if the real-time connection is not very important.