Using the CData ODBC Driver for Autify in PyCharm

Ready to get started?

Download for a free trial:

Download Now

Learn more:

Autify ODBC Driver

The Autify ODBC Driver is a powerful tool that allows you to connect with live Autify data, directly from any applications that support ODBC connectivity.

Access Autify testing senarios and results from virtually anywhere through a standard ODBC Driver interface.



Connect to Autify as an ODBC data source in PyCharm using the CData ODBC Driver for Autify.

The CData ODBC Drivers can be used in any environment that supports loading an ODBC Driver. In this tutorial we will explore using the CData ODBC Driver for Autify from within PyCharm. Included are steps for adding the CData ODBC Driver as a data source, as well as basic PyCharm code to query the data source and display results.

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

Add Pyodbc to the Project

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.

Connect to Autify

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.

In order to authenticate, you must specify the Autify API Key and Project ID:

  • ApiKey: Log into your account and go to Configurations/Personal Settings and create "New personal access token".
  • ProjectId: ID of the project in your account URL. For ex: If URL is "https://app.autify.com/projects/343/scenarios", 343 is your ProjectId.

Below is the syntax for a DSN:

[CData Autify Source] Driver = CData ODBC Driver for Autify Description = My Description ProjectId = 255 ApiKey = M9e88D3s31b35347EgNVa

Execute SQL to Autify

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 Autify};ProjectId = 255;ApiKey = M9e88D3s31b35347EgNVa;') cursor = cnxn.cursor() cursor.execute("SELECT Name, ProjectURL FROM Scenarios WHERE Id = '46292'") rows = cursor.fetchall() for row in rows: print(row.Name, row.ProjectURL)

After connecting to Autify in PyCharm using the CData ODBC Driver, you will be able to build Python apps with access to Autify 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.