# OAK!Merge Reviews
**Vendor:** Kannegiesser ETEC  
**Category:** [Database Management Systems (DBMS)](https://www.g2.com/categories/database-management-systems-dbms)  
**Average Rating:** 5.0/5.0  
**Total Reviews:** 1
## About OAK!Merge
Act! Data Import & Export AddOn




## OAK!Merge Reviews
  ### 1. OAK!Merge Automatic Data Import for Act!

**Rating:** 5.0/5.0 stars

**Reviewed by:** Dave W. | Board of Directors, Computer Software, Small-Business (50 or fewer emp.)

**Reviewed Date:** June 22, 2015

**What do you like best about OAK!Merge?**

OAK!Merge includes and extends Act!'s built-in Company, Contact & Group record importing ability. 
It adds field-by-field data import into Act! Contact Management software program's Opportunity, Activity, History, Products, Users, Company Sub-Divisions and Sub-Groups.
Imports can be run using Windows Task Scheduler using a saved template. 
It is like an Extract Transform Load (ETL) without the E. Extraction should be provided by the data source program (i.e. Accounting or ERP) but the ability to map, transform and then load that data is done very well by OAK!Merge.
Extensive User's Guide with Sample/Practice files many examples and real-life scenarios. 
Several training videos.

**What do you dislike about OAK!Merge?**

No built-in scheduler (must use Windows Task Scheduler). 
Not for average user.
No automatic or prompt for Backup.
Limited training videos.
Cannot update Pictures or Teams / Limited Access Lists.

**Recommendations to others considering OAK!Merge:**

Act!'s import tool is limited to Company, Contact and Group table add, merge or replace the WHOLE RECORD. OM gives you the ability to save the Act! dB login and mapping to an editable template that updates, adds or replaces data by FIELD. So, you can can change an Open opportunity to Closed and/or update the Amount field
If you are a DBA you are going to love this. If you have experience with Excel or Access databases this is an easy transition.
Watch the videos and read the manual for the process you are executing.


**What problems is OAK!Merge solving and how is that benefiting you?**

I am an Act! Consultant and an OAK!Merge re-seller. My clients use it for automatic import of accounting / ERP data into Act! Opportunities.
Expose Hidden Act! UID: I use it to expose the hidden Act! Unique ID's and make it visible in the program. This permits import/export matching on a singe criterion (UID). 
Populate Databases: I also use it to populate databases by importing client data from other programs.
Time-Saving: The ability to save templates means you can re-use them if the criterion is the same or you can save it with a different name and modify it which saves time.


## OAK!Merge Discussions
  - [What is OAK!Merge used for?](https://www.g2.com/discussions/oak-merge-what-is-oak-merge-used-for)
  - [What is OAK!Merge used for?](https://www.g2.com/discussions/what-is-oak-merge-used-for)

- [View OAK!Merge pricing details and edition comparison](https://www.g2.com/products/oak-merge/reviews?section=pricing&secure%5Bexpires_at%5D=2026-05-31+17%3A46%3A07+-0500&secure%5Bsession_id%5D=95e82b30-55f8-416f-b0b3-bbf5d65cfdc2&secure%5Btoken%5D=6a8c47206e1b343cf171b987a47488f4a96de993c465dcc01f6db33735ce23ed&format=llm_user)

## OAK!Merge Features
**Management**
- Data dictionary
- Data Replication
- Query Language
- Data Modeling
- Performance Analysis

**Maintenance**
- Data Migration
- Backup and Recovery
- Multi-User Environment

**Security**
- Data Encryption
- User Access Control

## Top OAK!Merge Alternatives
  - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) - 4.4/5.0 (2,123 reviews)
  - [SAS Viya](https://www.g2.com/products/sas-sas-viya/reviews) - 4.3/5.0 (755 reviews)
  - [Databricks](https://www.g2.com/products/databricks/reviews) - 4.6/5.0 (761 reviews)