ERP Adapter Configuration
The ERP Adapter Configuration is where you configure how a standard Bizview adapter is supposed to integrate data from the ERP system into the staging area (.stg) of Bizview. In this configuration, you need to specify where the ERP database is located and enter the mapping between Bizview objects and the ERP tag ID's. The result of this configuration is that the adapter will be able to find the correct database and integrate the correct data into the corresponding Bizview dimensions.
Access ERP Adapter Configuration by selecting System Administration > Data Services > ERP Adapter Configuration.
To configure an ERP adapter, select the Add a new integration configuration link, or click the New button at the bottom.
Below is a list of the available ERP Adapter Configuration fields:
Field | Description | Example | Note |
|---|---|---|---|
Client ID* | The Bizview Client to integrate to. | 10 Sweden | Choose among the existing Bizview Clients. |
System ID* | The System ID for the adapter. | Jeeves | Choose among the existing Bizview system adapters. |
DB Instance* | Server instance where the ERP system resides. | PRODSQL123\HOG01 | |
Database* | Name of the ERP database name. | Must be exactly the same as database name, keep same caption. | |
DB Schema* | Name of database schema to integrate with. | dbo | |
DB Table Prefix | The table prefix in ERP database. | If applicable, enter the table prefix. | |
ERP Client ID | The REP Client ID to integrate from. | If applicable, enter the Client ID in the ERP system to integrate from. |
Additional Information
To map the Bizview Objects defined in the selected client, add this information in the table to the right of above definition:
- Click the Add button.
- Select Bizview Object.
- Enter the ERP Tag ID to be mapped to the selected Bizview Object.
We do not describe the whole integration functionality in this documentation. For more information, see the white papers for each of the supported systems. We continuously develop new adapters for ERP systems and there are white papers available for each of these.
For more information regarding available adapters, please contact bizviewsupport@insightsoftware.com.