Microsoft SQL Server Compatibility
Adagio does not use an external (3rd party) database manager such as Microsoft SQL or Oracle to store its data. However, 25 years of experience has shown that Adagio's internal database is robust, fast and scalable. Adagio's internal database offers the following benefits:
- No requirement for external expertise for setup or configuration
- No need for additional licenses
- No need for additional hardware over the requirements of the application
- No security issues since only those people explicitly given access tools can look at the data
If an organization has an IT department and a corporate standard for data storage, then the use of a private database may be an issue, but the typical Adagio client outsources their IT support and is more interested in available tools for data access. Users can access their accounting data using:
- Adagio ODBC for read-only or read-write access to the data using industry standard tools (including SQL Server and MS Query)
- SAP Crystal Report 2013 and above using Adagio ODBC 9.1A and higher to provide complex management reports.
- Adagio GridView for simplified ad-hoc inquiries where the numbers are more important than the presentation of the data
- Adagio FX for financial statement style reporting off the general ledger figures
- Import/Export templates to easily move masses of data into and out of the accounting database on a one time or repetitive basis
* Adagio GridView 9.0F or higher can connect to SQL (or any data source with a “file” DSN or UDL in the Adagio data folder), allowing you to create Workspaces to your Adagio data that include data from SQL tables.
Asking "what database technology are you using" is the same as asking "what programming language is it written in". The answer is only significant if you are planning on modifying the code or writing directly to the database, a task that we would actively discourage even if Softrak did make the source code available. (We do make the database schema available.)
Issues about database use are indirectly related to database size and/or transaction processing speed. While most of our clients are small or medium-sized, with a single accounting department staff member, we do have clients who use Adagio to:
- Manage over 700,000 inventory items
- Track over 100,000 customers
- Process over 25,000 invoices per month
- Manage more than 85,000 general ledger accounts
- Manage more than 450 departments
- Pay over 200,000 checks per year
- Post batches for over $1 billion
Remember, SQL only defines an "Access language" (Structured Query Language), it does not speak to how the data is stored on disk. QuickBooks uses an SQL database to store its data, but only permits access to the data using its SDK or an ODBC link with a restricted view of the fields in the database (defined by the SDK). Direct access to the data in the database is not permitted.
Adagio uses a B* Tree indexed method with significant data redundancy to protect against hardware failure. By installing Adagio ODBC and linking the Adagio data to MS SQL Server, technical staff can easily structure queries against the database for company reporting.