Data as a Service using ScyllaDB

In today’s data-driven world, efficient data management and accessibility are paramount. Data as a Service (DaaS) and the integration of an API Gateway play pivotal roles in enabling seamless data sharing, secure access, and efficient management. We will explore the implementation of DaaS using ScyllaDB and the advantages of incorporating an API Gateway for managing interactions.

DaaS serves as a solution to selectively and securely share data across diverse platforms and systems.

Why DaaS can help?

Data in silos can limit its potential value across an organization. However, exposing an entire database to various teams can pose governance and security challenges. DaaS resolves this by selectively exposing valuable data via APIs, enabling secure sharing while implementing essential access controls.

Benefits of using DaaS

• Agility and easy maintainability: Rapid access to data without having knowledge of its storage and reduced maintenance overhead for data consumers.
• Enhanced Security: Robust authentication and authorization protocols.
• Scalability and Load Balancing: Efficient resource utilization and high availability.
• Protocol Abstraction and Versioning: Seamless integration without disruptions.
• Monitoring and Analytics: Insights for performance optimization and issue resolution.
• Compliance and Governance: Consistent application of regulatory requirements.

Example using ScyllaDB

• API Gateway for API management.
• ScyllaDB for data storage.
• RESTful Spring Boot application for API development.

Setting Up API Gateway

The implementation of API Gateway will be using Spring Cloud Gateway to route requests to our ScyllaDB instance.

@SpringBootApplication
public class Application {

    public static void main(String[] args) {
        new SpringApplicationBuilder(Application.class)
                .profiles("routes")
                .run(args);
    }
}

Routing configuration can be established either through Java, or by utilizing properties configuration:

spring:
  cloud:
    gateway:
      routes:
      - id: daas-scylladb
        uri: localhost:8082/
        predicates:
        - Path=/daas/users

The example is using Spring Cloud Gateway, it’s important to note that various alternatives exist for API gateway solutions. While Spring is a robust and widely-used framework, other solutions, such as Netflix Zuul, and those offered by cloud providers like AWS, provide unique features and advantages.

Setting Up API Service

The REST controller responsible for accessing ScyllaDB data will be implemented Spring Web.

@RestController
@RequestMapping("/daas")
public class DaasController {
    @Autowired
    private UserRepository userRepository;

    @GetMapping(path = "/users", produces = "application/json")
    public ResponseEntity<List<User>> getUsers() {
        return ResponseEntity.ok(userRepository.findAll());
    }

}

This controller is responsible for handling HTTP requests related to ScyllaDB data.

Setting up the Data Access Layer

ScyllaDB data access layer powered by Spring Data Cassandra integration provides a seamless way to interact with ScyllaDB and simplifies our data access logic.

public interface UserRepository extends CassandraRepository<User, Integer> {

}

The UserRepository interface provides basic CRUD operations for interacting with the ScyllaDB database. If required, you have the flexibility to extend the repository by incorporating additional access operations to meet your specific requirements.

The examples presented here can be found in GitHub repository.