4.4 Data integrations with finance and operations apps Flashcards
What do integrations support?
Document formats
Source mapping
Filters
Data management workspace?
Allows users to set up recurring data jobs within a project for f&o apps
What does data management framework package API use to authorize access?
OAuth 2.0
To use the API what needs to be done?
Connect with a valid OAuth access token
The availability of data entity is dependent on?
Configuration key
What artifacts is configuration key assigned to?
Data entity
Table that’s used in the entity
Data fields
Data entity fields
How to speed up the import of the data?
By enabling parallel processing of importing a file
Job history clean-up?
To schedule a periodic cleanup of the run history
Mapping details functionalities?
Ignore blank values
Text qualifier
Use enum label
Auto-generated
Auto default
Conversion
How to create data transformation logic?
By writing either Computed column or virtual fields in x++ code
Computed column?
Value is generated by SQL view
During read, data is computed by SQL and is fetched directly from the view
For writes, custom code must parse the input value
and write the parsed values to the regular fields of the data entity
Mostly used for reads
Virtual fields?
Non-persisted
Read and write happens through custom x++ code
Used for intake values that are calculated by using X++ code
Why use Microsoft DataVerse?
Enable the flow of data between finance and operations apps and D365 Sales, and D365 Custom Service
Composite entity?
Build a single entity by using multiple entities that are related to each other
Where to use composite entities?
Single document, such as a sales order header, sales order line, invoice header
