Join the 1500 companies using G2 Track to manage SaaS spend, usage, contracts & compliance.

pyodbc

3.8
(3)

pyodbc is an open source Python module that makes accessing ODBC databases simple. It implements the DB API 2.0 specification but is packed with even more Pythonic convenience.

Work for pyodbc?

Learning about pyodbc?

We can help you find the solution that fits you best.

pyodbc Reviews

Chat with a G2 Advisor
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 3 pyodbc reviews
LinkedIn Connections
pyodbc review by Dan L.
Dan L.
Validated Reviewer
Review Source
content

"Must have Open Source Python Library"

What do you like best?

Pyodbc is a simple lightweight library for accessing databases via an ODBC connection (Open Database Connectivity). It is easy to install and easy to use. It allows you to execute selects, inserts, or other driver supported ODBC operations.

What do you dislike?

Not much to complain about. It's meant to be lightweight and serve a simple purpose.

Recommendations to others considering the product

For more features, consider eventually upgrading to a full ORM, such as SQLalchemy.

What business problems are you solving with the product? What benefits have you realized?

We wrote a simple scheduler to run stored procedures in our database based on business events. Quick, easy to use, and something we know will "future proof" as pyodbc will be supported for a long time.

Sign in to G2 to see what your connections have to say about pyodbc
pyodbc review by Consultant
Consultant
Validated Reviewer
Verified Current User
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Good library to manage persistence on db "

What do you like best?

This library is very simple and useful to connect with database ODBC, like Access, sql server. The library is completed by a good documentation and the examples on internet

What do you dislike?

I dont found any problem using this library, so I have not any negative comments

What business problems are you solving with the product? What benefits have you realized?

the main problem is connect with a sql server micrsosoft database, and thanks this library i solved it

What Python Package solution do you use?

Thanks for letting us know!
pyodbc review by User in Financial Services
User in Financial Services
Validated Reviewer
Review Source
content

"Good driver! "

What do you like best?

It connects Python client to SQL Server and runs off your OS' default ODBC driver and is fairly easy to set up. Most importantly, it is free!

What do you dislike?

There is not a whole lot of documentation, support online.

Recommendations to others considering the product

A good free offering! If you are looking for more advanced use-cases (higher thruput etc.), I'd recommend using Data Direct Drivers with PyODBC.

What business problems are you solving with the product? What benefits have you realized?

I was trying to connect my Python client to MSSQL database on UNIX Operating System for reporting.

There are not enough reviews of pyodbc for G2 to provide buying insight. Below are some alternatives with more reviews:

1
spyder download Logo
spyder download
4.5
(28)
Spyder is a powerful scientific environment written in Python, for Python, and designed by and for scientists, engineers and data analysts. It offers a unique combination of the advanced editing, analysis, debugging, and profiling functionality of a compr
2
python sql Logo
python sql
4.0
(26)
python-sql is a library to write SQL queries in a pythonic way.
3
pandas python Logo
pandas python
4.5
(21)
pandas is an open source, BSD-licensed library providing high-performance, easy-to-use data structures and data analysis tools for the Python programming language.
4
beautifulsoup4 Logo
beautifulsoup4
4.4
(21)
Beautiful Soup is a Python library designed for quick turnaround projects like screen-scraping.
5
python xlrd Logo
python xlrd
4.1
(19)
xlrd is a library for reading data and formatting information from Excel files, whether they are .xls or .xlsx files.
6
numpy download Logo
numpy download
4.6
(18)
NumPy is the fundamental package for scientific computing with Python.
7
xfinity usage meter Logo
xfinity usage meter
4.1
(17)
Python/selenium script to get Xfinity bandwidth usage from Xfinity MyAccount website. Has an easily-usable command line entrypoint as well as a usable Python API, and an entrypoint to send usage to Graphite.
8
python pillow Logo
python pillow
4.3
(16)
Pillow is the friendly PIL fork by Alex Clark and Contributors. PIL is the Python Imaging Library by Fredrik Lundh and Contributors.
9
mysql python Logo
mysql python
4.1
(14)
MySQLdb is an interface to the popular MySQL database server for Python.
10
Selenium WebDriver Logo
Selenium WebDriver
4.2
(13)
Selenium is an umbrella project encapsulating a variety of tools and libraries enabling web browser automation. Selenium specifically provides infrastructure for the W3C WebDriver specification - a platform an
Show more
Kate from G2

Learning about pyodbc?

I can help.
* We monitor all pyodbc reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.