Page Comparison

1. Set up two databases to host Adeptia Backend backend and Log log database.
2. The database must be accessible through TCP/IP. The port must be fixed and opened.

3. Ensure that you have below database permissions

   of Database

   for Adeptia

   Backend

   backend and

   Log

   log database.

   MySQL

   Database

   Required Permission

   Ensure that you have permission to
   MySQL	SELECT, CREATE, DROP, INDEX, ALTER, INSERT, UPDATE, DELETE, REFERENCES, CREATE ROUTINE, ALTER ROUTINE, and EXECUTE for MySQL

   Database

   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

   database.

   MS SQL

   ServerEnsure that you have permission to

   server

   CREATE TABLE, ADD COLUMN, CREATE INDEX, DROP COLUMN, DROP INDEX, DROP TABLE, CREATE PROCEDURE, ALTER PROCEDURE, EXECUTE, and DROP PROCEDURE for SQL Server

   Database

   database.

   
   

4. If the user account created in MSSQL, then it must use 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 stepin case you are using MS SQL server.
5. Administrator rights on the server where Adeptia application will be installed.
6. Only for Clustering: All AIS nodes (components of the Adeptia application) These below points are applicable only for clustering environment:
   • Connect Server nodes 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 Connect Server nodes for communication among them. 
7. Setup and configure an internal and external load balancer as per the deployment diagram.
   • The Security 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. 
   • Both load balancer should support SSL and SSL must be terminated at load balancer. 

8. 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 the ports for HTTP/HTTPS (8088/8843).

9. 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 the ports for HTTP/HTTPS (8080/8443).

10. Windows

    Ensure that the port mentioned in the step 9 and 10 are whitelisted. If they are not whitelisted then Microsoft Windows firewall from all instances must be turned OFF. 

11. One email account with with SMTP address details (for example, username, account name, password, SMTP address, SMTP port, and SSL information) used for sending notifications from the Adeptia application.
12. Whitelist https://connect.adeptia.com in the firewall for incoming and outgoing traffic for using business applications such as Quickbooks, Salesforce, or any other. 
13. 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

System requirements