Autotask provides an IT business management tool that combines RMM, service desk, CRM, projects, time, billing, reporting, and more. It has the ability to integrate all the features you may need to meet your specific business requirements.
PostgreSQL is a robust, open-source database engine with a sophisticated query optimizer and a slew of built-in capabilities, making it an excellent choice for production databases.PostgreSQL Integrations
Autotask + PostgreSQLUpdate Row in PostgreSQL when New Account is created in Autotask Read More...
Autotask + PostgreSQLCreate Row to PostgreSQL from New or Updated Contact in Autotask Read More...
Autotask + PostgreSQLUpdate Row in PostgreSQL when New or Updated Contact is created in Autotask Read More...
It's easy to connect Autotask + PostgreSQL without coding knowledge. Start creating your own business flow.
Triggers whenever a new Account is added.
Triggers whenever a new appointments is added.
Triggers when a new Configuration Item is found.
Triggers whenever a new holiday is added.
Triggers whenever a new invoice is added.
Triggers whenever a new item/service is added.
Triggers whenever a new opportunity is added.
Triggers when a new Project is found.
Triggers when a new Task is found.
Triggers when a new Ticket is found.
Triggers when a new Time Entry is found.
Triggers whenever a new account todos is added.
Triggers whenever a new or updated Contact is found.
Triggers when a ticket note is updated or created.
Trigger if a service call was created/setup
Triggers when an Account is updated.
Triggers when a updated task is found.
Triggers when a ticket is updated.
Triggers when a Time Entry is updated.
Triggered when you add a new column.
Triggered when you add a new row.
Triggered when new rows are returned from a custom query that you provide. Advanced Users Only
Creates an account.
Creates an appointment.
Creates a contact.
Creates a opportunity.
Creates a ticket.
Creates a ticket note.
Creates a Time Entry.
Creates a ToDo.
Updates an opportunity.
Updates a ticket.
Adds a new row.
Updates an existing row.
Autotask Corporation is a software company that specializes in creating business management software for the automotive industry. The company was founded in 1985 with the goal of streamlining the communication between the service and sales departments of an auto dealership. Over the years, Autotask has expanded its product line to include software used by other industries as well as several software development tools. One of Autotask's products is Autotask PSA, a cloud-based platform that is used by small businesses for automating business processes and managing their operations. Autotask PSA includes modules for accounting, CRM, sales, service management, marketing automation, inventory, and reporting.Autotask PSA is built on PostgreSQL, an open source relational database management system (RDBMS. which runs on Linux, Windows, and Mac OS X. PostgreSQL is popular among organizations that want to have control over their databases and are not comfortable with licensing restrictions imposed by commercial RDBMS vendors. It is reliable, scalable, and comes with multiple language bindings. PostgreSQL is also widely used in high-performance database applications such as signal processing and statistical modelling.Autotask Corporation introduced Autotask PSA version 10 in 2017 with support for Microsoft Azure infrastructure. This release included integration with PostgreSQL, which was intended to help users manage data locally when using Autotask PSA on Microsoft Azure.Autotask Corporation also develops Autotask High Availability (HA), a tool that uses PostgreSQL for high availability and disaster recovery.
As stated earlier, Autotask introduced Autotask PSA version 10 in 2017 with support for Microsoft Azure infrastructure. What's noteworthy about this release is its integration with PostgreSQL. This integration helps customers who deploy Autotask PSA on Microsoft Azure to avoid the risks of relying solely on Microsoft SQL Server or Azure SQL Database. Autotask recommends deploying Autotask PSA on Microsoft Azure using PostgreSQL instead of SQL Server or Azure SQL Database in order to achieve an enterprise-class solution at lower cost and with greater flexibility.The following diagram shows how Autotask integrates with PostgreSQL:PostgreSQL will be installed on each Autotask server that needs to connect to a single database cluster. This server will then connect to the database cluster through port 5433. Each Autotask server must have a PostgreSQL user account created for it before it can connect to the database cluster. In order to create a PostgreSQL user account for an Autotask server, the user must log into the server as root or administrator and add the following line to /etc/postgresql/10/main/pg_hba.conf . host all all 0 .0 .0 .0 / 0 md5 The above line should be added outside any existing "host" block under the "[pg_hba]" heading. After adding this line to pg_hba.conf , the user should save the file and restart the PostgreSQL service for the change to take effect. Note that after making this change, remote connections will be allowed only from localhost and 127.0.0.1 via TCP/IP port 5433.Autotask PSA stores its data in /var/lib/psa/data by default. Autotask suggests installing PostgreSQL binaries in /opt/postgresql/10/bin on each Autotask server where PostgreSQL will be installed. The installation directory should be shared across servers so that each server can access the shared directory from its local disks. Each server will then access its own instance of PostgreSQL by using this shared directory. Once this directory is shared across servers, Autotask can copy its data directory from one server to another using rsync -avz /var/lib/psa/data <destination> . Each server should also have a public IP address assigned to it so that other servers can connect to it using TCP/IP port 5432. AutoTask recommends creating a master-slave database cluster where each slave connects to a master instance of PostgreSQL over TCP/IP port 5433 using SSL encryption (requires installing PostgreSQL client libraries on each Autotask server.Autotask recommends configuring 2 GB of RAM for each instance of PostgreSQL running on Microsoft Azure virtual machines with Premium Storage. If you are using Standard Storage or running PostgreSQL instances on non-virtual hardware, you can reduce the memory requirement to 512 MB per instance. The following diagram shows how much memory was allocated for each component when running an instance of Autotask PSA on Microsoft Azure using a 4 GB virtual machine:
Autotask's integration with PostgreSQL helps companies achieve the following benefits:Cost reduction – Companies save money by using PostgreSQL instead of commercial RDBMS vendors' products that may require hefty licensing fees. Flexibility – Companies gain flexibility because they can use any compatible database server while maintaining data integrity across platforms. Scalability – Companies can grow their database infrastructure without having to invest in additional licenses or additional hardware if they decide to migrate from a smaller database cluster to a bigger one. Reliability – Companies enjoy enhanced reliability because they can run their databases in-house rather than relying on cloud hosting providers' services.As we have seen, Autotask's integration with PostgreSQL improves the reliability and scalability of applications deployed on Microsoft Azure infrastructure while reducing costs and improving flexibility. I hope you enjoyed this post! Don't forget to subscribe if you don't want to miss new posts!
The process to integrate Autotask and PostgreSQL may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick solution to help you automate your workflows. Click on the button below to begin.