Product Spotlight: Taking Advantage of Your 64-bit Server with Platinum SQL

October 2016    Tags: ODBC, Platinum, Security, SQL

Do you want to take advantage of all the features of Platinum, while also taking full advantage of your server’s memory? If you have a 64-bit server, such as Windows Server 2012, you can improve the performance of accelerated reports and filtering with Platinum SQL! The standard multi-user and Platinum versions of Tabs3 and PracticeMaster are 32-bit programs. That means they can only allocate 2GB of available memory, regardless of whether they run on a 32-bit or 64-bit operating system. The Platinum SQL software can be configured to allocate additional memory beyond the 2GB limit for caching, and larger firms will often require more than 2GB of memory allocation to cache their commonly used data and index files. Since Platinum SQL is a 64-bit program, it can access memory on the 64-bit server beyond the 2GB limit, which means it can cache more of your data, thus improving the performance of accelerated reports and filtering! Utilities for monitoring server usage and performance are included with the software, allowing you to determine the effectiveness of your cache settings.

Get maximum data security with Platinum SQL! Platinum SQL allows you to encrypt the Tabs3 and PracticeMaster data, providing your data with an extra layer of security. Platinum SQL software uses the 256-bit Advanced Encryption Standard (AES) to encrypt data. Once data files are encrypted, they can only be read by the Tabs3 and PracticeMaster Platinum SQL software.

Platinum SQL also includes the Platinum SQL Server, which maintains a set of SQL tables linked to your Tabs3 and PracticeMaster data. To allow access to these SQL tables, Platinum SQL includes 32-bit and 64-bit SQL ODBC drivers, which allow you to write custom reports in both 64-bit and 32-bit programs (e.g., Crystal Reports and Microsoft Excel 2010 64-bit Edition) as well as OLE DB compatible software (e.g., Microsoft SQL Server) using SQL queries. Furthermore, these queries are processed directly at the server, which improves performance and reduces network traffic. Not only is the SQL ODBC driver included in the Platinum SQL package, but you also receive a firm-wide license for it! This allows multiple users to access SQL ODBC without having to purchase additional licenses. Manager-level SQL access rights can be assigned for each system in System Configuration, allowing you to grant SQL access to only those who need it.

With faster speeds, data encryption, enhanced ODBC capabilities, and the added ability to run SQL queries, Platinum SQL is the ideal solution for any firm that wants to enhance their performance, security, and/or take customized reporting to the next level.

To order the Platinum SQL software for your firm, contact your local reseller and consultant, or call our Sales Department at (402) 419-2200. An overview of the Platinum SQL software is also provided in our Knowledge Base at support.Tabs3.com in KB Article R11417, “Platinum SQL Overview.”