14 / Integrations

BAS data in external databases and files

Custom import and export routines for agreed data sets including products, customers, sales and other operational information.

MSSQLPostgreSQLData exchangeFiles

Discuss integration with your system ↗

The task

BAS ↔ MSSQL / PostgreSQL

External systems need defined accounting data sets and transfer directions.

Interaction diagram

BAS ↔ MSSQL / PostgreSQL

Selected connectionBAS → Custom routines

Data for export

Architecture

Technical description

Custom routines connect BAS to external databases and file-based outputs. Import and export scenarios are separate, with data and direction specified for each database task.

Data scope

Agreed product, customer, sales, delivery-location and marketplace data. A separate routine prepares tables for file export.

Our implementation

MSSQL and PostgreSQL connections, table preparation and exchange of defined data sets. The diagram does not imply complete database replication or direct editing of internal BAS tables.

Requirements for a new project

Define the source of each entity, mappings and output format. Change data capture, all-table synchronisation and a data warehouse require separate scope.

What we developed

Custom database and file-exchange routines

Developed connections to MSSQL and PostgreSQL.
Implemented exchange of products, customers, sales, delivery locations and marketplace data.
Created table preparation and export workflows, including file-based exchange.

Implementation result

External systems receive agreed accounting data through separately developed import and export workflows.

Discuss your task ↗