Overview

What is Colrows

Colrows stands as the pinnacle of secure data fabric, enabling comprehensive data exploration across diverse data sources such as relational databases, NoSQL databases, in-memory caches, and files, all while ensuring utmost data security. Placing data security as its top priority, Colrows strives to centralize data authorization decisions across applications and data transports.

Colrows

Colrows ensures organizations with peace of mind regarding data security as they promote a data-driven culture by sharing data openly. It enables organizations to concentrate on deriving value from their data more swiftly while adhering to various data security compliance requirements. Some of the key features are listed below.

Key Features

  • Unified Data Access Controls - Colrows provides advanced and comprehensive data security functionalities across a wide range of data sources. Through Colrows, data security policies can be centralized for nearly all scenarios, ensuring consistent and straightforward access management.

  • Intelligent SQL Editor - Colrows provides a new age smart SQL Editor which boosts developer productivity significantly. In a single editor, developer can connect to a myriad of data sources unifying the overall experience.

  • RestSource - Utilizing Colrows RestSource, a data query can be promptly transformed into a REST Endpoint. These REST Endpoints leverage the robust clustering, high availability, and fault tolerance capabilities provided by Colrows.

  • Embeddable Analytics - Colrows is crafted to handle big data volumes effortlessly. It excels at managing vast amounts of data in memory, facilitating seamless data wrangling operations. The outcomes of data wrangling, presented as UI Widgets, can be seamlessly integrated into various applications with ease.

  • Audit – Colrows meticulously records every data operation, capturing details like client IP, user-agent, data source, query, status, and time. Regularly reviewing these audit logs can assist in pinpointing data leaks or detecting unauthorized data access patterns.

  • Team Collaboration – Data access patterns among team members frequently exhibit similarities, making knowledge sharing within the team immensely beneficial for productivity enhancement and the cultivation of a data-driven culture. Colrows facilitates the sharing of SQL queries and data exploration outcomes within the team. Furthermore, Colrows automatically constructs query histories for each user and globally, enabling easy collaboration through searchable archives.

Architecture

Colrows serves as a secure data fabric that connects to a wide array of data sources, facilitating secure data access via various transports like API, JDBC, Manual, and UIWidgets. With a consistent processing stack, all data access operations are handled uniformly, guaranteeing a consistent data view irrespective of the transport method employed for data access.

Colrows Architecture

Colrows adopts a layered architecture, featuring horizontally arranged components such as data source connectors, adapters, data access policy evaluation engine, and SQL query processing engine. It offers pre-built connectors to a wide range of popular data sources. Should a data source not be supported by Colrows' existing library of connectors or if modifications to a connector's behavior are necessary, developers have the option to create custom connectors and integrate them into Colrows.

In striving to utilize SQL as a universal data query language, Colrows often needs to translate incoming data queries into the native query language of the data source. Consequently, Colrows maintains a vast library of adapters to facilitate this transformation process.

The SQL Processing Engine is compliant with SQL 2005 standards, with slight modifications to accommodate certain constructs in select popular databases. This engine parses incoming user queries and enforces data access policies. If the user is authorized to access the requested data, the query is then sent to the underlying datastore for execution.

All external interactions with Colrows are conducted through its HTTP API subsystem, facilitating seamless integration with other applications within the organization. Colrows provides data exposure through four distinct channels:

  • HTTP API
  • JDBC Driver
  • SQL Editor
  • UIWidgets
  • Each of these data access mechanisms is supported by Colrows' HTTP API subsystem.
  • Explore Colrows

    To quickly start exploring Colrows please raise demo request on https://colrows.com or connect us on dev@colrows.com We will be happy to walk you though all the awesome features we developed for you.