JungleMail | Configuring SQL database storage (exclusive to Enterprise)
When using JungleMail for SharePoint , storing all your email records can cause performance degradation. You can increase your sending speed and improve user experience by activating the SQL Database storage for JungleMail.
JungleMail Standard and Pro editions use SharePoint lists to store link records and tracking information for every single email sent. This means that, when JungleMail is used frequently, a lot of records will be created in these SharePoint lists. To illustrate: if your campaign was sent to 1000 recipients and contained 5 links, a whooping total of 6000 records will be generated even before any user actions occur. (1000 to track email opens and 5000 to track link clicks). This large amount of records can impact JungleMail's and SharePoint's performances overall.
That is why JungleMail Enterprise edition was designed to work around this. To do this, and improve its performance, Enterprise stores tracking and history records into an SQL database. In this tutorial you will learn how to enable and configure an SQL Database with JungleMail.
Note:This feature is only available in JungleMail Enterprise Edition.
1. Enabling Database storage
To enable Database storage, open your SharePoint Site Settings. In Site Collection Administration click EnovaPoint JungleMail Settings. Now scroll down. At the bottom of the page you will find the SQL Database Storage section. Here can enable or disable data storage in a SQL database.
2. SQL Database Storage Configuration
By clicking Configure SQL Database Storage, you are given the following settings.
Once you have enabled the storage, JungleMail will fill in Database server with the current SQL server name of your SharePoint. If you wish, you can change the server name.
JungleMail will also fill in the Database name with the default value JungleMail_ServerName. You can change the default name to one that fits in with your general administration.
Note: Default authentication (Windows authentication) makes use of the current IIS application pool authentication.
3. Creating a new database and migrating existing data
To create a new database, simply enable the SQL Database Storage. Then enter the correct Database server and Database name. To finish up, check the box for Create new database and click Save:
A new database will now be created:
4. Migrating existing data from default JungleMail lists
If you want to migrate data from the default JungleMail lists, you have the option to this when database is created. To do this you should make sure the boxes for Create new database and Migrate JungleMail History and Tracking data from SharePoint are checked. Once you will click save now, the database will be created and data will automatically be migrated to it.
5. Migrating existing data from customized JungleMail lists
Migrating existing data works a little different when you have customized the JungleMail lists. These lists include JungleMail History, JungleMail Tracker Links and JungleMail Tracker. It is possible, for example, that you have customized these lists by adding columns. In case you want to migrate the data, you should first create a new database. Only after you have created the new database should you migrate the data.
Enable SQL storage. However, make sure that Migrate JungleMail History and Tracking data from SharePoint option is unchecked. Now click Save.
Reopen the SQL storage configuration. Now make sure the Migrate JungleMail History and Tracking data from SharePoint option is checked and click Save.
JungleMail will now migrate the data from your SharePoint to your SQL database. The duration of the migration will depend on the size of the lists.
Note: You can also choose not to migrate any of your old data and start with a fresh SQL database.