Home > Workload Solutions > SQL Server > Guides > Design Guide—Data Analytics with SQL Server 2022 on Red Hat OpenShift and Dell ObjectScale > Design guide introduction
Dell validated solutions are based on established principles to provide customers with more value than creating their own solution, resulting in faster time-to-market and reduced risks. Dell systems engineers validated Microsoft SQL Server with Dell ObjectScale Storage to ensure that the solution is scalable, reliable, and efficient.
This guide outlines the major components involved in developing the solution such as data lakehouse, data virtualization, Dell ObjectScale, Red Hat OpenShift Container Platform (RHOCP) and RHODF, Apache Spark, Microsoft SQL Server 2022, and other solution requirements. It also discusses the physical, logical, and data access architecture and deployment concepts. Deployment concepts described in this solution include deployment and configuration of OpenShift Cluster, MetalLB service load balancer, Red Hat OpenShift Data Foundation, Dell ObjectScale, Apache Spark, and Microsoft SQL Server 2022 with PolyBase feature.
This design guide highlights use cases such as the creation of Microsoft SQL Server 2022 container image and self-service deployment of SQL Server 2022 for data analytics purposes. It also highlights features of SQL Server 2022, including PolyBase, which introduced connecting to external tables backed by S3 compatible storage such as Dell ObjectScale.
In this design, SQL Server 2022 runs as containerized application on Red Hat OpenShift Container Platform. This solution has been validated with Red Hat OpenShift Container Platform, using Red Hat OpenShift Data Foundation as a persistent block storage.