Tasks for Bizview Integrator Consultant

This topic provides a list of tasks to complete when using Bizview Integrator Consultant.

This topic contains the following sections:

• Ensure Bizview Processing Services is Running on the Bizview Server

• Define Reference to the Bizview Application Database

• Copy Stored Procedure stg.p_adp_fin_ledgertras_<systemid> to schema custstg

• Copy Stored Procedure stg.p_adp_object_values_<system id>  to schema custstg

• Execute Utility Procedure to Create a Template Job for ERP Integration

Ensure Bizview Processing Services is Running on the Bizview Server

Check the Windows Services setup on the Bizview server:

Define Reference to the Bizview Application Database

• Use SQL Server Management Studio

• Connect to the Bizview datastore DB

• Edit table app.settings

value_1: Change this value to the Database name for the Bizview application database in your installation.

Copy Stored Procedure stg.p_adp_fin_ledgertras_<systemid> to schema custstg

This is the first adapter procedure you should take a copy of into the protected custstg schema. This procedure is located in the Bizview Datastore database.

• Use SQL Server Management Studio

• Connect to the Bizview datastore DB

• Open script for procedure stg.p_adp_fin_ledgertrans_<system id>

• Change the "create procedure" statement to schema custstg

Copy Stored Procedure stg.p_adp_object_values_<system id>  to schema custstg

This is the second adapter procedure you should make a copy of into the protected custstg schema. This procedure is located in the Bizview application database.

• Use SQL Server Management Studio

• Connect to the Bizview application DB

• Open script for procedure stg.p_adp_object_values_<system id>

• Change the "create procedure" statement to schema custstg

Execute Utility Procedure to Create a Template Job for ERP Integration

The adapter procedures are now created within the custstg schema. Now, you need to configure a Processing Services Job within Bizview. To make this a fast process we have created a procedure that will do this task automatically for you:

• Use SQL Server Management Studio

• Connect to the Bizview application DB

• Execute the following statement (change parameter values)

exec [utils].[p_integration_job_preload]

    @template_id      = 'ADP_JV',

    @system_id        = 'JV',

    @erp_system_name  = 'Jeeves'

Next step:Tasks for the Bizview Consultants