Tips & Tricks

Data Migration jobs may be configured for different purposes and in a great variety of combinations. FNDMIG can serve both as a Interface Tool, handling flat files in/out, as well as being a dynamic Migration Tool.
Below you will find shortcuts to the main areas that the tool covers, with examples and recommendations on how to solve specific challenges. 

How To :

  1. Load data from file, making simple updates/inserts on a single LU  >>
  2. Load data from file into a temporary table  >>
  3. Read data from (temporary) tables/views, updating multiple LUs  >>
  4. Handle error-messages and debug info  >>
  5. Use conversion lists to transform external data to IFS values  >>
  6. Read data from db-links, JOINs updating multiple LUs  >>
  7. Create a Job Chain, with extended error-handling  >>
  8. Make advanced Method List setup; calling any procedure or function  >>
  9. Make advanced Method List setup; defining conditions for method execution + tailor-made error message  >>
  10. Make advanced Method List setup; parsing variables between methods, using TechnicalObjectReference  >>
  11. Make advanced Method List setup; using dedicated LU for updating tables directly, parse ATTR-string  >>
  12. Replicate data internally between Sites/Companies  >>
  13. Write data to file, from views or specified sources, updating status on source table  >>
  14. Replicate data/send messages to Connect via Connectivity  >>
  15. Monitor job execution with History Logging and using Event Server  >>
  16. Export/import Data Migration jobs between different databases  >>
  17. Setting up Server File environment, using DIRECTORIES and EXTERNAL TABLES >>
  18. Use Data Migration Utility jobs >>