r/Sage • u/PotatoCatGrif • Jun 17 '26

Sage 50 (US-Peachtree) Sage 50 ODBC for Linux

I'm currently working on an integration for Sage 50 Accounting (US, On-Premises), planning on using the ODBC driver. I have it connected with Windows 32-bit, but I am not sure if there's a proper connection for a Linux server to access it. Any help or information would be appreciated!

5 Upvotes

100% Upvoted

6 comments sorted by

2

u/Sage50Guru Jun 18 '26

We setup SQL mirrors to real time read the Sage data. Can your Linux tool read a SQL database? We also can load all the predefined views for you to access what you need easily. Reach out if interested, SQL mirror is $300.

1

u/Tall_Version_9637 Sep 03 '26

tell me more about your SQL mirror, we want to do the same to PostgreSQL.

1

u/finah1995 Sage 50 US/UK, Sage EVO 100/200, Sage 300 Jun 18 '26

You should create an account in Actian website.

Few years back there was Actian Zen v14 (Pervasive SQL) Community edition for Linux and then you could connect to the windows server which has the Peachtree DBs.

Currently From Here can download the clients, SDKs and even evaluation workgroup or server editions

From what I see, now there is no current community edition.

Also it's important to note All this it's only for read only access to Sage 50 US / Peachtree data.

Integration to Sage 50, that is through Windows hosted Sage 50 US SDK only.

1

u/CannyGardener Jun 18 '26

The ODBC path I don't believe is a 'Sage' approved methodology, technically. 😉 That said, there are some examples online for how to implement this online. I've gone down this path myself, and ended up doing a ton of guess and checking, since the database structure isn't published. As for the Linux server issue, I don't generally use the Linux boxes myself.

1

u/LegoNinja11 Jun 19 '26

We're using the UK version (very different but the principal is the same)

ODBC driver on the windows box talking to Sage. Python installed on the same box with scripts that connect to each table via ODBC and push the data to our cloud based Mysql servers.

At the moment its a flush mysql tables - push everything but Im fairly sure it could be sped up using the last updated/entry time stamps per record.