Connect Sage 300 CRE (Timberline) to SQL!

Sync Sage 300 CRE data to a SQL database

EVERY MODULE AND EVERY FOLDER

Used by many of Sage 300’s largest customers to migrate from Pervasive.

Sync fast — continuously or scheduled

UNLIMITED AMOUNTS OF DATA

No new server required, no solid-state drives required.

Empower your team to do virtually anything

MINE YOUR OWN DATA

Combine data from archived and current files on reports.

anterraDataCenter™

General Questions

anterraDataCenter™ was developed in 2004 by Circle Software and was called CircleDataCenter. The same staff that designed and built the product at Circle are now at Anterra and have been continuously supporting the product since it was created.

anterraDataCenter™ has 4 levels – Starter, Standard, Professional and Enterprise. The levels relate to the number of gigabytes of Sage Timberline Office data you have. Contact us if you would like a price quote or assistance in determining your amount of data.

Yes!! All of your existing Crystal reports that work with Sage Timberline Office data will work with the SQL database. You need to change the data connection to point the report at your SQL database and may have to change a few date formats.

It usually takes 30 to 45 minutes to set up an evaluation copy. Your first synchronization will take about an hour per gigabyte of data, a full daily update usually takes about 10-12 minutes.

Data Synchronization

All Sage Timberline Office data is synchonized to SQL. This includes all of the accounting modules (GL, JC, AP, PR, AR, BL, CN, CM, EQ, PJ and PM) plus all additional modules (Service Management, Purchasing and Inventory).

Most clients complete daily updates, this takes 10 to 12 minutes. Typical table groups update in a couple of minutes.

No, only data that has been changed since the last update is synchronized. anterraDataCenter self reconciles to ensure all data tables in SQL align with the Pervasive data folders.

Data is synchronized on a scheduled basis, on a continual basis or an icon can be set up on a user’s desktop to run on demand. You can synchronize all data or create groups of tables that you want to update more frequently.

Installation

We install the software with you, it typically takes 30 to 45 minutes depending on your network set up.

No re-installation is necessary when you purchase the software, we simply send you an active license key.

SQL Questions

Microsoft SQL Server 2019 RC, SQL Server 2017, SQL Server 2016, SQL Server 2016 Express Edition, SQL Server 2014, SQL Server 2014 Express Edition, SQL Server 2012, SQL Server 2012 Express Edition

If you have less than 10 GB of Sage Timberline Office data you can download Microsoft SQL Express – it’s FREE!

Connect Sage 300 CRE to a Microsoft SQL™ database

Empower users

  • Increase complex report speed dramatically. Run reports in seconds from large data files.
  • Connect an Excel spreadsheet to multiple Timberline data folders at one time.
  • Run reports that combine information and results from multiple servers and multiple data folders.
  • Use Crystal or SSRS Reports to publish information to the Sage Timberline Office Desktop, to Microsoft SharePoint™ or to your company’s intranet.

Call us at (832) 539-1400 and press 1 for information or Contact Us for more information.

anterraDataCenter™ Testimonials

”You guys have a fantastic product here. I am loving Anterra. I’ve gotten our AR report down to a 3 second load – from the 6.5 hours that it used to take. Our AP report clocks in even faster, in milliseconds instead of hours. I am also able to create formatted Excel reports in under a minute now, that can be distributed internally and via web.”– Rockford Construction, Michigan

“Within two years of using Timberline, our Timberline database had become too large to report efficiently, diminishing reporting capabilities. anterraDataCenter™ changed all that. Now, not only do our Crystal Reports return data within a small fraction of the time previously required, but the front end SQL Server query capabilities have opened up possibilities for even more powerful and sophisticated reports. For any Timberline user who is serious about getting the most out of their Timberline data, anterraDataCenter™ is a must-have.”– Basco Drywall, California

“What a relief! No more multi-database reporting. The anterraDataCenter™ software tool makes the integration from Pervasive to SQL a non-event. Our employees can now view reports on a web page, utilizing Microsoft SQL Reporting Services, with data from our Timberline data sources. Seamless! What a great tool!”– Lang Masonry Contractors, Inc., Ohio

“Best Timberline add-on we could have bought. It allows us to get data out easily and efficiently to be used in our day-to-day reporting throughout the company. Also, it came through as a backup when our whole Timberline database was wiped out and we had no clean backups”– Burroughs & Chapin, South Carolina