How to integrate Redis in Microsoft SQL Server

Discover how to integrate Redis and Microsoft SQL Server and instantly get access to your data.

WITH PIPES OR PIPES PROFESSIONAL
How to integrate Redis in Microsoft SQL Server with Pipes
WITH THE LOGICAL DATA WAREHOUSE
How to integrate Redis in Microsoft SQL Server with Logical Data Warehouse


About Redis

Redis is an open-source software project that implements data structure servers. With optional durability, it is an in-memory data structure store, networked, cache and message broker and used as database. Redis supports data structures such as hashes, strings, sets and lists, sorted sets with range queries, hyperLogs, bitmaps, and geospatial indexes with radius queries.  

About Microsoft SQL Server

Microsoft SQL Server is a popular relational database management system. As a database server Microsoft SQL Server stores and retrieves data which may run either on another computer across a network or on the same computer, requested by other software applications.

What is Data Virtuality?

Data Virtuality enables companies to build an agile BI stack in 1 day. It connects to Redis, Microsoft SQL Server and more than 200 other databases and cloud services. All connected data sources can be directly queried with SQL and data can be moved into any analytical database. Customers of the Data Virtuality Logical Data Warehouse are digital businesses with the highest flexibility needs.

IMMEDIATE DATA ACCESS

Connect over 200+ databases, cloud services and files (XML, CSV, etc.) in minutes. Query data directly with your favourite business intelligence and analysis tools.

CENTRAL DATA MODEL

Build your single source of data truth and set uniform definitions for your data. Connect your business intelligence tools to Data Virtuality and make sure everyone in your organisation works with the right data.

ALL IN SQL

With Data Virtuality you can query all data sources with SQL regardless of the file format. NoSQL, CSV or XML File: We transform any connected data source in SQL.

REAL-TIME REPORTING

Data Virtuality controls the exchange of data between all databases, cloud services, and analysis tools to help everyone in your organization get the right information, in real-time if needed.