Why choose Arbutus over the competition? There are many compelling reasons:

1. Multiple tables open at the same time
2. Export to multiple Excel tabs, and other Export options
3. Smart Search
4. Enhanced view capabilities, including triggers
5. Shared Folders
6. Fuzzy Matching
7. Date and Time support
8. Enhanced procedure debugging
9. Enhanced procedure capabilities
10. Read delimited data directly

Want even more reasons to choose Arbutus?
Download: The Arbutus Advantage

1. Multiple tables open at the same time

Click the image to learn more

2. Export to multiple Excel tabs, and other Export options

Arbutus offers the widest range of data export capabilities. For example, you can: 

• Export directly to any database via ODBC
• Export to multiple tabs in Excel spreadsheets
• Create delimited files using any characteristics

Click the image to learn more

3. Smart Search

 

4. Enhanced view capabilities, including triggers

Arbutus Views include powerful new capabilities that allow you to get the most out of your data, including:

• View triggers allow you to highlight individual cells in your data, based on your own criteria/business rules. Each trigger can have its own color (either text or background) and any number of criteria may be specified. You are automatically alerted when your data may need attention
• Quick filter Near allows you to instantly identify all records that are near a selected item. This operates on character field using the Levenshtein distance, or on numeric fields or date fields by finding values close to the selected item
• Thin filter optimization dramatically improves the performance when viewing data using filters that exclude most records, resulting in a much smoother behaviour. This allows you to quickly identify the valuable data nuggets without worrying about performance
• Page-up Page-down visualization provides a whole new screen of data when you use the Page-up/down keys, even when the current filter selects only a small fraction of records. This allows you to navigate your data in a natural way, regardless of how restrictive your filter is
• Related and computed fields may now be distinctly identified in the View. The colors are customizable, and allow easy identification of non-physical fields

Click the images to learn more
 

5. Shared Folders

Arbutus allows any objects to be shared, from tables to procedures, views, or any of the other object types. Shared Folders allow any number of projects or users to share the same object definition, which dramatically eases the administration costs associated with deployment across groups of users. Some capabilities that are enabled by Shared Folders include:

• Share common tables, ensuring that all users share the same definition, as well as minimizing the difficulty of editing or adding to the set
• Share common procedures, ensuring that these can easily be accessed by all users. This shared storage location minimizes deployment issues related to add/change/delete of procedures
• Shared procedures automatically appear on the menus, maximizing accessibility

6. Fuzzy matching 

Arbutus features more powerful fuzzy matching capabilities than any other audit tool. These can be used for data harmonization or de-duplication, cost recovery/duplicate payments, security matches between systems, and identifying similarities for any analytic purpose, such as testing data quality. 

Unique Arbutus fuzzy capabilities include:

• Normalize function automatically eliminates most common differences when comparing names or addresses. This allows the strings "#200 - 1234 Main Street" and "200-1234 MAIN ST." to match exactly ("200 1234 MAIN ST") with no fuzzy required. Normalization automatically addresses capitalization, punctuation, and more. Also, integrated substitution tables allow whole-word substitutions of any number of common abbreviations and misspellings (i.e., Avenue, Ave., Av,. …), standardizing on a single value. Request our free ‘Common Address Typos Substitution Table'
• SortNormalize function takes Normalize one step further, arranging the normalized words in order. So strings as different as "#200 - 1234 Main Street West" and "1234 W MAIN ST, Suite 200" can match exactly
• Compact function removes extra blanks in the middle of a field, improving the comparability of user-entered data
• Arrange function eliminates differences due to transpositions, by sorting the characters in a field, so "604 437 7872" becomes "8777644320"
• SQL-type Many-to-Many Join allows broad matching comparisons, such as Same-Same-Near, Same-Near-Near
• Difference function calculates the Damerau-Levenshtein difference for string comparisons. This is significantly better that straight Levenshtein, as it treats character transpositions (i.e., 123456 vs. 124356) as just a single difference, not 2, significantly reducing false positives
• Near function identifies ‘close’ items for any type of data. This uses Damerau-Levenshtein for character fields, but can also be used to identify close dates and amounts

Click the image to learn more

10. Read delimited data directly

Click the image to learn more

.