Database

In this section, we'll cover the most common types of direct data access.

This could be pulling custom data out of Sage 50/200 by directly querying their databases, or by directly connecting to other databases such as ODBC/OLEDB/SQL.

We do not support directly importing data into Sage via this method as the potential to cause data corruption is unmanageable so for these systems, only exports of data are permitted.

Custom Exports of Sage Data

• Sage 50 Custom Exports
• Sage 200 Custom Exports

Workflow Tutorials

• Using the ODBC Connector
• Using the OLEDB Connector
• Using the SQL Connector

Workflow Examples

Right Click and choose "Save Target as..." or "Save link as..."

• SQL Server Workflow
• ODBC Example Workflow
• OLEDB Example Workflow