Category Archives: Database

Deleting Report categories of Sage CRM from Backend

Sage CRM’s Report Category makes it easy for users to classify and organize reports in the Report tab. Sage CRM by default provides various Report Categories related to different entities. Also, System Administrator has the provision to create new categories as per the Business. New Stuff: Dynamics 365 CRM – Sage 100 ERP Integration: Changing… Read More »

How to add Custom Entities into the Regarding field of Communication

For every business, communication is the most important aspect that needs to be managed appropriately. As you all know, Sage CRM has helped to manage all the business related chores such as maintaining Customer database, managing Enquires and Opportunities of these customers, logging of service tickets, and scheduling appointments and so on. The communication records… Read More »

Sage CRM 2018 R3: Create a group of Persons who have not responded to a Consent Request

In our earlier blog, we explained about the new feature introduced in Sage CRM 2018 R2 i.e. Consent. It helped to capture the global and local legislation surrounding people data, including the GDPR in Sage CRM. In this blog, we will explain how you can maintain tracking of those persons who haven’t responded to the… Read More »

Information on Database Configurations in Sage CRM

Upon installing Sage CRM apart from selecting the installation path we are required to provide instance name and SQL server connection details to proceed further with installation. Whatever the instance name that we provide upon installation, the installation process will create a database in SQL with same name and required tables in the database. The… Read More »

Merging Person records from Different Companies

This blog is in continuation of my previous blog wherein I have explained the process of Merge Person functionality of Sage CRM. You can refer below link for the same. Related Post: Remove Duplicate records, move data of one Person to another in Sage CRM Though the Merging option has helped to manage data accuracy and… Read More »

Interactive Dashboard refuses to work? This could be related to SQL Server Configuration error

Everyone over here must be very much aware of Sage CRM installation process and its pre-requisites. But if you are facing Sage CRM installation for the first time then, it can be a little daunting. As successful CRM installation process itself determines or say confirms whether you will be facing tomcat related issues or not.… Read More »

Error exporting reports to excel in CRM part 4

As you know we have been writing blogs on issues being faced while extracting reports data in excel and issues related to Dashboards not working. You can go through the links added below for your reference. Related Stuff: Error exporting reports to excel in CRM part 3 Even in today’s blog, we will be discussing… Read More »

How Sage CRM changed Structure of Phone and Email in Sage CRM 7.2

Hi folks! You all must be familiar with the following entities in CRM ”Email”, “Email Link”, “Person” ,“Person Link” ,”phone” and “Phone Link“ table .These are the tables where person’s and company’s communicated related details are saved. But when you want to check one of these details in database for the related company or person… Read More »

Scheduling Backup activity through Sage CRM 2014 R2

For every Business environment, managing/securing data and Disaster management responsibilities goes hand in hand. Backing up data has always been the only recommended solution for recovering data which also proves very profitable. The only risk which is involved is doing this task manually as someone may forget. Scheduling Backup activities is something which has been… Read More »