This is the implementation of the Microsoft SQL Server data handler for MindsDB.
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it stores and retrieves data as requested by other software applications, which may run either on the same computer or on another computer across a network.
Before proceeding, ensure the following prerequisites are met:
This handler is implemented using pymssql
, the Python language extension module that provides access to Microsoft SQL Server from Python scripts.
The required arguments to establish a connection are as follows:
host
is the host name or IP address.port
is the port used to make TCP/IP connection.database
is the database name.user
is the database user.password
is the database password.In order to make use of this handler and connect to the SQL Server database in MindsDB, the following syntax can be used:
You can use this established connection to query your table as follows: