Skip to main content

Datadios On-Premises Installation Guide - Windows

Supported Windows versions: Windows 10+ Pro/Home Edition

System Requirements​

Hardware Requirements (Minimum)​

ComponentSpecification
Processor3.1 GHz Intel Xeon Platinum (4 core)
Memory (RAM)16GB
Storage Volume128GB

Software Prerequisites​

  • Docker Desktop software
  • Make sure that running scripts is enabled in your PowerShell. You can enable it by running the following command in PowerShell as administrator: 
     Set-ExecutionPolicy -Scope Process -ExecutionPolicy Bypass

Docker Desktop Installation Steps​

  1. Download and install Docker Desktop for Windows
  2. During installation, ensure WSL 2 backend is selected
  3. Restart your system after installation completes
  4. Verify Docker installation by opening PowerShell and running: 
    docker --version
    docker compose version

If both commands return version numbers, Docker is properly installed.

Docker Hub Access​

Datadios needs to pull the required Docker images from Docker Hub. Ensure you have access to Docker Hub and the necessary credentials provided by the Datadios team.

Docker Hub Login​

Open PowerShell and run:

docker login -u docker-hub-username -p docker-hub-password

Replace docker-hub-username and docker-hub-password with the credentials provided by the Datadios team.

PostgreSQL Database Configuration​

Datadios uses PostgreSQL as its backend database to store configuration and user data. The database can be set up either on the cloud or locally.

Cloud-based PostgreSQL Server​

Datadios can connect to a cloud-based PostgreSQL server. The PostgreSQL server should be set up with the pg_partman and pg_vector extensions. You'll need the following information from your cloud provider:

  • Database URL/endpoint
  • Username
  • Password

Local PostgreSQL Server​

Datadios can also run a local PostgreSQL server using Docker. You don't need to set up PostgreSQL separately; this will be installed as part of Datadios installation.

Installing Datadios​

Download the following two files:

⬇Download InstallDatadios.ps1

PowerShell script to generate docker-compose configuration from template with user inputs

⬇Download docker-compose-template.yaml

Docker Compose template file used by the installation script

After downloading both files:

  1. Place them in the same directory
  2. Open PowerShell in that directory
  3. Run the script by executing: .\InstallDatadios.ps1

The script will prompt you for configuration details (server name, port, database password, and data directory), create the required docker-compose configuration file, and pull the necessary Docker images from Docker Hub.

Running Datadios​

Download the following file:

⬇Download RunDatadios.ps1

PowerShell script to start Datadios Docker containers

After downloading the file:

  1. Place it in the same directory as your docker-compose files (created during installation)
  2. Open PowerShell in that directory
  3. Run the script by executing: .\RunDatadios.ps1

The script will start the Datadios containers using the configuration files generated in the installation step.

Verifying the Installation​

Once the containers are running, verify the installation. Please note that it may take up to 5 minutes for the Datadios service to be fully up and running after running the RunDatadios.ps1 script for the first time.

  1. Open a web browser
  2. Visit http://localhost:<PORT_NUMBER> (replace <PORT_NUMBER> with the port you configured during installation)
  3. If https is enabled, access https://<your-server-address>/dns

You should see the Datadios login page.

Monitoring Resource Usage​

To check CPU, memory, and disk usage for Docker, open PowerShell and run:

docker stats

This will display real-time resource usage for all running containers.

Stopping Datadios​

Download the following file:

⬇Download StopDatadios.ps1

PowerShell script to stop Datadios Docker containers

After downloading the file:

  1. Place it in the same directory as your docker-compose files
  2. Open PowerShell in that directory
  3. Execute the script by running: .\StopDatadios.ps1

The script will stop the Datadios containers using the configuration files generated during installation.

Updating Datadios​

Download the following file:

⬇Download UpdateDatadios.ps1

PowerShell script to update Datadios Docker image

After downloading the file:

  1. Place it in the same directory as your docker-compose files
  2. Open PowerShell in that directory
  3. Run the script by executing: .\UpdateDatadios.ps1

This will pull the latest Docker images from Docker Hub. Once the update is complete, you can restart the containers using the RunDatadios.ps1 script.

Access for Datadios​

Datadios needs access to all the data sources you will be connecting through the platform.

  1. If Datadios is used for migration validation, it needs access to the source and destination databases used for validation (e.g., Snowflake, Oracle, SQL Server, etc.)
  2. For ports, see the docker compose file (Datadios can be setup for http or https)