Welcome to my Micromine tutorial. Today, we are going to import some data from the SQL Server into Micromine. Micromine supports many data sources including SQL Server, MySQL and some others. The best way to do this is by using the Import ODBC feature in Micromine. Let’s get started.
At this point, I assume you have a working SQL Server on your PC or on the network. If you don’t have it, I would recommend to build an SQL Server Docker Container. It is very easy and free. Next, create a new ODBC connection. Make sure you select the SQL Server when creating the ODBC Connection.
Now let’s jump to the Micromine. From the Micromine main window, go to File | Import | ODBC. Click Select Data Sources and then select the ODBC connection you created earlier. Now you should see the tables in your SQL server as follow.
Select the table you want to export and click OK.
Type the file name on the target and the file type. Select how Micromine will handle the table structure. You can either import all fields or simply select several fields. Click Import.
In a moment, the SQL Server table will be imported to Micromine. Thanks for reading, please leave me comments if you have any queries.