After you have noted system requirements for installation of Adeptia Connect, you must fulfill the following requirements for seamless deployment of Adeptia Connect within your production and the non-production environment.
For Windows
- For installation
- Set up two databases to host Adeptia Backend and Log database.
- The database must be accessible through TCP/IP. The port must be fixed and opened.
Ensure that you have below permissions of Database for Adeptia Backend and Log database.
Database
Required Permission
MySQL
Ensure that you have permission to SELECT, CREATE, DROP, INDEX, ALTER, INSERT, UPDATE, DELETE, REFERENCES, CREATE ROUTINE, ALTER ROUTINE, and EXECUTE for MySQL Database.
Oracle Ensure that you have permission to CREATE SESSION, CREATE TABLE, CREATE ANY TABLE, ALTER ANY TABLE, DROP ANY TABLE, DELETE ANY TABLE, SELECT ANY TABLE, UPDATE ANY TABLE, INSERT ANY TABLE, CREATE ANY INDEX, ALTER ANY INDEX, DROP ANY INDEX,CREATE PROCEDURE, CREATE ANY PROCEDURE, ALTER ANY PROCEDURE, DROP ANY PROCEDURE, and EXECUTE ANY PROCEDURE for Oracle Database.
SQL Server
Ensure that you have permission to CREATE TABLE, ADD COLUMN, CREATE INDEX, DROP COLUMN, DROP INDEX, DROP TABLE, CREATE PROCEDURE, ALTER PROCEDURE, EXECUTE, and DROP PROCEDURE for SQL Server Database.
- If the user account created in MSSQL, then it must use SQL authentication mode.
- Access to the database server where Adeptia Backend and Log database tables can be configured using the user account created in the previous step.
- Administrator rights on the server where Adeptia application will be installed.
- Only for Clustering: All AIS nodes (components of the Adeptia application) must have read/write access to RAID shared drive without login credentials.
- Make sure that the shared folder is encrypted. To know how to encrypt a folder, follow the link:
https://msdn.microsoft.com/en-us/library/dd163562.aspx - Port 1098 and 21000 to be opened in all AIS nodes for communication among them.
- Make sure that the shared folder is encrypted. To know how to encrypt a folder, follow the link:
- Setup and configure an internal and external load balancer as per the deployment diagram.
- The Security certificate to be installed on the internal and external load balancer can be either CA-signed or self-signed, however, we recommend a CA-signed certificate.
HTTP/HTTPS port (80/443) to be opened for an inbound request to the DMZ from the external environment.
In case, you are using default application ports then open these ports for HTTP/HTTPS (8088/8843).HTTP/HTTPS port (80/443) to be opened for the inbound request to the private network from the DMZ.
In case, you are using default application ports then open these ports for HTTP/HTTPS (8080/8443).- Windows firewall from all instances must be turned OFF.
- One email account with SMTP address details used for sending notifications from the Adeptia application.
- Whitelist https://connect.adeptia.com in the firewall for incoming and outgoing traffic for using business applications such as Quickbooks, Salesforce, or any other.
- Maintain a replica of the database and shared drives you are using. This is necessary if you are setting a disaster recovery environment.
For Linux
- For installation
- Set up two databases to host Adeptia Backend and Log database.
- The database must be accessible through TCP/IP. The port must be fixed and opened.
Ensure that you have below permissions of Database for Adeptia Backend and Log database.
Database
Required Permission
MySQL
Ensure that you have permission to SELECT, CREATE, DROP, INDEX, ALTER, INSERT, UPDATE, DELETE, REFERENCES, CREATE ROUTINE, ALTER ROUTINE, and EXECUTE for MySQL Database.
Oracle Ensure that you have permission to CREATE SESSION, CREATE TABLE, CREATE ANY TABLE, ALTER ANY TABLE, DROP ANY TABLE, DELETE ANY TABLE, SELECT ANY TABLE, UPDATE ANY TABLE, INSERT ANY TABLE, CREATE ANY INDEX, ALTER ANY INDEX, DROP ANY INDEX,CREATE PROCEDURE, CREATE ANY PROCEDURE, ALTER ANY PROCEDURE, DROP ANY PROCEDURE, and EXECUTE ANY PROCEDURE for Oracle Database.
SQL Server
Ensure that you have permission to CREATE TABLE, ADD COLUMN, CREATE INDEX, DROP COLUMN, DROP INDEX, DROP TABLE, CREATE PROCEDURE, ALTER PROCEDURE, EXECUTE, and DROP PROCEDURE for SQL Server Database.
- Root user rights on the server where Adeptia application will be installed.
- Only for Clustering: All AIS nodes (components of the Adeptia application) must have read/write access to RAID shared drive without login credentials.
- Make sure that the shared directory is encrypted.
- Port 1098 and 21000 to be opened in all AIS nodes for communication among them.
- Setup and configure an internal and external load balancer as per the deployment diagram.
- The Security certificate to be installed on the internal and external load balancer can be either CA-signed or self-signed, however, we recommend a CA-signed certificate.
- HTTPS port 443 to be opened for an inbound request to the DMZ from the external environment.
- HTTP/HTTPS (80/443) port to be opened for the inbound request to the private network from the DMZ.
- One email account with SMTP address details used for sending notifications from the Adeptia application.
- Whitelist https://connect.adeptia.com in the firewall for incoming and outgoing traffic for using business applications such as Quickbooks, Salesforce, or any other.
- Maintain a replica of the database and shared drives you are using. This is necessary if you are setting a disaster recovery environment.
Next Step