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
What do you need to do if I'm DATABASICS Remote Agent on Oracle Java 8?
- Upgrade to a product version that supports OpenJDK (Recommended): The DATABASICS Remote Agent which supports OpenJDK(Example: Zulu). If you don’t want to purchase an Oracle subscription you can upgrade Java to one of the product versions that run on OpenJDK. See Zulu download link below.Zulu Download Link: https://www.azul.com/downloads/zulu-community/
- Stay on an old version of Oracle JDK: We will continue to support any customer using Oracle JDK 8, however, running on Oracle JDK 8 without a subscription will leave you vulnerable to any Java security issues that are identified.
- Get an Oracle Java SE: If you want to continue to get updates and security patches, you'll need to purchase an Oracle Java SE subscription. See Oracle purchase link below. Oracle Java: https://shop.oracle.com/apex/f?p=DSTORE:2:::NO:RIR,RP,2:PROD_HIER_ID:123775488249871532594385