Ascent360 has many methods for collecting data securely from our clients. This includes batch SFTP, Webhooks, HTTPS POST, Native API and Web Services. In addition to these, Ascent360 has created a Windows Service, Raptor, that can collect data from any database system located on a windows network. This Article is specific to the Raptor Service.
Raptor Installation Prerequisites
- Software Requirement
- .NET Framework 4.8.
- If server operating system, Windows Server 2008 R2 or higher. If desktop operating system, Windows 7 or higher.
- Can browse to https://webupload.ascent360.com
- Can reach 20.184.240.134
- Underlying database architecture is SQL Server. If not SQL Server, see sections regarding ODBC below.
- Hardware Requirement
- Processor: Minimum 1GHz
- RAM: Minimum 2GB memory available for the application (Raptor Service)
- Disk space: Minimum 5 GB
The .NET 4.8 requirement is especially important to verify before the installation if the machine that Ascent360 is installing the Windows Service on is production-facing. Upgrading the version of .NET requires a full restart of the machine which is not something we can do during the daytime (if the system is production / not a VM).
Installation Process
Installation ranges from 30 minutes to 1 hour. Ascent360 will host a shared meeting and walk through the install process with you and/or your IT Resource.
- Software: Ascent360 has an executable file that will install the Raptor Service. It is available in both 32 bit or 64 bit.
- Permissions: Typically, a SQL reader account needs to be created for Ascent360. This reader account can be limited to a specific set of tables and fields if desired.
Protocols, Processes, and Features
Connection Protocols: ODBC, Native SQL Server Driver, Native Oracle Driver.
Communication Protocol: The Raptor service will transmit data via SFTP or HTTPS. All communications occur using these protocols to ensure all messages and data are secured over an encrypted channel.
Communication Process:
The system runs 3 processes on a .NET timer. These processes include:
- Heartbeat: This process sends a short message to Ascent360 every 30 minutes to simply say that things are “OK”
- Get instructions: This gets new 'instructions' from Ascent360. 'Instructions' can be queries, timings or connection strings.
- Run Queries: This is the key process. This process will run each query that we need in sequential order.
- Typically, our system will run 10 to 30 queries depending on the point of sale (POS) / eCommerce system.
- Hold query result in memory. This system does not create any files or store any data on the disk to ensure security.
- Convert data to XML and stream to Ascent360 via HTTPS (256-SSL or SFTP as noted).
Communication Ports: To transfer data via HTTPS, we will need to have Port 443 open.
Location of the install:
The Ascent360 Raptor Service can be installed on any windows server that has database access, such as the Siriusware or RTP database. Our service will use the SQL reader account to query the database and deliver this data to the Ascent360. In small implementations, the Raptor Service may be installed on the same server as the database. In larger implementations, the service may be installed on another server or even a dedicated server.
32-bit vs 64-bit install:
As the Raptor service is available in both 32 bit and 64 bit version, please refer to the following decision tree to inform which version to use.
In some cases, it is possible that we may be using ODBC drivers if the database is not SQL Server. In that case, ODBC drivers version also needs to be checked to decide which version of Raptor windows service needs to be used.
Timing of Data Transfer:
- Data Transfer: Typically, our clients will choose to send data to Ascent360 once per day. The timing of this can be at the clients request, but is usually done at night. Data can be transferred as often as every 15 minutes.
- Heartbeat: As a matter of quality control and monitoring, our service will send an HTTPS POST “Heartbeat” to Ascent360 every 10 minutes to check-in but it's configurable and can be changed to as low as 1 min.
Auto-Update:
The Ascent360 Raptor Service has the ability to auto-update. This is initiated from Ascent360 as new versions of the Raptor Service are ready to be deployed, no client action is needed. When an update is initiated, the Raptor Service will be given update commands on the next heartbeat and the following steps will be performed:
- Request the installer for the new version and download.
- Create a backup directory of the current installation.
- Verify that no processes (query execution, transmit payload) are currently executing. If so, wait for the next heartbeat to check again.
- Stop the Raptor Service.
- Replace the old Raptor Service with new.
- Start the Raptor Service.
- A fail-back is performed if any issues are encountered in any of the steps above.
- Report back to Ascent360 with success or failure.
