Skip to main content
Sales and customersQuotes and costingA price per recipe, the same day.Orders and customer contactFrom quote to shipment, customer informed.Customer portalOrders, stock and certificates, for your customer.
ProductionPlanningOne current plan for the office and the floor.Production and operatorsWork instructions, scans and shift handover on the tablet.Quality and batch recordChecks, deviations and release without paper.
Warehouse and insightWarehouse and stockPer lot and location, picking by shelf life.PerformanceDowntime, OEE and what an order really cost.
How it worksFrom quote to shipment

Follow one order through your factory and warehouse, in eight steps.

See the steps →
Contract manufacturing and private labelYour customers are brands with high expectations.Co-packing and fillingFood and supplementsLot numbers, shelf life and labels per order.FoodSupplementsBakery and confectioneryBeveragesAnimal feed and pet foodChemicals and cosmeticsMixing and filling to order, documents per batch.Cosmetics and personal careCleaning productsPaints, coatings and adhesivesFlavours and fragrancesMake-to-order manufacturingMetal, plastics and assembly.Printing, packaging and labelsPlastics processingMetalworkingMachine and equipment buildingFurniture and interior fittings
Industry not listed?Do you produce to order?

Then Frontlink fits. Tell us which process takes you the most time.

Bring us one process →
IntegrationsYour ERP, email, Excel and databases, connected.Shop floor and machinesMachines, tablets and scanners, also when the internet drops out.AI and agentsAgents on your live production data. You approve.SecurityWhere your data lives and who can access it.
For your IT teamAPI and developer docs

How Frontlink connects, with an API for your own tools.

To the docs →
Databases

Your own databases, read and filled without exports.

Many factories keep data in their own databases: label data, quality archives, reporting tables. Frontlink reads the tables you choose and writes results back, so the systems and reports built on them keep working.

Book a callAll integrations

Databases and Frontlink.

Frontlink connects to relational databases such as Microsoft SQL Server, PostgreSQL, MySQL, MariaDB and Oracle. It reads item specifications, label data or customer settings from your own tables and writes production results, lots, checks and downtime to tables you choose.

Databases inside your network are reached through the edge gateway in the factory, so no port has to be opened to the internet. Your BI tool, such as Power BI, keeps reading from the database it knows, now with live data from the floor.

Direction
Read, write or both
Data exchanged
Specifications, label data, production results, lots, checks and downtime
How it connects
SQL through the edge gateway, or directly for cloud databases
Access
A dedicated database user with rights on selected tables only
Typical setup time
One to two weeks

What moves between them.

  1. Existing tables are read

    Item specifications, label data or customer settings in your own tables are used in Frontlink, without maintaining them twice.

  2. Results are written back

    Output, lots, checks and downtime go to a table you choose, so your reports and dashboards fill themselves.

  3. One place for your analysts

    Your BI tool keeps reading from the database it knows, now with live data from the floor in it.

How we connect it.

  1. A dedicated database user

    You create a user for Frontlink with rights on only the tables that are needed. Read-only if that is all you want.

  2. Reached through the edge gateway

    A database inside your network is reached through the edge gateway, so nothing has to be opened to the internet.

  3. We agree on the tables

    Together we decide which tables and columns Frontlink reads and where it writes, and test on a copy first.

Other integrations.

Where you see it in Frontlink.

  1. PerformanceFrontlink measures rate, downtime and scrap per line, per order and per shift. So you see where things go wrong while it still matters, and what an order really cost.
  2. Warehouse and stockFrontlink knows per lot what is there, where it is and how long it is good for. The warehouse picks by shelf life, stock matches what was really used, and a lot can be traced in one click.

Frequently asked questions.

Which databases are supported?

Microsoft SQL Server, PostgreSQL, MySQL, MariaDB and Oracle, and other databases with a standard SQL interface. We check your version with you.

Will Frontlink slow down our database?

No. Frontlink reads in small batches at quiet moments or on changes, and we agree on the load with your IT.

Can Frontlink only read, without writing?

Yes. Read-only access is enough if you only want to use existing data in Frontlink.

Can Power BI read Frontlink data?

Yes, through a database table that Frontlink fills, or directly through the Frontlink API.

Using something else? Tell us.

In a 30-minute call we look at your systems and machines and tell you which connections make sense to start with.

Book a call