Product Spotlight: Enterprise Data Loader Archiving!
A new Archive event type has been added to the Enterprise Data Loader further extending its utility. This new event type allows you to archive data from your main SQL Server database to a separate archive database keeping the main database smaller and faster. A common use for this would be databases that get large over time
causing slow downs with reports and "full views". For instance, customers can choose to keep only the last 6 months of data in the main database and archive data older than 6 months to a different database.
How to Get It:
- Archive data by age (in months) or by record count (records older than the last 100)
- Choose to either archive (copy) data to another database or simply delete it based on record retention compliance
Archive either all part files dynamically or only some part files per event.
- Create multiple archive events to archive different sets of part files at different levels.
If you already own EDL, simply update to the latest revision and the feature is included. If you would like to find out if EDL is right for your company, download the trial using the link below.
Download EDL 3.3 >>
Want to Learn More?
Sign Up for a Live Demo >>
Prolink to Exhibit at IMTS 2016
Prolink will be showing all our latest software in booth E-5415 in the East (Lakeshore) Building all week. If you plan to be at the show, please stop by and see us.
See our Exhibitor Profile
IMTS - McCormick Place
Sept. 12-17, 2016
Building: East (Lakeshore)
QC-CALC 4.0 Update
While running slightly behind schedule, we're excited to report that QC-CALC 4.0 is near complete in terms of development. We plan to be running an early beta in the booth at IMTS if you would like to see it.
The main change is a complete overhaul to the database back-end of QC-CALC allowing it to run both as a file-based product (same as current) as well as a server-based product
using SQL Server as its database. The benefits of this include improved flexibility, performance, filtering, and a more direct connection to the Enterprise Report Scheduler.
Find out more by visiting us at booth E-5415 at IMTS. Otherwise, expect news on a release date and beta opportunities soon!
Tip: Finding out what happened "yesterday" in ERS
We are asked about this often so it seemed appropriate to add it as a tip to the newsletter. Engineers often want to find out what was measured generally the prior day (or some other time period).
This functionality has been in ERS for a while, but it takes a couple of steps to get the desired result. In order to understand how it is done, you first need to understand how ERS queries the data when you add filters and set up a report. The most important thing to understand is that dimensions are always queried before records. This typically makes sense and is the most efficient because first you narrow down the part numbers and dimensions of interest. Then you filter the records within those files and dimensions based on the record filters added.
The problem comes when you want to ask ERS to give you all parts measured "yesterday". Since "yesterday" is a date filter that is applied at the record level and since ERS always queries dimensions first, it is in the reverse order. In this situation, you need to query records first to find out which ones happened yesterday and then use the results to determine which files and dimensions match those records. Fortunately, there is a dimension filter type that allows you to do this. It is called "Dimension is found in.." and the criteria allows you to specify a record filter. This allows you to create a record filter for yesterday. Then create a dimension filter that specifies all dimensions where "found in" the Yesterday filter.
Rather than make the newsletter extremely long with images, we're including a link to the KB article on our website. This article explains the entire concept with an example and a sample report template you can download and use in your reporting.
Read Entire Article >>
How to Get It:
Download ERS 3.4 >>
Want to Learn More?
Sign up for a live Demo >>