Object Integration from ERP System
This topic describes the process for enabling object integration from the ERP system to Bizview.
This topic contains the following sections:
Configure Objects to Integrate
Navigate to Client Setup > Objects > OBJECT SETUP > Datastore Dimensions & Measures.
For a list of available Col names, see Bizview Adapters for information on the specific data adapter you intend to use.
Test Object Integration
Run the integration job by selecting steps 10 through 40:
Check for Errors in Object Integration
Check the Job Archive log in Bizview and make sure all job steps executed successfully.
In the example below, all steps are marked with green icons, which indicates that all steps executed successfully:
Check Job Step Warnings
Sometimes the validation steps (20 to 40) executes successfully, but there are warnings.
Warnings are denoted by an orange icon, shown below:
Rows in the staging table(s) that fail to pass the validation check will not be updated to Bizview. Instead, they are logged to separate tables (in the stgerr schema).
Analyse Validation Errors
Use SQL Server Management Studio
Connect to the Bizview application DB
Execute statement(s)
selectdistincterror_code,error_value,error_descr
fromstgerr.v_object_valueswherejob_id='5715'
selectdistincterror_code,error_value,error_descr
fromstgerr.v_object_treeswherejob_id='5715'
selectdistincterror_code,error_value,error_descrfromstgerr.v_object_value_attributeswherejob_id='5715'
Query result (example)
Check Job Step Errors
In rare cases, a job step may fail. A failure is indicated by a red icon, shown below:
Error messages are shown in the job "Messages" tab.
Check Object Values in Bizview
Make sure that you have object values in Bizview for all the objects you have configured for integration.
Follow these steps:
Open the Object value grid form in Bizview
Check object values for each object