Ready to get started?

Learn more about the CData ODBC Driver for SQL Server or download a free trial:

Download Now

PyCharm でCData ODBC Driver for SQL Server を使ってみた

SQL Server にODBC データソースとしてPyCharm から連携。

CData ODBC Drivers は、ODBC をサポートするあらゆる環境から利用可能です。 本記事では、PyCharm からのCData ODBC Driver for SQL Server の利用を説明します。ODBC Deriver をデータソースとして設定する方法、データソースをクエリするPyCharm のベーシックな方法を含みます。

To begin, this tutorial will assume that you have already installed the CData ODBC Driver for SQL Server as well as PyCharm.

Pyodbc をプロジェクトに追加

Follow the steps below to add the pyodbc module to your project.

  1. Click File -> Settings to open the project settings window.
  2. Click Project Interpreter from the Project: YourProjectName menu.
  3. To add pyodbc, click the + button and enter pyodbc.
  4. Click Install Package to install pyodbc.

SQL Server への接続

You can now connect with an ODBC connection string or a DSN. See the Getting Started section in the CData driver documentation for a guide to creating a DSN on your OS.

Connecting to Microsoft SQL Server

Connect to Microsoft SQL Server using the following properties:

  • Server: The name of the server running SQL Server.
  • User: The username provided for authentication with SQL Server.
  • Password: The password associated with the authenticating user.
  • Database: The name of the SQL Server database.

Connecting to Azure SQL Server and Azure Data Warehouse

You can authenticate to Azure SQL Server or Azure Data Warehouse by setting the following connection properties:

  • Server: The server running Azure. You can find this by logging into the Azure portal and navigating to "SQL databases" (or "SQL data warehouses") -> "Select your database" -> "Overview" -> "Server name."
  • User: The name of the user authenticating to Azure.
  • Password: The password associated with the authenticating user.
  • Database: The name of the database, as seen in the Azure portal on the SQL databases (or SQL warehouses) page.

Below is the syntax for a DSN:

[CData SQL Source] Driver = CData ODBC Driver for SQL Server Description = My Description User = myUser Password = myPassword Database = NorthWind Server = myServer Port = 1433

SQL Server へのクエリの実行

Instantiate a Cursor and use the execute method of the Cursor class to execute any SQL statement.

import pyodbc cnxn = pyodbc.connect('DRIVER={CData ODBC Driver for SQL};User = myUser;Password = myPassword;Database = NorthWind;Server = myServer;Port = 1433;') cursor = cnxn.cursor() cursor.execute("SELECT ShipName, Freight FROM Orders WHERE ShipCountry = 'USA'") rows = cursor.fetchall() for row in rows: print(row.ShipName, row.Freight)

After connecting to SQL Server in PyCharm using the CData ODBC Driver, you will be able to build Python apps with access to SQL Server data as if it were a standard database. If you have any questions, comments, or feedback regarding this tutorial, please contact us at support@cdata.com.

 
 
ダウンロード