4.5 Prepare data for migration to F&O

Question 1

Priority when migrating data?

Answer 1

Business continuity

Question 2

Available integration patterns for F&O

Answer 2

OData
Batch data API
Custom service
Consume external web services
Excel integration

Question 3

Benefits of OData?

Answer 3

Allows to interact with data by using RESTful services
Simple and uniform way to share data
Enabling broad integration across products
Enabling integration by using HTTP protocol stack

Question 4

Batch data API?

Answer 4

Use in scenarios that require one or both Data management package REST API and Recurring integrations

Question 5

What does Batch data API do?

Answer 5

Builds on data entities on the data management framework
Enables exchange of documents or files between F&O and 3rd party
Supports different formats, source-mapping, and filters
Uses REST API and auth mechanisms to receive data from, and send data back to, integrations systems

Question 6

Custom service and endpoints?

Answer 6

A custom service can be written for F&O
SOAP endpoints
JSON endpoints

Question 7

Consume external web services?

Answer 7

Consume web services by adding new class libraries to F&O apps

Question 8

Excel integrations?

Answer 8

Provide users with a productive environment that helps them get the job done

Question 9

Synchronous integration?

Answer 9

OData

Question 10

Asynchronous integration?

Answer 10

Batch data API

Question 11

F&O data migration tools?

Answer 11

Data management workspace
Office integration
Excel workbook designer

Question 12

BYOD?

Answer 12

Lets admins configure their own database, and export one or more data entities

Question 13

What tasks does BYOD allow you to do?

Answer 13

Define one or more MS Azure SQL db that you can export data entity from F&O apps into
Exports either all or some records
Use rich scheduling capabilities
Access to entity db using T-SQL
Export entities into multiple DB

Question 14

When to use BYOD?

Answer 14

Export data from F&O apps into your own data warehouse
Use analytical tools other than power BI
Perform batch integration

Question 15

Steps for preparing for data migration?

Answer 15

Identify Systems
Identify and support static data
Create and review test plans
Identify and extract source data
Identify data entities and elements
Generate field mapping
Support transition

Question 16

Identify relevant legacy systems?

Answer 16

It is a business solution that has a few common characteristics with current solutions in the market

Question 17

Identify and import static data that is common between industries?

Answer 17

Identify common data that are not frequently changed, such as country codes, zip or postal codes, states, or regions

Question 18

Create and review test plans for data migration?

Answer 18

Make sure that the right system permissions are applied on resources
backup database and source files
Extract all data from the source system, and then migrate it to the target

Question 19

Identify and extract source data?

Answer 19

When data is analyzed and relevant information is retrieved it is time to extract the data.

Question 20

Identify relevant data entities and elements?

Answer 20

Prior to starting the data migration process, identify what data you’re migrating, what format it’s currently in, where it lives, and what format it should be in post-migration. Consider whether the data migration will interfere with normal business operations or will contribute to downtime. If so, you need to plan off hours or weekends for the migration process.

Question 21

Generate field mapping between source and target data structures?

Answer 21

Identify the format of data source