Welcome to the Exact Product Blog

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

Posts Tagged ‘Exact Integration’

Exact Integration – Resending data

Written by Michiel Dorjee on . Posted in Exact Synergy

Hi all,

When you are using the Exact Integration solution you sometimes want to to re-send your data from Exact Synergy Enterprise to Exact Globe vice versa. As previously stated you can do this in the background monitor by hitting the re-send button for selected messages.

We also supply you with a tool that can re-send your data based on the entities and the ‘date last modified’.

In your installation folder of Exact Integration (p.e. c:\program files\exact software\exact integration\synchronization framework\bin) you can start up an executable called SendToQueue.exe. This tool allows you to select the entity that you want to re-send and from which date.

This tool makes use of the Integration solution that uses the Web Services on Exact Synergy Enterprise and Entity Windows Services on Exact Globe to exchange data between the two products.

In the upper part of the screen you enter your connection settings, after pressing the button connect, it will fill your list with entities that are currently supported. These settings will be automatically pre-filled based upon your installation of Exact Integration. Please note that you have to point to the services directory when you use the web address.

In the options section you can either select synchronize from ESE (Exact Synergy Enterprise) to Exact Globe or from EG (Exact Globe) to Exact Synergy Enterprise.

With the date filters you can select your range based on the modified data.

In the entities section you can select the entities you want to re-synchronize. You can set the priority with the buttons on the right side of the selected entitiy. When you press the button ‘Retrieve to queue’ the synchronization will be started. Ultimately on the right you can see the progress of your entities selected.

When you decide to use this tool please bare in mind that it’s best to synchronize entities on an individual basis and that you schedule this outside of business hours so that there is no interference with your normal daily activities. And of course we recommend that you make a backup of your database before you start this process so that you can always go back to the situation you had and you don’t loose any valuable information.

When the process in completed you can view the results in your background monitor.

And for the technical people amongst us, you can also view this on a database level in SQL via the following query.
SELECT ID, StartDate, Source, Destination, Success, Message,
EntityName, Action, PrimaryKey,LogicalKey,TransformationProvider
FROM [esf].dbo.SyncResult
WHERE Message <> ‘echo’
ORDER BY StartDate DESC

Should you have any questions about this solution, do not hesitate to contact me at ruud.aalders@exact.com or add comments to this post.

Exact Integration – Support matrix

Written by Michiel Dorjee on . Posted in Exact Globe, Exact Synergy

Hi All,

Lately I have been receiving questions about the supported versions in combination with Exact Integration. From that perspective I thought it would be good to address that we have documentation on this available to all customers.

The support matrix of Exact Integration is available not only through searching the web, it is also added to your start menu when you install Exact Integration.

Installation menu

The Help link guides you to the support matrix so you can check the supported versions from your computer.

When you are configuring Exact Integration, there is also a link to the support matrix in the configuration screen. In the Help, About Exact Integration menu, you will also be guided to the support matrix.

So, how to continue when you perform an update?

As of release 247 the services are no longer installed through Exact Integration. This means that when you update from 246 to 247 you will need to uninstall Exact Integration first, then perform update of your Exact Synergy Enterprise environment and re-install Exact Integration.

The reason for this is that the msi of Exact Integration for versions lower than 247 will uninstall your services. If you have updated your Exact Synergy Enterprise before uninstalling your Exact Integration, those services will be uninstalled from your environment and the msi for Exact Integration compatible with release 247 will NOT re-install those services.

Therefore the correct order of updating is:
1. Un-install Exact Integration. (This will un-install your services)
2. Update Exact Synergy Enterprise. (This will install those services)
3. Install the 247 version of Exact Integration. (It assumes that the services are already installed through Exact Synergy Enterprise)

Should you have any questions about this solution, do not hesitate to contact me at ruud.aalders@exact.com or add comments to this post.

Exact Globe product update 402 is generally available

Written by Richard Smits on . Posted in Exact Globe

As of today, Exact Globe product update 402 is generally available which marks the end of controlled release period which started in the end of August.

With our customers in mind, we have extended Exact Globe with features that make it easier for them to fulfill legal requirements and business standards, such as taxation changes for Germany, Switzerland and Thailand as well as reporting features in Vietnamese Accounting Standards.

 Exact Globe product update 402 also introduces the Exact Visual Scheduler to facilitate the work of the production planner in a manufacturing company. It gives you a visual insight in your schedule and reduces the time spent in rescheduling operations. Production orders can be scheduled automatically using finite or infinite capacity. It is easy to spot capacity overload or to see if there is still room to maneuver. You can easily reschedule operations by dragging and dropping an individual operation or sequence of operations. The dates in the underlying operations are changed immediately, as the Exact Visual Scheduler is fully integrated into Exact Globe. This will significantly reduce time spent in handling production order changes, especially when working with suborders. Control of your schedule will furthermore improve control over material flows. Please note that the Exact Visual Scheduler is currently in extended controlled release (video).

As of this product update the functionality of SKU Management is in extended controlled release. SKU Management lets you tag a stock unit in your warehouse with an unique number (video). Also the Exact Integration which is generally available as of August, has new features in this product update, such as supporting the batch update of items and restoring database. To follow the previous announcements in which we introduced Central Master Data Management that supports accounts and items, as of this product update you can centrally manage General Ledgers between Exact Globe and Exact Synergy Enterprise (video).

Based on our customers’ needs we have implemented in this product update, among others, the following new features:

A full overview of all new functionalities you can find in the release notes and some additional information on the Product Update News page. Please also refer to previous articles on the Product Blog.

We would like to thank all customers, partners and colleagues who contributed to this product update.

Should you have any questions regarding this announcement, do not hesitate to comment on this post.

Exact Globe product update 402 in controlled release

Written by Richard Smits on . Posted in Exact Globe

As of today, Exact Globe product update 402 is in controlled release. This new product update is planned to be generally available by the end of September 2011.

In product update 402 we have introduced Exact Visual Scheduler to facilitate work of production planner in manufacturing companies. The Exact Visual Scheduler helps to make efficient use of the available capacity and improve order performance. It is fully integrated into Exact Globe as a standard module. 

SKU Management for tagging stock unit is now generally available. Please watch the video, to find out how this feature works in action. Also the Exact Integration which is generally available as of August, has new features in this product update, such as supporting the batch update of items and restoring database. To follow the previous announcements in which we introduced Central Master Data Management that supports accounts and items, as of this product update you can centrally manage General Ledgers between Exact Globe and Exact Synergy Enterprise (video).

We have also extended functionalities that support your legal requirements and business standards with a number of new features, such as taxation changes for GermanySwitzerland and Thailand. Based on our customers needs we have implemented in this product update, among others, the following new features:

For a full overview of all new functionalities, please refer to the release notes for product update 402

Should you have any questions regarding this announcement, please contact Bert Siekmann (Manager Product Management) at bert.siekmann@exact.com.

Exact Integration solutions – Changes in release 251

Written by Michiel Dorjee on . Posted in Exact Globe, Exact Synergy

Hi all,

It has been a while since my last post on exact integration, so what have we been up to all this time?

Besides having done a lot of improvements on the system and services layer of Exact Globe Next and Exact Synergy Enterprise we have also been adjusting the current product and thinking in a larger scope on all of our products that use some form of integration.

On the Exact Interation product we are still ,and will continue to, expanding the repair/migration tools.  For the coming release we have added the following entities to the tool:

  • Bankaccounts
  • General Ledger accounts
  • Item account

Also we have added synchronization of sectors and subsectors into the Exact Integration solution. They will now be synchronized when you create new entries of these or update these entities on either side.

On the topic of services we have created Financial Header and Financial Lines services and we have built a Quotation service, now ready to use to retrieve and create data externally.  You can view the technical reference for Exact Synergy Enterprise webservices here and the Exact Globe Next entity services you can view here.

A different solution, but closely related, is our Central Master Data Mangement solution. In this release we have changed the behaviour of the Parent-Child synchronization between Exact Synergy Enterprise and Exact Globe. The link between parent and child is no longer mandatory to also exist in the division. Functionally this means you can have a parent in a different division than your child. When changing the parent from division to division this link will be restored.

As a last related topic I would like to inform you that our Synergy Office Integration solution now supports Office 2013 both 32 and 64 bits. Also the Office 2010 64 bit version is now supported.

Should you have any questions about these solutions, do not hesitate to contact me at ruud.aalders@exact.com or add comments to this post.

Exact Integration – Monitoring integration

Written by Michiel Dorjee on . Posted in Exact Globe, Exact Synergy

Hi all,

Environments are getting more and more complex these days. As a system administrator you see yourself faced with many challenges of keeping important data up to date in all enviroments.

As Exact we have two main products which are many times seen in one enviroment. Exact Synergy Enterprise for your front office, web browser application and Exact Globe as your back office system.

Of course you want to keep your data in line between Exact Globe and Exact Synergy Enterprise and you don’t want to run extensive scripts to keep your data synchronized.

We anticipated this situation and released the product of Exact Integration. This product basically communicates between Exact Synergy Enterprise and Exact Globe, keeping the data aligned.

However, since these are two different products with their own history, often they have their own validation to make sure the individual product data is guaranteed.

As Exact Integration communicates between the two main products the data entered in each system will be validated by both products. And sometimes, data entered into one product does not meet the requirements for the other product.

In order to facilitate in keeping your data entry correct, we have created a background monitor which allows you to see the results of the validation, enabling you to correct this data and keep the data between the products synchronized.

In the System-Report-Background Monitor menu in Exact Synergy Enterprise the administrator can see the results and take action if necessary.

In this monitor you see, besides the failed synchronization, also when your synchronization went well. The results are consolidated from your middleware database that you have created upon installation of Exact Integration.

Should you have any questions about this solution, do not hesitate to contact me at ruud.aalders@exact.com or add comments to this post.

Exact Integration – What’s going on?

Written by Michiel Dorjee on . Posted in Exact Globe, Exact Synergy

Hi all,

It has been around 2 months now that Exact Integration has been released. I am sure you are curious to know what we have been doing in the past 2 months and what our plans are for the near future.

In the recently released Exact Synergy Enterprise 247 we have focused on our customer feedback, but we also implemented some new features.

We have created a monitor that watches your services on your server. So that you don’t get surprises that data is not synchronized because one of your services isn’t running.

As of release 247 it is now possible to restore your database and the databases will be synchronized. In order to realize this, a new service will be installed on your server, the Exact Service Monitor. This service will check your Exact Globe and Exact Synergy Enterprise database as you have defined in your configuration screen.
In your configuration screen you can set the interval (in minutes) on which this service checks for a restore.
This service requires the user credentials given in the configuration since it needs access to your server and database.
However, we were not able to apply restoring of database over a batch update, so it’s very important that you always have a recent back-up of your database.

Furthermore we have provided a small matrix that shows you on what release of Exact Synergy Enterprise and Exact Globe, Exact Integration is supported and what version of Exact Integration you are currently using. This link is available in your startup menu in Windows, as well as in your configuration screen.

On a technical level, all services needed for Exact Integration are now deployed through Exact Synergy Enterprise and Exact Globe installation.

For the coming releases we have plans to merge Central Master Data Management and Exact Integration into one solution, this will enable you to have the extra functionality of Central Master Data Management as well as all the benefits of Exact Integration.

As result, we will be releasing more and more entities on a scenario of multiple databases in the coming year. 

Should you have any questions about this solution, do not hesitate to contact me at ruud.aalders@exact.com or add comments to this post.

 

Exact Synergy Enterprise product update 247 in controlled release

Written by Michiel Dorjee on . Posted in Exact Synergy

As of today, Exact Synergy Enterprise product update 247 is in controlled release. This new product update is planned to be generally available by the end of September 2011.

The main highlights of this product update are as following:

We have also implemented a number of small enhancements based on a direct customer feedback and suggestions, among others:

For a full overview of all new functionalities, please refer to the release notes for product update 247.

Should you have any questions regarding this announcement, please contact Bert Siekmann (Manager Product Management) at bert.siekmann@exact.com.

Exact Integration is generally available

Written by Michiel Dorjee on . Posted in Exact Globe, Exact Synergy

As of this week Exact Integration is generally available which marks the end of the controlled release. Exact Integration is a solution which automatically synchronizes data between Exact Globe and Exact Synergy Enterprise in an integrated scenario.

Thanks to Exact Integration, all the data you save in Exact Globe is also real-time available in Exact Synergy Enterprise and vice versa. With this solution you save time and reduce data inaccuracy, since you only have to enter data once to have it automatically reflected in both Exact Synergy Enterprise and Exact Globe. For example, you can create a customer entry in Exact Synergy Enterprise and afterwards link this customer account to a sales order that you create in Exact Globe. The synchronization happens almost real-time, so within a few seconds the data is in sync.

What does Exact Integration have to offer?

  • It connects one Exact Globe company with one Exact Synergy Enterprise environment; like the integrated scenario Exact Globe – Exact Synergy.
  • It supports numerous entities.
  • It synchronizes changes almost real-time, just a few seconds to sync, depending on the environment you have.
  • It focuses on a replacement for the integrated scenario.

Should you have any questions about this solution, do not hesitate to contact me at ruud.aalders@exact.com.