Using the ConnectorCData Python Connector for Office 365 2019 - Build 19.0.7416
This section provides a walk-through of writing data access code to Office 365 in Python script.
See Data Model for more information on the available data source entities and how to query them with SQL. See rpgoverview; for the SQL syntax.
Connecting from Code
See Wheel Installation and Establishing a Connection for the prerequisite information you need to deploy the connector and configure the connection to Office 365. Connecting shows how to connect with the office365.connector module and its related classes.
The connection's cursor object is used to directly execute SQL queries. See Querying Data to execute SELECT statements and process the returned result sets. See Updating Data to affect the data in Office 365 with INSERT, UPDATE, and DELETE statements.
Executing Stored Procedures
You can call stored procedures by using the EXECUTE statement. See Calling Stored Procedures for more information.