Key Products

Anchor Software has developed several products used to transform you data, build and maintain a relational database, and access your finished database!

All Anchor Software is developed using ODBC (Open Database Connectivity) standards and is commercially available should you decide to bring your marketing database in-house!

If you would like to read more about any of the below products, simply click on the product name. If you would like a printable brochure, click on the Features and Benefits... link that follows each product.

MaxConvert™

Let’s face it; no two data files are alike! Standards for capturing name and address data vary from file to file. Code fields such as Gender never use the same codes.

Any successful database begins and ends with clean, standardized and normalized data. MaxConvert™ is the answer! Click the link above to see how MaxConvert™ can cleanse your data.

Features and Benefits...

DatabaseWizard™

Anchor’s proprietary system for creating and updating relational databases, identifying duplicate records and consolidating sub-level table data. The flexibility and power of DatabaseWizard™ permits Anchor to deliver updated databases in an extremely short time frame.

Features and Benefits...

DatabaseInsight™

Do you want on-line and immediate access to your database? Don’t want to bust your budget on an expensive, hard to use access package? Your marketing staff doesn’t know how to program queries?

Not a problem. DatabaseInsight™ is designed for non-programming marketing staff that allows them to easily and quickly submit queries to the database themselves. No more waiting for programming staff! No more detailed instructions to your IS staff!

Features and Benefits...

Sybase Adaptive Server IQ™

For databases that Anchor maintains in-house, we have selected Sybase Adaptive Server IQ as our database platform primarily for its superior performance. Adaptive Server IQ offers significant query performance (up to 100 times faster) than traditional Relational Database Management Systems (RDBMS).

Sybase Adaptive Server IQ supports many ODBC third party software applications in addition to DatabaseInsight™. At present, Sybase has tested and approved the following PC applications for use with Adaptive Server IQ:

MaxConvert™

Individual names in the company field?

Need to parse your name fields?

Do you have multiple address lines and don’t know which is the primary address?

The most difficult aspect of building a marketing database is standardizing and normalizing data supplied by legacy systems or third parties. MaxConvert™ standardizes your data in preparation for inclusion in the marketing database.

Do your records look like this?

Name:	Mr. Adolpho C Fermaint
Address 1:	General Manager
Address 2:	Delta Maintenance
Address 3:	7632 Bowles Road
Address 4:	PO Box 3942
City, ST, Zip	Agawam, MA 01002-3942

Or this?

Name:	Delta Maintenance
Address 1:	Mr. Adolpho C Fermaint
Address 2:	General Manager
Address 3:	PO Box 3942
Address 4:	7632 Bowles Road
City, ST, Zip	Agawam, MA 01002-3942

MaxConvert™ will turn those records into this!

Prefix:	Mr.
First Name:	Alolpho
Middle Initial:	C
Last Name:	Fermaint
Suffix:
Gender:	M
Prof. Title:	General Manager
Company:	Delta Maintenance
Primary Address:	7632 Bowles Road
Secondary Address:	PO Box 3942
City:	Agawam
State:	MA
Zip	01002
Zip+4	3942

MaxConvert™ has the capability to convert multiple file layouts to a standard or custom format. It includes the following features:

Convert up to 5 input files into a common output structure in a single pass!

Interrogates name and address fields (up to 6 Address lines) to parse company names, individual names, professional titles, primary addresses and secondary addresses into standardized fields on output!

Standardize address-related data based on USPS Publication 28 requirements!

Apply gender codes to records with individual names!

Conditional or unconditional replacement or insertion of data!

User defined frequency distributions and data validation on all input fields!

Normalize non-address data into common coding structures!

Reformat consumer or business files, enhance and analyze output files and prepare them for further data processing — all on a PC platform

DatabaseWizard™

Do you need to identify individuals in a household?

Are there multiple individuals at a company purchasing individually so you can’t evaluate the companies value?

Does your data or order entry system create duplicate records?

What is DatabaseWizard™?

DatabaseWizard™ is a PC based application for managing relational databases. The flexibility and power of DatabaseWizard™ permits Anchor to deliver updated databases in an extremely short time frame.

DatabaseWizard™ allows us to build, link, and maintain multiple tables including primary and sub level tables, reference tables, and data dictionaries. It’s core capabilities are:

• Create field-by-field parameters for updating records!

• Identify and pack duplicate records from the database!

• Accurately consolidate sub-level table data to ensure a complete view of the customer!
• Build a "best" record for survival in the database!

Updating the marketing database .

DatabaseWizard™ will allow for complete table replacements or unique key updates. A unique key update will allow for transactional files to be added to the initial database without recreating existing records from previous updates. Each unique key update defines field specific actions for each column in the affected tables. For example: if the existing record on the database has a more deliverable address, you would not want to update your address fields with data supplied in the transaction file.

Identifying duplicates contacts in the database .

A proprietary multiple image matching logic to identify duplicate records at either an individual or household level is incorporated within DatabaseWizard™. The matching logic allows for complete flexibility on what data elements can be included in the data comparison. Any data elements on the table such as; name, company name, address, telephone numbers, Customer ID, Gender, Social Security #, etc. may be included in the duplicate identification process. This allows us to go beyond name and address comparison to incorporate any additional data that may aid in determining matches.

Develop Household or Business Site tables .

The flexible matching logic allows DBS to identify and summarize records at a household (consumer databases) or business (b-to-b) level within a single database structure. You’ll be able to maintain multiple contact records within your household or business and summarize purchasing, promotional and demographic data to the household or business.

Maintain the integrity of your sublevel tables .

Once duplicate records are identified, each of the individual records are flagged with Anchor generated coding. Sample duplicate and unique records are output for review.

Utilizing the Anchor coding and relationship data, DatabaseWizard™ will then search for and consolidate all sub-level table records that are associated with the identified duplicates into the remaining unique record.

DatabaseInsight™

So you’ve built your database but how do you get information from it?

Are you tired of waiting weeks for the IS department to get back to you with your count request?

Do you need to modify your request many times before you get an acceptable result?

Don’t know anything about SQL programming?

Then DatabaseInsight™ is the product for you!

Anchor’s user-friendly software was designed for the non-technical marketing person who needs to query a database until the desired result is found. Fully windows compatible, it’s point & click capability allows the user to build intelligent SQL queries without any SQL programming knowledge.

Marketers and analysts alike can query the database to profile customers, understand purchasing patterns and recognize cross-sell opportunities. It seamlessly integrates with standard spreadsheet applications Lotus and Excel.

For users proficient in SQL, DatabaseInsight™ provides an interactive window to allow the user to write their own SQL query.

DatabaseInsight™ was developed on an "open platform" making it compatible with most RDMS engines such as Oracle and Sybase.

When Anchor is maintaining your database, DatabaseInsight™ provides query responses in seconds!

Key functionality of DatabaseInsight™ .

• Segmentation
  Target your market by selecting and/or suppressing on key criteria.

• Cross-Tabulation
  Profile customers by comparing values within the database to each other and creating a matrix.

• Frequency Distribution
  Quantify, count and verify data on the database or in segments

• Database Browse
  See your results by viewing the actual data selected by your query.

Key features of DatabaseInsight™ .

• Easy to use
  Designed for marketing professionals who are not technology experts, it allows them to satisfy sophisticated marketing queries, analyze their data and create graphics through standard spreadsheet products.

• Ad-hoc reporting
  Seamless integration with standard Excel and Lotus allows the end-user to produce high quality reports and presentations based on information obtained from a query.

• Windows-based application
  It utilizes all of the standard Windows capabilities such as "drag and drop" so as not to add unnecessary training time or misunderstanding for a PC literate user.

Allow us to demonstrate this easy-to-use product by calling today for a free demonstration.