Export data from MSSQL to Drupal 7?

Question

Drupal

The guys may be aware of how data from the MSSQL database can be parsed into the Drupal database, for example, into nodes.
There is a MSSQL database in it there are categories and products. It also contains information about bonus cards and their holders and the size of the discount.
How can I tie Drupal with MSSQL in order to:
1. Extract categories and products from the database and transfer them to Drupal
2. How to extract information on maps and generate users with all the resulting information on them.
Are there any modules that are ready, maybe they are on the site, but I couldn’t even find them.
Interested in how you can tie all this competently and with what.

Answer 1

The Migrate module will help you: https://www.drupal.org/project/migrate
https://www.drupal.org/node/1152162
You can write a migration class for your structure

Answer 2

I doubt the usefulness of the modules. The module is valuable in cases where it is necessary to import from one well-known structure into another, for example, from Joomla to Drupal. You have some kind of arbitrary structure in MSSQL, it’s better to read the Drupal API and write it yourself personally for your needs.