User Tools
normal_processing_steps
This is an old revision of the document!
'Normal' Processing Steps
Here is a recommendation of steps to follow when a file is to be added to the NovoMotion outbound process:
- Create a new schema using either NovoMotion NOVO.GEN.SCHEMA or NovoMotion Schema Editor.
- In the NovoMotion Schema Editor, establish the connection information on the SQL Options tab and activate the schema.
- In the NovoMotion Schema Editor, use the SQL script creation (Creating a SQL Script) process to generate a SQL script to copy and execute in the SQL database.
- If the ODBC datasource is new, create it by either adding a data source through the Administrative Tools (Windows) or ding the data source to the odbc.ini record (Unix).
- Use the LOAD.BCI.ACTION process to test a load from the U2 server to the SQL server.
- Correct dictionaries, connections, or schema records as needed.
- Once there are no identified issues, use NOVO.E.T (NovoMotion Trigger Generator) to enable an UPDATE (and usually a DELETE) trigger on the U2 file.
- Use the LOAD.BCI.ACTION process to load all the records from the U2 environment to the SQL server.
- Check the SQL server to verify results.
normal_processing_steps.1612297486.txt.gz · Last modified: 2021/02/02 20:24 by dlm
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
