4.5 Prepare data for migration to F&O Flashcards
Priority when migrating data?
Business continuity
Available integration patterns for F&O
OData
Batch data API
Custom service
Consume external web services
Excel integration
Benefits of OData?
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
Batch data API?
Use in scenarios that require one or both Data management package REST API and Recurring integrations
What does Batch data API do?
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
Custom service and endpoints?
A custom service can be written for F&O
SOAP endpoints
JSON endpoints
Consume external web services?
Consume web services by adding new class libraries to F&O apps
Excel integrations?
Provide users with a productive environment that helps them get the job done
Synchronous integration?
OData
Asynchronous integration?
Batch data API
F&O data migration tools?
Data management workspace
Office integration
Excel workbook designer
BYOD?
Lets admins configure their own database, and export one or more data entities
What tasks does BYOD allow you to do?
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
When to use BYOD?
Export data from F&O apps into your own data warehouse
Use analytical tools other than power BI
Perform batch integration
Steps for preparing for data migration?
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
Identify relevant legacy systems?
It is a business solution that has a few common characteristics with current solutions in the market
Identify and import static data that is common between industries?
Identify common data that are not frequently changed, such as country codes, zip or postal codes, states, or regions
Create and review test plans for data migration?
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
Identify and extract source data?
When data is analyzed and relevant information is retrieved it is time to extract the data.
Identify relevant data entities and elements?
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.
Generate field mapping between source and target data structures?
Identify the format of data source
