Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Anyone with Sage 100 Experience ??

Posted By Rosenbaum36 over 2 years ago

I am a contract web developer and currently have a painting company asking if I could create a web app that automatically pulls and manipulate data from their database. I went to a meeting with them and realized that they use a program called “sage 100” so I researched it a bit and found out it’s an SQL server.

I have experience using mysql for my web apps but I can’t seem to figure out how to access the raw database at their company. Is the Sage 100 sql server on the same server as the app or does the app connect to another server that stores the data? Would gladly take any advice.

Thanks.

indigocard

Top Replies

BigLouie over 2 years ago +1

You have to first determine which version they are on. Sage 100 has three different versions. Two (2) run on a ProvideX back end and one runs on SQL. The ProvideX version is the most common. All versions…

FormerMember over 2 years ago

If your client is running 100 Premium then the accounting application is using its internal ODBC driver to connect to Microsoft SQL Server.

If you plan to do more than read the SQL DB I would suggest hooking up with a Sage 100 consultant for assistance.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
BigLouie over 2 years ago

You have to first determine which version they are on. Sage 100 has three different versions. Two (2) run on a ProvideX back end and one runs on SQL. The ProvideX version is the most common. All versions can be accessed with ODBC.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Cancel

Sage 100

Anyone with Sage 100 Experience ??

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING