Database
OLEDB Integration
Zynk's OLEDB integration connects workflows to data reached through an OLE DB provider, such as Microsoft Access databases, Excel workbooks and SQL Server. SQL tasks select rows as XML, update records, return single values or repeat steps for each row, so that data moves into Sage 200, Magento, Business Central or QuickBooks without manual exports.
Capabilities may differ depending on the product.
Benefits
Why businesses connect OLEDB
Workbooks and Access files as live sources
Price lists kept in Excel and departmental Access databases become proper data sources. Zynk reads them through the provider installed on the server, so nobody has to save, rename and upload files by hand.
Connection settings you control
Each connection is defined by a provider, a data source and its properties, mirroring a standard OLE DB connection string. Pointing a workflow at a test copy or the live file is a matter of changing the source.
Results shaped for the next step
Execute Select Query turns the rows a query returns into XML, using the root and row element names you set. Accounting, ecommerce and ERP import tasks can consume that file as it stands.
Processing row by row
The OLEDB Repeater runs a block of tasks for every row returned and exposes column values as variables. A single line in a workbook can become its own order, email or API call.
Updates written back
Execute Query runs insert, update and delete statements, so a workflow can mark rows as exported or store the document number another system returns. Execute Scalar Query fetches one value, such as a row count, to decide what happens next.
Capabilities
What you can do with OLEDB
Every task the Zynk OLEDB connector can run, grouped by the direction data moves.
Actions in OLEDB
Tasks Zynk can automate in OLEDB
4 tasks
- Execute query → in OLEDB
- Execute scalar query → in OLEDB
- Execute select query → in OLEDB
- OLEDB repeater → in OLEDB
Need something that isn't listed?
Most OLEDB projects include at least one custom step. Our team builds it for you.
The problem
Why integrate OLEDB?
A lot of operational data never makes it into a proper system. It sits in an Access database built years ago or a shared Excel workbook that one person maintains. Moving it into the accounts or the web store depends on copy and paste, and errors creep in every time someone does it.
Without integration
- Prices copied from a spreadsheet into the web store line by line
- Orders logged in an Access database and retyped into the ledger
- No way to tell which rows have already been sent
- A process that depends on one person's spreadsheet routine
With Zynk
- Workbook rows are read by query and imported as prices
- Access records pass straight to the accounting system's import tasks
- An update statement marks each row once it has been handled
- A scheduled workflow with logging and error alerts
How it works
How the OLEDB integration works
Step 1: Install the provider
Make sure the right OLE DB provider is installed where Zynk runs, such as the Access Database Engine for Access and Excel files or Microsoft's OLE DB driver for SQL Server.
Step 2: Create the connection
Enter the provider name, the data source path or server and any properties the provider needs, such as the Excel file version or whether the first row holds column headers.
Step 3: Build the queries
Write SQL for each step or use the query designer, adding parameters so the same statement can run for a date range, a branch or a single customer.
Step 4: Join it to the workflow
Pass results to import tasks for systems such as Sage 200 or Magento, schedule the run and write a status back to the source so no row is processed twice.
Integrations
What can you connect to OLEDB?
Example use cases for OLEDB integration
OLEDB and Sage 200
Read sales orders or customer records from an Access database and import them into Sage 200, then keep stock records exported from Sage 200 in the database for local use.
OLEDB and Magento
Use an Excel price workbook as the source for Magento tier and special prices, and keep a local copy of Magento orders for analysis outside the store.
OLEDB and Microsoft Dynamics 365 Business Central
Load items and customers maintained in Access or Excel into Business Central, and write posted sales invoices back to a reporting database.
View the Microsoft Dynamics 365 Business Central integration →
OLEDB and QuickBooks
Create QuickBooks Online customers and invoices from rows in a spreadsheet or database, and keep exported payments in a table finance can query.
OLEDB integration FAQs
What is the difference between OLEDB and ODBC in Zynk?
Can Zynk read an Excel workbook through OLEDB?
Can Zynk connect a Microsoft Access database to Sage?
How much SQL do OLEDB workflows need?
Which systems can OLEDB data be sent to?
Can I loop through each row in a spreadsheet?
How do I get an OLEDB workflow started?
See what Zynk can automate for your OLEDB setup
Book a 20-minute call. We'll review your systems, flag the quick wins and outline a practical route to going live.
Book a callSee pricing →