Publish

Parent Previous Next

Overview


Clicking the Publish button creates all of the key functional deliverables of the Data Migration Process.



For example, for a project named FI_GL, a folder named FI_GL_20150109-165204 would be created with the following files:


File

File Description

FI_GL_20150109-165204.MDAWB

A backup copy of the MDA Workbench project file that was used to create the Published deliverables.

FI_GL_20150109-165204.XLSX

Field-Level Mapping Workbook

FI_GL_LSMW_PROJECT_20150109-165204.TXT

LSMW Project File

FI_GL_SQL_20150109-165204.TXT

Database script to create Staging Tables in the Staging Database.  These tables will be populated with legacy data and used to product Load-Ready files.

FI_GL01_DATA_20150109-165204.TXT

Sample data for Load-Ready File 01.

FI_GL02_DATA_20150109-165204.TXT

Sample data for Load-Ready File 02.




Field-Level Mapping Workbook




Staging Table Definition




Staging Table Options


To manage option settings, choose File and then Options from the main menu ribbon.


Options > Publish: Database Script > Database Script Field Brackets


TRUE = Wrap field names and data types in square brackets.


Options > Publish: Database Script > Database Script Platform


Choose from: SQL Server or Oracle

Options > Publish: Database Script > Database Script Schema


Includes a schema name (e.g. dbo) with table names.


Options > Publish: Database Script > Database Script with Defaults


TRUE =  Include default values specified for fields.




Sample Data File(s)




LSMW Project File





MDA Workbench Project File







Features




Execution Overview


...



The Process


...