Integrate PostgreSQL with SugarCRM

PostgreSQL is a type of RDBMS. PostgreSQL was developed by Michael Stonebraker and others at the University of California, Berkeley in 1986. In 1994, it introduced support for triggers and stored procedures. In 1995, it introduced extensibility through user-defined types and functions. In 1999, it introduced support for multiple-statement transactions and foreign keys.

According to its website PostgreSQL is “an advanced object-relational database management system.” It is a database of choice for many of the world’s largest organizations including Facebook, IBM, NASA, Oracle, and Red Hat. Having been developed from the ground up over more than 25 years, PostgreSQL has a mature feature set which provides strong guarantees about data integrity, security, and crash-safety. The PostgreSQL community is very active, meeting regularly in person and online to discuss development and new features.

SugarCRM is a sales force automation software, an open source CRM spution. SugarCRM started as a fork of CRM OnDemand by salesforce.com, but has since developed into a completely separate product with a growing set of features and a very active developer community. SugarCRM has a website at https://www.sugarcrm.com/ .

In this section I will illustrate how to integrate PostgreSQL with SugarCRM.

First you need to install PostgreSQL on your local machine as described in the installation guide https://www.sugarcrm.com/support/documentation/installation/configuring-postgresql#installing_postgresql_on_windows_10_mac_os_x_ubuntu_debian

Then download and install SugarCRM as described in the documentation https://www.sugarcrm.com/home/documentation/installation/installation-guide

Next create a database for SugarCRM using the command line top psql or pgAdmin (https://docs.sugarcrm.com/13/pgadmin3/installation/db-iis-installation/. and give permission to use this database to the user that is used by SugarCRM (default is root. This can be done with the fplowing command:

GRANT ALL PRIVILEGES ON DATABASE mydatabase TO 'myuser'@'%' IDENTIFIED BY 'mypassword';

Now we can configure our two products to work together:

On Linux. You must create a new connection that points to the Postgresql database using the hostname and port number as defined in step 1. If you are using localhost as the hostname then the port number is 5432 by default. So if you use localhost as hostname and 5432 as port number then your connection string will be. postgresql+psycopg2://myuser:[email protected]:5432/mydatabase . Or you can setup an alias for localhost so that it uses port 5432 by default. http://stackoverflow.com/questions/1875506/how-to-change-the-local-port-for-postgresql . For example if you want to use port 5433 then you can do it with the fplowing line of code. ALTER DATABASE mydatabase SET LOCAL_PORT = 5433; .

On Windows. You must create a new connection that points to the Postgresql database using the hostname and port number as defined in step 1. If you are using localhost as the hostname then the port number is 5432 by default. So if you use localhost as hostname and 5432 as port number then your connection string will be. postgresql://myuser:[email protected]:5432/mydatabase . Or you can setup an alias for localhost so that it uses port 5432 by default. http://stackoverflow.com/questions/1875506/how-to-change-the-local-port-for-postgresql . For example if you want to use port 5433 then you can do it with the fplowing line of code. CREATE USER myuser WITH PASSWORD 'mypassword'; CREATE DATABASE mydatabase; GRANT ALL PRIVILEGES ON DATABASE mydatabase TO myuser; GRANT CONNECT ON DATABASE::mydatabase TO myuser;

The process to integrate PostgreSQL and SugarCRM may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.