Bizview from insightsoftware

Inbound Data Integration Overview
Inbound Data Integration OverviewThis section details how to get information into Bizview. For example, how to integrate Bizview with different ERP Systems.This section contains the following topics:Bizview AdaptersWhitepaper Bizview Data Integration Application DatabaseBizview Integration Interfaces (inbound)
Bizview Adapters
Bizview AdaptersThe Bizview data adapters are template adapters that has been developed based on the Bizview Systems general experience and knowledge of integrating Bizview with different ERP Systems. Depending on the version, the usage, settings, or customization of the ERP System, these adapters may or may not work without modifications. Start by reading the instruction Implementing Bizview D...
Implementing Bizview Data Adapters
Implementing Bizview Data AdaptersThis section contains the following topics:Bizview Data Adapters OverviewInitial Technical SetupObject Integration from ERP SystemERP Ledger Transactions to Bizview DatastoreScheduling the Integration JobCustomising the Data Integration AdapterLoading Opening Balances into the DatastoreBizview Data Adapter Integration Checklist
Bizview Data Adapters Overview
Bizview Data Adapters OverviewThe Bizview data adapters are template adapters that have been developed based on the Bizview Systems general experience and knowledge of integrating Bizview with different ERP Systems.NCG may also, but is not obligated to, provide you with updates, bug fixes, or enhancements to the adapter and these updates will overwrite any previous version of the standard adapt...
Initial Technical Setup
Initial Technical SetupThis section contains the following topics:Tasks for the Database AdministratorShared SQL Server Instance for Bizview & ERP SystemSeparate SQL Server InstancesTasks for Bizview Integrator ConsultantTasks for the Bizview Consultants
Tasks for the Database Administrator
Tasks for the Database AdministratorThe objective of the tasks performed by the Database Administrator (DBA) is to make it possible for Bizview to extract and retrieve data from the ERP system database(s).There are two different scenarios, and depending on the scenario, the database administrator tasks are somewhat different.The first scenario is when the ERP database(s) and the Bizview databas...
Object Integration from ERP System
Object Integration from ERP SystemThis topic describes the process for enabling object integration from the ERP system to Bizview.This topic contains the following sections:Configure Objects to IntegrationTest Object IntegrationCheck for Errors in Object IntegrationConfigure Objects to IntegrateNavigate to Client Setup > Objects > OBJECT SETUP > Datastore Dimensions & Measures.For a list of ava...
Customising the Data Integration Adapter
Customising the Data Integration AdapterThe 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 cop...
Bizview Data Adapter Integration Checklist
Bizview Data Adapter Integration Checklist Below is a check list with all the necessary steps to setup and configure the integration data flow for a Bizview data adapter:ChecklistStatusInitial Technical Setup (DBA sysadmin) Shared SQL Server Instance Determine the internal DB User for Bizview Grant read access for the ERP database(s)  to the internal Bizview DB user Separate SQL Server Instance...
Bizview Visma Business Adapter
Bizview Visma Business AdapterThis section contains the following topics:Bizview Visma Business Adapter OverviewBizview Visma Business Adapter DetailsSetting Up Integration with Visma Dokumentsenter
Bizview Visma Business Adapter Overview
Bizview Visma Business Adapter OverviewThis topic contains the following sections:Version History for Bizview Visma Business AdapterPrerequisitesAdapter ContentVersion History for Bizview Visma Business AdapterVersionDateComment1.02014-04-08First version of Bizview Visma Adapter.1.12014-04-24Added opening balances loading procedure.1.22014-05-05Added integration with Visma Dokumentsenter. Prere...
Bizview Visma Business Adapter Details
Bizview Visma Business Adapter DetailsThis topic contains the following sections:Set Up Data Sources for Visma BusinessObject Tags for the Visma Business AdapterLedger Transaction ColumnsVisma Business TablesSet Up Data Sources for Visma Business Below is a list of data sources:ColumnComment (enter this value)client_idBizview client_id.module_idGL (General Ledger).system_idVB (Visma Business ad...
Setting Up Integration with Visma Dokumentsenter
Setting Up Integration with Visma DokumentsenterBelow is a list of steps needed to enable viewing of scanned documents (Invoices) from Visma Dokumentsenter.Copy stored procedure stg.p_adp_docfile_VB_DOKSENTER to schema custstg .Modify the stored procedure, set valid UNC path to document files:In the Drill Down template, make sure you have a column named DOC_REFERENCE.Add a hyperlink in the temp...
Bizview Visma Global Adapter
Bizview Visma Global AdapterThis section contains the following topics:Bizview Visma Global Adapter OverviewBizview Visma Global Adapter Details
Bizview Visma Global Adapter Overview
Bizview Visma Global Adapter OverviewThis topic contains the following sections:Version History for Bizview Visma Global AdapterPrerequisitesAdapter ContentVersion History for Bizview Visma Global AdapterVersionDateComment1.02014-04-08First version of Bizview Visma Global Adapter1.12014-04-24Added opening balances loading procedure PrerequisitesThe adapter is compatible with Bizview version 6.0...
Bizview Visma Global Adapter Details
Bizview Visma Global Adapter DetailsThis topic contains the following sections:Set Up Data Sources for Visma GlobalObject Tags for the Visma Global AdapterLedger Transaction ColumnsVisma Global TablesSet Up Data Sources for Visma GlobalBelow is a list of data sources:ColumnComment (enter this value)client_idBizview client_id.module_idGL (General Ledger).system_idVG (Visma Global adapter).db_ins...
Bizview Hogia Adapter
Bizview Hogia AdapterThis section contains the following topics:Bizview Hogia Adapter OverviewBizview Hogia Adapter DetailsSetting Up Integration with Hogia Approval
Bizview Hogia Apter Overview
Bizview Hogia Apter OverviewThis topic contains the following sections:Version History for Bizview Hogia AdapterPrerequisitesAdapter ContentVersion History for Bizview Hogia AdapterVersionDateComment1.02014-04-08First version of Bizview Hogia Adapter1.12014-04-23Added integration with Hogia Approval Manager1.22014-04-24Added opening balances loading procedure PrerequisitesThe adapter is compati...
Bizview Hogia Adapter Details
Bizview Hogia Adapter DetailsThis topic contains the following sections:Set Up Data Sources for HogiaObject Tags for the Hogia AdapterLedger Transaction ColumnsHogia TablesSet Up Data Sources for HogiaBelow is a list of data sources:ColumnComment (enter this value)client_idBizview client_id.module_idGL (General Ledger).system_idHOG (Hogia adapter).db_instanceLinked server name to Hogia database...
Bizview Jeeves Adapter
Bizview Jeeves AdapterThis section contains the following topics:Bizview Jeeves Adapter OverviewBizview Jeeves Adapter Details
Bizview Jeeves Adapter Overview
Bizview Jeeves Adapter OverviewThis topic contains the following sections:Version History for Bizview Jeeves AdapterPrerequisitesAdapter ContentVersion History for Bizview Jeeves AdapterVersionDateComment1.02014-04-08First version of Bizview Jeeves Adapter1.12014-04-24Added opening balances loading procedurePrerequisitesThe adapter is compatible with Bizview version 6.0 and later.Use this docum...
Bizview Jeeves Adapter Details
Bizview Jeeves Adapter DetailsThis topic contains the following sections:Set Up Data Sources for JeevesObject Tags for the Jeeves AdapterLedger Transaction ColumnsJeeves TablesSet Up Data Sources for JeevesBelow is a list of data soures:ColumnComment (enter this value)client_idBizview client_id.module_idGL (General Ledger).system_idJV (Jeeves adapter).db_instanceLinked server name to Jeeves dat...
Bizview SIE Adapter
Bizview SIE AdapterThis section contains the following topics:Bizview SIE OverviewConfiguring Bizview Client for SIE ImportImporting SIE Files into Bizview
Bizview SIE Adapter Overview
Bizview SIE Adapter OverviewThis topic contains the following sections:Version History for BizviewPrerequisitesAdapter ContentVersion History for Bizview VersionDateComment1.02014-05-05First version of Bizview SIE Adapter PrerequisitesThe adapter is compatible with Bizview version 6.0 and later.SIE files that are imported need to be of the SIE4 type (transactions) Adapter ContentContentTypeComm...
Importing SIE Files into Bizview
Importing SIE Files into BizviewThis topic describes the process for importing SIE Files into Bizview.Access this function by following the path: Client > Client Options > IMPORT FUNCTIONS > Import SIE files.Upload the SIE file from your computer (or network).After the file uploads, information about the content displays: Click on Save to start the import.When the import is complete, you receiv...
Whitepaper Bizview Data Integration Application Database
Whitepaper Bizview Data Integration Application DatabaseThis section contains the following topics:Bizview Data Integration Application Database OverviewIntegration StrategiesPrerequisitesInterfaces to the Bizview Application DatabasePlanning DataExample: Easy Integration
Bizview Data Integration Application Database Overview
Bizview Data Integration Application Database OverviewThe is topic provides a general overview of how to integrate data into the Bizview application database. This topic is not dependent on if you are deploying the Bizview Datastore or not. The intended audience is integration specialists, consultants, and others with an interest in how data should be loaded into the Bizview application databas...
Integration Strategies
Integration StrategiesBizview can report on data from many different data sources. A report, dashboard, or similar show data from a datawarehouse, an ERP system, or from some other datasource.Bizview also needs to store some data within the Bizview application database. The general principle is that this data is related to the functionality of Bizview application. The Bizview application must f...
Bizview Integration Interfaces (Inbound)
Bizview Integration Interfaces (Inbound)FieldDescriptionMandatory (logically)Aggregated to fin_ledgersumExample Data[client_id] [nvarchar](50) NULL,The ID of the client/company where the transaction is booked.xx10[version_id] [nvarchar](50) NULL,The ID of the version the record belongs to. Should normally be set to "ACT".xxACT[isomonth] [nvarchar](50) NULL,The transaction month number in format...
First Page
Back
For an optimal Community experience, Please view on Desktop