Skip to main content

​
Prerequisites

Before you can configure and use Python with Embedded Cloud, you must first connect a data source to your Connect AI account. See Sources for more information.

​
Install the Driver

Follow these steps to download and install the driver:
1
Download and extract the setup archive for your operating system.
2
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 Embedded Cloud

Follow these steps for an example of how to connect to Embedded Cloud 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=OAuth;")
2
If you are not already logged into Connect AI, the OAuth login page opens in your default web browser. Log in to continue.
3
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 Connect AI, click here.