Overview

A introduction to the Data Service module of ReOrc.

What is Data Service?

The Data Service module simplifies data access for non-technical users by providing a user-friendly interface to interact with SQL-based data views. It allows business teams, external partners, or other stakeholders to explore, filter, and download data without needing to write or understand SQL queries.With Data Service, technical users (e.g., data engineers or analysts) can create and share pre-defined SQL queries, while non-technical users can easily access and interact with the resulting data through a visual interface. This eliminates the need for manual data extraction or complex query writing, making data more accessible and actionable for everyone.

Key benefits

• Save as a Service: Users can save queries as services, enabling others to preview, download, or access the data through an API.

• Ease of Use for Non-Tech Users: Non-technical users can easily preview data and perform further analysis without SQL knowledge.

• Data Accessibility: External users can download data in Excel or extract it via API for seamless integration with their systems.

Components

• Create & edit Data Service: Write, save, and manage SQL queries with a built-in editor and field configuration options.

• Data preview & download: Preview, filter, sort, and export data to Excel/CSV for easy analysis and sharing.

• Data sharing API: Share Data Services and access data via API keys.

• Access control: Manage permissions and share Data Services with specific users or teams.