Jim Martin
Business Dev Director
SpinSys

Introduction

MDACA suite of applications combines the best-in-class capabilities to give you enhanced insight and control over your data by connecting data from a wide range of locations. 

Server/Collector (Agent) – Connects data across the enterprise to allow for real-time migration and continuous integration of structured and unstructured data.

FOCUS: Gateway/Service Engine – Supports SQL query pass through, data routing, and transformation via a data message hub and proxy server.

SharePoint Connect – Supports SharePoint Farms migration, sync, and usage analytics across the enterprise.

Gateway Service Engine

MDACA Gateway is a high performance, secure, and scalable server with transforms and routes traffic to backend data stores. As a database-firewall, MDACA Gateway enhances the overall security posture by avoiding direct database connections and exposure of sensitive backend endpoint information to external clients and applications. The Gateway’s load balancing and request routing features significantly improve scalability by redistributing the load more efficiently across the backend database cluster.

Flexibility – The MDACA Gateway can be installed on multiple Operating System (OS) environments, on premise or in the Cloud and supports multiple protocols and data stores including Oracle, PostGreSQL, Teradata and RedShift.

Security – Acting as a gatekeeper between the application and data stores, the MDACA Gateway safeguards the backend databases. The proxy automatically encrypts the traffic to and from the database using Transport Layer Security (TLS) 1.2 with a 128-bit Advanced Encryption Standard (AES) cipher.

Container Ready – The MDACA Gateway server can be easily containerized with small-footprint, prebuilt Docker images.

Scalability – By dynamically load balancing the read/write traffic across multiple backend database nodes, the MDACA Gateway adds horizontal scalability to the architecture. Additional processor threads and resources for individual connections can be allocated to improve performance the MDACA Gateway supports thousands of concurrent client connections.

Monitoring – With configurable timeouts and health check monitoring, the MDACA Gateway can quickly detect backend connection failures and re-route traffic to healthy nodes. The service constantly monitors client and backend connections and collects real-time throughput and response time metrics.

Conclusion 

MDACA suite of applications provides enhanced insight and control over your information. By connecting data from a wide range of locations, MDACA is able to collect data, improve scalability, and move quickly across major sources to better serve your organization.