Integration · Finance and ERP
SQL Server-based systems — the orders from your own server
Visma Business and Global, PC-Kasse, SAP, Uni Micro and NAV on your own server are read as an order source. Six systems share one connection, and the system type picks the queries.
- Direction
- In — read-only mirror
- Connection
- Point at the server
- Note
- Holio has to be able to reach the server.
Into Workspace
What Workspace takes from SQL Server
Orders
The orders to ship, read straight from the database.
Shipping details
Recipient and delivery choice from the same tables.
Six systems, one connection
Visma Business, Visma Global, PC-Kasse, SAP, Uni Micro and NAV.
Read-only: Workspace never writes to SQL Server.
How SQL Server is connected
Pick the system
Under Integrations in Workspace, with the fields SQL Server needs.
Point at the server
Server, database and a read-only user. Holio has to be able to reach the server, so the network is opened for us before the first sync.
First sync
The history is mirrored in, and from then on a sync job of its own keeps it current. A stop shows on Sync health before it shows in the numbers.
Finance and ERP
More in the same category
Visma Business NXT
Two-way where the work happens in Workspace
Visma.net Financials
Orders in, tracking number back
Visma Payroll
In — read-only mirror
PowerOffice Go
In through the API
Tripletex
Data in and approved vouchers back
Fiken
In — read-only mirror
Fortnox
In — read-only mirror
Business Central
Orders in, tracking number back
CSV and Excel
In from a file
Do you use SQL Server?
We show what SQL Server looks like in Workspace, in a demo with your own setup.