Using the Connector
This section provides a walk-through for writing Microsoft Dynamics 365 data access code in Python script.
See Data Model for more information on the available data source entities and how to query them with SQL. See SQL Compliance for the SQL syntax.
Connecting from Code
See Package Installation and Establishing a Connection for the prerequisite information you need to deploy the connector and configure the connection to Microsoft Dynamics 365.
To connect with the dynamics365.connector module and its related classes, see Connecting.
Executing SQL
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 Modifying Data to modify the data in Microsoft Dynamics 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.
Batch Processing
See Batch Processing to modify several rows of Microsoft Dynamics 365 data at once using parameterized INSERT, UPDATE, and DELETE statements.