Python

Version 22.0.8486


Python


This page outlines the steps to use the Python Driver for CData Connect.

Prerequisites

Before you can configure and use Python with CData Connect, you must first connect a data source to your CData Connect account. See Data Model for more information.

Install the Driver

Follow these steps to download and install the driver:

  1. Open the Clients page of CData Connect.

  2. In the Dev Tools section, locate Python and click Download.

  3. Download and extract the setup archive for your operating system.

Follow the steps below for your operating system.

Windows Installation

  1. In the extracted archive, open the win folder.

  2. Choose the folder for your Python version, and then the folder for your bitness. For example, if you have Python 3.9 and a 64-bit operating system, open the win > Python39 > 64 folder.

  3. Open a command prompt and run pip install for the .whl setup file. For example, a 64-bit Python 3.9 install would be pip install cdata_connect_connector-21.0.8049-cp39-cp39-win_amd64.whl.

Mac and Unix Installation

  1. In the extracted archive, open the mac or unix folder.

  2. Open a Python terminal and run pip install for the appropriate .tar.gz setup file. For example, a Python 3.9 install would be pip install cdata-connect-connector-21.0.8049-python39.tar.gz.

Connect to CData Connect

Follow these steps for an example of how to connect to CData Connect from your Python code:

  1. Import cdata.connect, create a connection object, and and pass the connection string as an argument, as in the example below:
     import cdata.connect as mod
     conn = mod.connect("AuthScheme=AuthToken;URL=http://hostname:port/rest.rsc;User=my_user;AuthToken=my_token;")
    
  2. You can execute SQL statements using this connection. For example, the commands below print all entries for Id in a MailChimp connection:
     cur = conn.execute("SELECT Id FROM MailChimp1.MailChimp.AuthorizedApps")
     rs = cur.fetchall()
     for row in rs:
         print(row)
    

Learn More

To learn more information about using Python for CData Connect, click here.