NovoRoi Systems DokuWiki

Here is a recommendation of steps to follow when a file is to be added to the NovoMotion outbound process:

1. Create a new schema using either NovoMotion NOVO.GEN.SCHEMA or NovoMotion Schema Editor.
2. In the NovoMotion Schema Editor, establish the connection information on the SQL Options tab and activate the schema.
3. 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.
4. 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).
5. Use the LOAD.BCI.ACTION process to test a load from the U2 server to the SQL server.
6. Correct dictionaries, connections, or schema records as needed.
7. 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.
8. Use the LOAD.BCI.ACTION process to load all the records from the U2 environment to the SQL server.
9. Check the SQL server to verify results.