1. Project Overview

DataCap is integrated software for data transformation, integration, and visualization. It supports multiple data sources, file types, big data databases, relational databases, NoSQL databases, and more. This software enables users to manage multiple data sources, perform various operations and transformations on their data, create data charts, monitor data sources, and more.

2. Open Source License

Licensed under Apache-2.0

3. Screenshots

4. Feature Overview

DataCap is a fast, lightweight, and intuitive system.

Powerful Yet Easy to Use

• Integrate and explore data quickly and easily using a simple SQL IDE.

Integration with Modern Databases

• DataCap can connect to any SQL-based data source through JDBC, native, and HTTP connections.

5. Tech Stack

System Requirements

Warning

The software binary packages are compiled and tested on the following systems. They have not been tested on other versions, although those versions are theoretically supported.

If your system is not supported, use the source code compilation method to compile the binary files yourself.

System

Version

JDK

> = 1.8

MySQL

> = 5.6.x

Binary Installation

Please Note

Download and install the binary package for your corresponding operating system from the following address.

Command-Line Interface

DataCap CLI provides a terminal-based interactive shell for executing queries. The CLI is an executable JAR file, which means it works like a regular UNIX executable.

Requirements

The CLI requires an available Java Virtual Machine on your PATH. It can be used with Java 8 and later versions.

The command-line interface communicates with the system through the DataCap client REST API (HTTP/HTTPS protocols).

The CLI version must be the same as or newer than the system version.

Installation

Download

Download datacap-client-cli-1.6.0.jar, rename it to datacap, and use chmod +x to make it executable.

Running the CLI

./datacap

connect -h 127.0.0.1 -p 9096 -u username -P password

If successful, you will see a prompt for executing commands. Use the help command to view the list of supported commands.

Command

Description

source info

Get Data Source Details

source list

Retrieve the list of data sources from the remote server.

source use <SourceID>

Set the data source flag for subsequent operations on that data source.

source execute "<QuerySQL>"

Execute Remote SQL