a. first to prepare TEMP & MAIN table in SQL
Example: (in DiP3 Test environment)
We get a new BW file: DYS_BW_BOM.csv
Step by steps:
Step 1: Copy/Paste file to 'IN' folder ,in this case DYS_BW_BOM.csv
Step 2: To create DYS_BW_BOM.fmt file in ‘Format’ folder
Step 3: To edit DYS_BW_BOM.fmt file in ‘Format’ folder, keep same column number in .fmt file compare to .csv file
Step 4: Add the new files treatment in FileToSql.cmd (D:\DynaSys\Test\Itf）
Step 5: a. Create _TEMP table in SQL server, duplicate one _TMEP to copy, right click to create a new query
Step 5: b. Create _TEMP table in SQL server, correct the values accordingly
Step 5: c. ADAPT VIEW in SQL server, correct the values accordingly
Step 6: a. Go to Itf folder (wdcdyad21.eua.solvay.com\DynaSys\Test\Itf) right click on FilesToSql.cmd -> Run as administrator，to transfer file to SQL
Step 6: b. Check the _TEMP Table if it’s correctly filled
Step 7: Add treatment in Macros: GetUNC, to feed tables, _TEMP to _MAIN.
Need to know which environment (DP or DiP). If it’s DP, need to do it in DP1/2/3
Step 8: Add “DYS_BW_BOM” to Tech: Update Datahub, to trigger the automatic update
Step 9: Run Update Datahub + Check logs if no errors
Step 10 (optional): If need to interface to Dyn, adapt scenario/query/mapping