Skip to content

Connect to Microsoft SQL Server

Connecting MindsDB to your Microsoft SQL Server can be done in two ways:

Prerequisite

To connect to your Microsoft SQL Server from MindsDB, you will need to install Microsoft OLEDB Provider driver.

How to install

Install additional dependency

Also, you will need to install MSSQL as an additional requirement.

Install MSSQL

  1. On the right bottom of the screen, select dependencies.
  2. Click on Mssql INSTALL.
  3. After installation finish, restart or stop/start MindsDB studio.

Install MSSQL

MindsDB Studio

Using MindsDB Studio, you can connect to the Microsoft SQL Server with a few clicks.

Connect to database

  1. From the left navigation menu, select Database Integration.
  2. Click on the ADD DATABASE button.
  3. In the Connect to Database modal window:
    1. Select Microsoft SQL Server as the Supported Database.
    2. Add the Database name.
    3. Add the Hostname.
    4. Add Port.
    5. Add SQL Server user.
    6. Add Password for SQL Server user.
    7. Click on CONNECT.

Connect to MSSQL

Create new Datasource

  1. Click on the NEW DATASOURCE button.
  2. In the Datasource from DB integration modal window:
    1. Add Datasource Name.
    2. Add Database name.
    3. Add SELECT Query (e.g. SELECT * FROM my_database)
    4. Click on CREATE.

Create MSSQL Datasource

That's it 🎉 🏆 💻

You have successfully connected to Microsoft SQL Server from MindsDB Studio. The next step is to train the Machine Learning model.

MSSQL client

How to extend MindsDB configuration

Our suggestion is to always use MindsDB Studio to connect MindsDB to your database. If you still want to extend the configuration without using MindsDB Studio follow the configuration example.

After adding the required configuration to the config.json file, you will need to start MindsDB and provide the path to the newly created config.json:

python3 -m mindsdb --api=http,mysql --config=config.json

The --api parameter specifies the type of API to use -- in this case HTTP and MySQL. The --config parameter specifies the location of the configuration file.

Start MindsDB with config

After starting the server, you can run a SELECT query from your SQL client to make sure integration has been successful. Please make sure to use exec or openquery as the examples bellow.

exec ('SELECT * FROM mindsdb.predictors') AT mindsdb_db;
Or, openquery: 
select * from openquery(mindsdb, 'select * from mindsdb.predictors');

Note: mindsdb is the name of the api['mysql]['database'] key from config.json. The default name is mindsdb.

SELECT from MindsDB predictors table

That's it 🎉 🏆 💻

You have successfully connected MindsDB Server and Microsoft SQL Server. The next step is to train the Machine Learning model.

Comments