Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Customising the Data Integration Adapter

The adapter may be customized in various ways, and for various reasons. Maybe you want to clean, adjust, or convert data that was loaded into the staging table(s). Or, you want to get data from the ERP system that the standard procedure does not provide.

One customizing option you have is to alter/add some logic in the standard procedures that you have copied into the "custstg" schema.

Another option is to add a new job step(s) to the integration job and develop a new procedure for that step.

In the example below, step 61 was inserted after loading transactions to the staging table. Step 61 does some fixes with the loaded data, before step 70 (validation) executes.

job_steps_customized

In this example, a new procedure (custstg.p_adp_fin_ledgertrans_fix has been developed) in the Bizview Datastore database, and then attached to step 61.

job_steps_customized2

Next step:Loading Opening Balances into Datastore
Published:

Customising the Data Integration Adapter

The adapter may be customized in various ways, and for various reasons. Maybe you want to clean, adjust, or convert data that was loaded into the staging table(s). Or, you want to get data from the ERP system that the standard procedure does not provide.

One customizing option you have is to alter/add some logic in the standard procedures that you have copied into the "custstg" schema.

Another option is to add a new job step(s) to the integration job and develop a new procedure for that step.

In the example below, step 61 was inserted after loading transactions to the staging table. Step 61 does some fixes with the loaded data, before step 70 (validation) executes.

job_steps_customized

In this example, a new procedure (custstg.p_adp_fin_ledgertrans_fix has been developed) in the Bizview Datastore database, and then attached to step 61.

job_steps_customized2

Next step:Loading Opening Balances into Datastore
For an optimal Community experience, Please view on Desktop
Powered by Zendesk