M5 - Prepare data for migration to f&o apps Flashcards
What are two things that should be controlled when migrating data?
- Operational complexity
- Reduce costs
What are three factors that should be identified when preparing for a data migration?
- Legacy systems
- Static data
- Common data
What are the integration patterns available for f&o apps?
- OData
- Batch data API
- Custom service
- Consume external web services
- Excel integration
What isOData?
A standard protocol for creating and consuming data.
What is the purpose of OData?
To provide a protocol based on REST for CRUD operations.
What technologies does OData apply to provide access to information from various programs?
Web technologies such as HTTP and JSON.
Benefits of OData
- Allows developer to interact with data by using RESTful web services.
- Provides a simple and uniform way to share data in a discoverable manner.
- Enables broad integration across products
- Enables integration by using the HTTP protocolo stack
In what scenarios would you use the batch data API?
When one or both Data management package REST API and Recurring Integrations are required.
What scenarios do Data management package REST API and Recurring integrations support?
Data import/export
How does the package API lets you integrate with f&o apps?
Using data packages.
What is Recurring Integration?
Enables the exchange of documents or files between f&o apps and any third-party service
Benefits of using Recurring Integration
- Builds on data entities and the Data management framework
- Supports several document formats, source-mapping and filters
- Uses secure REST APIs and authorization mechanisms to receive data from, and send data back to, integration systems.
When a developer writes a custom service under a service group, the service group is always deployed on two endpoints:
- SOAP
- JSON
Processing can be either:
Synchronous or asynchronous
What integration pattern is recommended for SYNCHRONOUS integration scenarios?
OData
What type of integration pattern is recommended for ASYNCHRONOUS integration scenarios?
Batch data API
Interacts with Excel workbooks and OData services that are created for publicly exposed data entities
The Excel Data Connector App
What is the BYOD feature?
Lets administrators configure their own database, and then export one or more data entities, that are available in f&o apps, into it.
What is a full push?
Export all records
What is an incremental push?
Export only the records that have changed or been deleted.
When is the BYOD feature recommended?
When you do the following:
- Export data from f&o apps into your own data warehouse
- Use analytical tools other than Power BI, that need T-SQL access to data.
- Perform batch integration with other systems.
What do you need to do before you can configure the export option and use the BYOD feature?
Create an SQL database for production environments using Azure Portal
When should you consider to create a SQL premium database?
If you are using the BYOD feature for integration with a BI tool.
What is a SQL premium database?
A SQL database that supports clustered columnstore indexes (CCIs).
What is a CCI?
In-memory indexes that improve the performance of read queries that are typical in analytical and reporting workloads.
How can you ensure that reporting systems get consistent data from BYOD while a sync from Finance and Operations apps is still in progress?
To ensure consistent data, avoid having reporting systems read directly from the staging tables created during the BYOD process, since those tables are being updated during sync. Instead, use a SQL trigger to detect when the data sync is complete, and only then update or hydrate the reporting systems with the final, stable data.
What is the Create clustered column store index option for?
Optimizes the destination database for selected queries by defining CCIs for entities that are copied from finance and operations.
What is the enable triggers in target database?
Sets export jobs to enable SQL triggers in the target database, and lets you hook downstream processes into the trigger to orchestrate actions that must be started after records have been inserted.
What are the steps for a data migration?
- Identify systems
- Identify and import static data
- Create and review test plans
- Identify and extract source data
- Identify data entities and elements
- Generate field mapping
- Support transition
Which option enables broad integration between finance and operations apps and other products, systems, and applications?
OData
Which option enables the exchange of documents or files between finance and operations apps and any external application or service?
Batch data API
he Excel Data Connector app interacts with Microsoft Excel workbooks through which one of the following options?
OData
An energy company has field workers who schedule installation jobs for heaters. This company uses finance and operations apps for the back office and other software as a service (SaaS) to schedule appointments. When field workers schedule appointments, they must look up inventory availability to make sure that installation parts are available for the job. The real-time data is required. Peak data volume is 1,000 records per hour and the frequency is Ad hoc. Which one of the following integration patterns should you use?
Custom service
You need to enable an exchange of documents between finance and operations apps and an external application at the end of each day. Which of the following would you implement?
Recurring integration
