Overview
The Dynamics 365 Finance & Operations is a cloud-based Enterprise Resource Planning (ERP) system that offers you the ability to manage all your finances and inventory. The Microsoft Dynamics 365 Finance & Operations Snap Pack enables you to OData is a OASIS standard protocol for creating and consuming data. The purpose of OData is to provide a protocol that is based on Representational State Transfer (REST) for perform create, read, update, and delete (CRUD) operations. OData applies web technologies such as HTTP and JavaScript Object Notation (JSON) to provide access to information from various programs.
OData provides the following benefits:
It lets developers interact with data by using RESTful web services.
It provides a simple and uniform way to share data in a discoverable manner.
It enables broad integration across products.
It enables integration by using the HTTP protocol stack.
There are two versions of OData and we will be using the latest version of OData i.e Odata V4.
Use Snaps in this Snap Pack to:
Execute SQL statements to create, delete, update, merge or insert data within a specified table.
Fetch data from a database.
Get a list of tables from a database.
Execute stored procedures.
The The Microsoft Dynamics 365 Finance & Operations Snap Pack contains the following Snaps:
Databricks - Select: Retrieves information from the target Databricks table.
Databricks - Insert: Inserts new rows of data in the target Databricks table.
Databricks - Delete: Deletes data from a target Databricks table.
Databricks - Bulk Load: Loads WIP - Dynamics 365 F&O Read: Reads records from Microsoft Dynamics 365 Finance & Operations.
WIP - Dynamics 365 F&O Create: Adds new records for objects (entities in Microsoft terminology) based on the input document field values that match the MS Dynamics object schema field names.
WIP - Dynamics 365 F&O Update: Updates an existing record in MS Dynamics 365 Finance & Operations.
WIP - Dynamics 365 F&O Delete: Deletes objects in Microsoft Dynamics 365 Finance & Operations database.
WIP - Dynamics 365 F&O Bulk Import: Imports millions of rows of data in the target table through a single load operation.
Databricks - Unload: Unloads WIP - Dynamics 365 F&O Bulk Export: Exports data from a target Databricks table through a single unload upload operation.
Databricks - Merge Into: Updates millions of existing rows and inserts new rows in a target Databricks table through a single operation.
Databricks - Execute: Runs multiple SQL statements on the target Databricks instance.
WIP - Dynamics 365 F&O Search: Searches MS Dynamics 365 Finance & Operations for an entity set using filter conditions. You can also apply query options to set criteria for the data you want, and the entity properties that should be returned.
Prerequisites
An Azure account with a free subscription to create the application.
Register the Azure application in Dynamics 365 Finance and operations application.
OData V4
OData Client SDK (If required)
Supported Versions
< Supports API versions 2.01.2 and 4.9.32. >
< Certified against API version 3.2.13. >
Supported Applications
Snap Pack History
| Excerpt | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| |||||||||
|
Related Links
https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1439233/Glossary
https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438341/Getting+Started
|