There are several ways you can use Python to connect to SQL Server and one of such ways is to use pyodbc and sqlalchemy

import sqlalchemy
import pyodbc

try:

    import urllib
    params = urllib.quote_plus("DRIVER={SQL Server Native Client 11.0};SERVER=.\MSSQLSERVER_ENT;DATABASE=MagicDirect;Trusted_Connection=yes;")

    engine = sqlalchemy.create_engine('mssql+pyodbc:///?odbc_connect=%s"' % params)

    results.to_sql("clusterSegments", engine, if_exists = 'replace')#

    
except (RuntimeError, TypeError, NameError):
    print('Error in Conneccting')
    print(RuntimeError, TypeError, NameError)
finally:
    print("connected")

People Who Read The Above Post Also Read This:

Pyodbc Sqlalchemy Python 2 and 3 SQL Server Native Client 11.0 Get Numbers and Percentages from Tables – Microsoft Sql Server Superset Heroku Installation – Microsoft SQL Server Database Connection on Windows PC Splitting Values in one Column to Multiple Columns using CASE Expression Statement SQL Server