AI Data

Embedding Pipelines

Secure embedding infrastructure with row-level security and flexible technology choice.

Duration Laufend
Embedding pipeline architecture

About the Project

Embedding pipelines form the foundation for RAG applications and semantic search. As part of various projects, numerous pipelines were developed – each adapted to the specific requirements and preferences of customers.

Security-by-Design

Security-by-Design: A central principle in development is the consistent consideration of access controls. Row-Level Security (RLS) and Field-Level Security are conceptually integrated from the start. Embeddings inherit the permissions of their source documents – this ensures that semantic search only finds content the respective user has access to.

Vector Stores

Flexible Vector Stores: Different vector databases are used depending on requirements – Milvus for high-performance, scalable deployments, Azure AI Search for integrated search pipelines with hybrid search, Azure SQL Database with Vector Extension for scenarios with existing SQL infrastructure and RLS requirements.

Orchestration

Orchestration: Document embedding is done via various pipeline technologies – N8N for rapid, visual development, Azure Durable Functions for scalable, event-driven pipelines, Fabric Data Pipelines for integration into Microsoft Fabric ecosystems.

Embedding Models

Embedding Models: Depending on use case and data protection requirements – OpenAI API for state-of-the-art embeddings, Microsoft Foundry for Azure-native deployments, Ollama for local, privacy-compliant processing.

Highlights

  • Security-by-design with RLS and field-level security
  • Flexible technology choice (cloud/on-premises)
  • Support for various vector stores and embedding models
  • Reusable pipeline patterns

Challenges

Consistent permission inheritance across different vector stores. Performance with large document collections.

Results

Secure, flexible embedding infrastructure for diverse customer requirements. Reusable patterns for RAG applications.

Interested?

Are you interested in a similar project or want to learn more? Get in touch – we look forward to hearing from you!

Get in touch