Technical specifications:
The DATABASICS remote agent is a Java Application that runs on the Windows Operating System as a Windows Service. It is used to retrieve data from the remote database and upload files or an XML string back to DATABASICS in order to refresh the DATABASICS WBS or OBS tables passed on the profile configuration. It connects from the local server to the DATABASICS application over HTTPS in order to check for profile requests to execute
Each DBRemoteAgent will have Agent ID and a Hash Key produced and configured on the DATABASICS application and then assigned to the DBRemoteAgent to allow the agent to communicate with the DATABASICS application.
Requirements:
- JDK 1.8 and higher
- HTTPS(443) port open on the server for outbound connections
- SQL JDBC connection to the database server to access Tables or Views that are mapped to DATABASICS. Read-Only access to the database is required.
- Windows Server 2008-2012 and higher