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 # | Description | Screenshot |
|---|---|---|
| Step 1 | Step 1: Copy/Paste file to 'IN' folder ,in this case DYS_BW_BOM.csv | |
| Step 2 | Step 2: modify EmptyScript.sql file in order to delete the new table before each refresh. 'ITF' folder |
|
| Step 3 | Step 3: To create DYS_BW_BOM.fmt file in ‘Format’ folder | |
| Step 4 | Step 4: To edit DYS_BW_BOM.fmt file in ‘Format’ folder, keep same column number in .fmt file compare to .csv file | |
| Step 5 | Step 5: Add the new files treatment in FileToSql.cmd (D:\DynaSys\Test\Itf） | |
| Step 6 | Step 6: a. Create _TEMP table in SQL server, duplicate one _TMEP to copy, right click to create a new query | |
| Step 6: b. Create _TEMP table in SQL server, correct the values accordingly | ||
| Step 6: c. ADAPT VIEW in SQL server, correct the values accordingly | ||
| Step 7 | Step 7: 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 7: b. Check the _TEMP Table if it’s correctly filled | ||
| Step 8 | Step 8: 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 9 | Step 9: Add “DYS_BW_BOM” to Tech: Update Datahub, to trigger the automatic update | |
| Step 10 | Step 10: Run Update Datahub + Check logs if no errors | |
| Step 11 | Step 11 (optional): If need to interface to Dyn, adapt scenario/query/mapping | |
