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.

#In the NovoMotion Schema Editor, establish the connection information on the SQL Options tab and activates 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. <br /><br /> #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). <br /><br /> #Use the LOAD.BCI.ACTION process to test a load from the U2 server to the SQL server. <br /><br /> #Correct dictionaries, connections, or schema records as needed. <br /><br /> #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. <br /><br /> #Use the LOAD.BCI.ACTION process to load all the records from the U2 environment to the SQL server. <br /><br /> #Check the SQL server to verify results.<br /><br />