Connect on-premises SQL databases to Business Central Online
Business Central Online reads and writes data in your on-premises SQL database — through OneConnector and a step of its own in AutoFlow, without a migration.
Read the use case- Connect
- Databases
- On-premises
- Partner integration
Connect OneConnector to Business Central
Business Central runs in the cloud, but the legacy system's database and the folders the scale and the shipping software write to are in your own building. OneConnector makes them reachable, and AutoFlow brings them into your processes.
The connection
What AutoFlow does with OneConnector
Business Central Online cannot reach the database in your own server room, or the network drive. Yet that is often where what you need every day lives: the legacy system, the specialist application, the table that was never migrated, the folder a machine writes its feedback into.
Penduline's OneConnector runs inside your network and builds the bridge. In AutoFlow it is a step of its own: run an SQL query, write records back, fetch files from a folder or put them there. What Business Central may see and change, you define yourself in SQL.
Partner integration
AutoFlow and OneConnector, already connected
Agreed with the connector partner and built: we set the integration up with you, rather than you putting it together yourself.
Agreed with Penduline
Penduline is an AutoFlow connector partner. The integration uses the official interface, not a workaround.
Finished, not self-built
The processes are built. We set them up with you; you bring the credentials and the mappings.
Visible and extensible
Every step sits in AutoFlow as a process. You see what happens, and add to it without code.
Upgrade-safe
None of it sits in the Business Central core. An update leaves the integration untouched.
What it does
What AutoFlow and OneConnector exchange
In both directions, for databases and for files. Which data that is, you decide in SQL and in your choice of folders.
Out of Business Central
- Write values from a document into the on-premises database, on release or posting for instance
- Create or update records in the legacy system when something changes in Business Central
- Put a file exactly in the folder where the shipping software or a legacy system expects it
Into Business Central
- Run an SQL query from inside a process and carry on with the result
- A scheduled process keeps records from the on-premises database in step with Business Central
- Read new files from a folder, create records from them and move the file to the archive
What you need
What has to exist on your side
- OneConnector in your network Set up on your side, with access to the database and the folders you want to connect. License and setup come from Penduline, and we coordinate it together.
- The queries you need In SQL, by someone who knows the database. That is also where you decide what Business Central may read and write, no more and no less.
Use cases
What you do with it
Process on-premises files in Business Central Online
Files from local folders land in Business Central Online automatically, and exports from Business Central land where your local systems expect them.
Read the use caseQuestions we get asked
Which databases work?
SQL databases, which is what legacy systems and specialist applications almost always use. What Business Central sees of them, you write as an SQL query. Whether your database is among them, we settle in the first conversation.
Can AutoFlow write into the database too?
Yes. A process can create and change records, exactly as far as your queries allow. The same goes for folders: read files and put files there.
Do I have to migrate data for this?
No. That is the point: the data stays where it is, and Business Central uses it anyway. Whether you migrate later is a separate decision.
Is my database then reachable from the internet?
No. OneConnector sits in front of the database, and only the queries you set up are available from outside. Which tables and fields Business Central can reach, you decide in each query.
Get it set up
Your on-premises data in Business Central Online
We set the connection up with you and Penduline: from OneConnector in your network to the first process that does without an export file.
- Read and write SQL databases
- Fetch files from folders and put them there
- No migration, upgrade-safe