How it works

  • On-demand databases customized for dev, test, support, reporting, ML, devops - Database environments that are lower level than production have custom requirements. For example, different groups of databases for different people or devops pipelines, masking sensitive data, applying different release SQL scripts from Git branches, and varied access controls. Windocks delivers databases customized for different use cases without you writing or maintaining code. You simply provide a configuration spec (dockerfile) that defines the various combinations of databases, access controls, database scripts, and masks. Windocks builds an image from that spec and delivers databases on-demand.
  • Delivered securely in seconds - Windocks uses database cloning technology to deliver copies of terabyte databases in seconds. No matter how big the database, the database clone is delivered in seconds. Learn more about database cloning.
    Windocks has built-in cloning technology based on standard Windows and Linux storage. However, if your organization chooses to use proprietary storage and volume cloning infrastructure (such as Cohesity, Pure Storage, etc), Windocks orchestrates that infrastructure to deliver database clones, so you don't have to write or maintain code to manage the infrastructure. Oracle, SQL Server, MySql, Postgre, etc database cloning is supported.
  • Oracle, SQL Server containers - Windocks provides the only SQL Server container technology for Windows. A container is an isolated service that is created and torn down easily. Multiple containers run on a single machine, for example dozens of Oracle database servers or SQL Servers run on a single machine in containers on different ports. Learn more about database containers.
    Windocks delivers customized database clones to containers or to database instances. You specify in the dockerfile where to deliver the databases and Windocks will automatically create a container and attaach the database clones or attach the clones to an existing database instance. SQL Server containers are available for all versions and editions of SQL Server are supported from 2008 onwards and Active Directory is used for authentication to these SQL Server containers. Windocks orchestrates docker Linux Oracle containers and supports Oracle versions 11 onwards. MySql and PostGre containers are also supported.
  • Simplify infrastructure, code, support and maintenance - Because Windocks uses your spec (dockerfile) and orchestrates services such as security, masking, containers, Repos (Git for example), and storage, you don't have to deal with complex coding or managing infrastructure. The unique container support from Windocks for customized databases dramatically simplifies infrastructure needs, software support and maintenance because you have a much smaller number of machines and no installed databases.

SQL refresh

Steps to securely deliver customized databases in Oracle, SQL Server containers and instances

  • Build - Build an image from the spec (dockerfile). First specify the sources of data (Supported data sources include native SQL Server backups, SQL Server database files, Azure SQL BACPAC files, Oracle RMAN backups, Oradata files, MySql dumps, Postgre dumps, third party backups). Specify list of databases to be delivered, group based access control, data masks to obfuscate PII data, Git repos to pull and run branch specific database scripts.
  • Refresh - Images are refreshed periodically to have the latest production data. Windocks provides the only technology to refresh SQL Server images incrementally with transaction log backups, while still delivering writeable database clones.
  • Deliver - Windocks delivers database clones with containers or to installed database instances. For SQL Server, Windocks provides the container technology as well as cloning. Windocks SQL Server containers are an independent implementation of Docker's container project for Windows is the only solution for SQL Server containers for Windows. All editions and versions SQL 2008 to 2019 are supported. For Linux SQL Server, Windocks delivers database clones in docker SQL Server Linux containers. For Oracle, Windocks delivers database clones in docker Linux Oracle containers. (Oracle 11, 12, 18, 19 are supported). Postgres and MySql database clones are delivered on both Windows and Linux docker containers. Use command line, docker clients, REST API or user interface to deploy to dev, test, staging environments. Kubernetes is also supported.
  • Monitor - View dashboards, audit logs

Windocks technology components

  • Container service - To spin up database containers, you need container technology that supports that particular database version and environment. Docker containers are available for Oracle, PostGre, and MySQL. However neither Docker Inc or Microsoft have a solution for SQL Server Windows containers (they only support Linux). Windocks offers the only available container technology for SQL Server Windows. It is based on Docker Inc's container technology. Windocks cloning, masking and orchestration services work with docker Oracle Linux containers and Windocks SQL Server Windows containers.
  • Cloning service - Windocks provides database cloning technology based on standard Linux and Windows file systems and abstracts the complexity from you. Simply build an image once by restoring SQL Sever or Oracle backups or by using database files and Windocks will create database clones instantanously for you.
  • Masking service - You can write masking script yourself to obfuscate PIIA data or use a built-in masking solution from Windocks or use other masking solutions based on your requirements. Masking solutions should include discovery of all the types of sensitive fields relevant to your databases, creation of masks, support foreign key constraints, and maintain formats of the data being obfuscated. The Windocks offering includes data masking for Oracle and SQL Server.
  • Orchestration of services - You can choose to orchestrate the various data related services (container, cloning, masking, Git repo, authentication) by writing and maintaining code yourself or by using Windocks orchestration. With Windocks, you simply write a spec (in the form of a dockerfile) with details on which databases to clone, their formats, cloning service to use, container service to use authorization, git repo branches and scripts, etc. Windocks will deliver databases using the spec. Windocks is an open system that allows you to use either built-in Windocks cloning, container, masking services or solutions from others.