Project 702 / Project Challenges

Connection Python to SQL Server

This afternoon I went down to SQL Services and met the General Manager, two of their great developers and their DBA manager. They have agreed to provide me some desk space and advice as I work on my project, which is absolutely brilliant! I can’t see the benefit to them in this, but from my perspective it is an incredible chance to bounce ideas of professionals, get some industry-level feedback and advice, and just observe the life of a DBA team. Fantastic.

To get the most out of this experience, I will have to connect the Data Analysis classes with SQL Server. I am hoping that this will be as simple as downloading a suitable API and using this in place on the python-MySQL API. Choosing an API that is consistent with python-MySQL will be the key here. This article describes some of the available connection APIs, and it looks like pyODBC will be a good place to start.

In follow up posts I will compare the use of python-MySQL with pyODBC.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s