Welcome to the Exact Product Blog

On this blog we will cover stories from all around the Exact ecosystem.

Posts Tagged ‘SQL Server’

Support for MS SQL Server 2005 will be discontinued as of product update 413 and 258

Written by Michiel van Rooijen on . Posted in Exact Globe, Exact Synergy

Exact’s system requirements follow Microsoft Support Lifecycle Policy for those Microsoft products which are required for Exact Globe, Exact Synergy and Exact Synergy Enterprise.

Microsoft stops the support for Microsoft SQL Server 2005 in April 2016. For the next product updates 412 and 257 (expected in the third quarter of 2016), we will still support Microsoft SQL Server 2005. As of product update 413 and 258 (expected in the first quarter of 2017) we will stop supporting Microsoft SQL Server 2005.

We expect to support Microsoft SQL Server 2016 from the first product updates of Exact Globe and Exact Synergy Enterprise after Microsoft SQL Server 2016 will be released.

A complete package of 30 out-of-the-box reports

Written by Michiel Dorjee on . Posted in Exact Synergy

Since the product update 243 and 244 we have been working on integration of SQL Server Reporting Services directly in the Synergy administration. In the product update 245 we went a step further and created 30* ready to use business reports which transform enterprise data into clear information that is crucial for timely and accurate decision making. These out-of-the box reports offer a real time access and clear insight of both Synergy as well as Globe data.

What’s new on the menu for Reporting Services Integration in Synergy?

Written by Michiel Dorjee on . Posted in Exact Synergy

In this blog post I will explain what’s planned for the next product update. Have you read the highlights of Reporting Services Integration which are mentioned in the blog post Empower your key decision-making? Have you seen this video or read the user guide? It will provide you have a clear picture what the possibilities are with Reporting Services Integration in Synergy Enterprise release 243, which is currently available.

Insight in your daily business

Written by Michiel Dorjee on . Posted in Exact Synergy

Let’s start by giving you insight information about myself. My name is Sunil Girdhari and I am now working for Exact more than 8 years. I held several positions from development to sales. Since February 2010 I started in a new role as Product Manager, where my main focus is to empower insight in your daily business processes.

Can we help you?

Written by Michiel Dorjee on . Posted in Exact Synergy

Are you asking yourself if the way you are working and performing your tasks is the most efficient way? And maybe you are not even aware that you can save time and change your approach for certain tasks? We have great news for you! With the reporting functionality available in Exact Synergy Enterprise you can now not only work more efficient, but save time and get a clear insight and overview needed for your daily work. So, tell me how you are doing your work and I will help you to do it more efficient!

How to use drill through SSRS reports in Exact Synergy Enterprise release 243

Written by Michiel Dorjee on . Posted in Exact Synergy

One great feature of SQL Server Reporting Services (SSRS) is the ability to drill through to secondary reports. The advantage is that you can show in one report the summarized high-level information and in the second report the detailed information. This can be realized by adding a drill through action in a report. When designing such an action you would normally select the option “Jump to report“, provide the secondary report and if applicable the required values for the report parameters.

Empower your key decision-making

Written by Michiel Dorjee on . Posted in Exact Synergy

In order to make optimal decisions for your company, you require reporting tailored to your own business priorities and needs. In my previous blog Insight in your daily business I explained how Reporting Services can help you making these key decisions. Reporting Services, part of SQL Server 2005 and higher, is a worldwide known web reporting tool. It enables you to create flexible and graphical web reports. Exact Reporting Services Integration connects these required values into your familiar environment Exact Synergy Enterprise.  Exact Reporting Services Integration centralizes the benefits from both products.

Receive free advice on optimizing your Exact solution

Written by André van de Graaf on . Posted in Exact Globe, Exact Synergy

In 2009 we started developing the Exact System Information (ESI) Tool. With this free tool we can serve you, as one of our valued Exact Globe and Exact Synergy customers, with targeted and personal advice on how to make better use of our software solutions. By advizing you and thousands of other customers, we can also gain better insight in how our software is used; valueable information that enables us to keep improving our solutions. The Exact System Information Tool can be downloaded for free and the file ‘ExactSysInfo.exe’ can be installed by all organizations that use Exact Globe and/or Exact Synergy (Enterprise).  

It is important for you to know what kind of information is exchanged by the ESI Tool. When you use the ESI Tool no company sensitive information will be transferred. Only technical information like usage statistics, logged errors, numbers of records per table, database size and settings will be exchanged. When using the ESI Tool you can see exactly what information is send to us in the CSV file that is placed on your desktop or via menupath ‘Logs, View CSV file’.

Personally, I am very happy to see that a lot of our customers have already used the ESI tool. As of today, the Exact System Information Tool is even extended with the option to receive an automated improvement report per e-mail.

If you specify your e-mail address before pressing the ‘Start Analysis button’, the Exact System Information will analyze your SQL Server and Exact databases. When the analysis is completed you will receive the improvement report within 10 minutes. The report is divided in 2 sections:

1. Server improvements.
The server improvements section is related to your SQL server configurations and answers questions like: Have you installed the latest Service packs? Can you make changes in your SQL Server configuration to make use of all available memory? Etcetera.
 
2. Database improvements.
The database improvements section is related to the database itself and gives advice about new available product updates, clean up of historical journal records, clean up of voided entry record, background jobs, clean up of temporary tables etcetera.

If you have already used the Exact System Information tool in the past, the tool will update itself when you start it up again.

Enjoy using the Exact System Information tool. If you have suggestions for improvements please let me know, as we do not only want to improve our software solutions but also the Exact System Information Tool itself.

Photo credit: cliff1066tm