This article discusses a few server requirements that do not fall under hardware/software requirements and covers various options for integration.
Applicable Products: DotActiv Pro, DotActiv Enterprise
Server Requirements
- The server must be able to provide a stable connection to its users.
- The server must be able to access the DotActiv licensing server. Test this here to know if you can connect to the licensing server successfully.
- The DotActiv IT team must be able to access the server on a case by case basis
- In the case of a shared server, we require a dedicated Windows user and service account and a dedicated SQL username and password.
- The server complies with the recommended server hardware specifications in this article.
Options For Integration
DotActiv can run on a dedicated or shared server. With a shared server, ensure that there will be sufficient resources to run the DotActiv application and shared applications. Please note that you will need an instance of MSSQL for the DotActiv database and a terminal server where we can install a backend application for the integration.
The server can be onsite. In that case, it would become part of your existing infrastructure and managed by your IT department. Alternatively, the server can be offsite.
If you cannot host the solution in your network, DotActiv can host the server (on or off the cloud). However, this is limited in resources available as SQL Express limitations apply. And it could cause a change in your contract, but your consultant will be able to assist with this.
You would then be responsible for delivering data via FTP/SFTP and ensure to open firewall connections to allow users to connect to our server from their network.
Please note if you choose to deliver via FTP/SFTP, you will be responsible for the delivery of the files, and the firewall will have to be adjusted to accommodate our ports and the IP so the users can connect. If you do not choose to deliver via FTP/SFTP, the data will need to be imported directly into the DotActiv SQL staging tables by the client (we will provide the credentials for the user login you can connect to the database with). Other processes will require extra discussion around the matter.
Find the answers to all of your questions around database integration here.