Establishment of the Database and Requirements

Establishment of the Database and Requirements

OneConnect - Establishment of the Database and Requirements

Prerequisites

  1. For the SQL database, the following tools are recommended to be installed: 

    • MySQL Client

    • MariaDB Client

  1. Linux Shell (Bash, Zsh, etc.) or a compatible environment
  2. Access to the Database (credentials, host, port)
  3. Download the following sql.zip file - Database Deployment

Minimum Resource Requirements

Database Requirements

  1. Memory: At least 20 GB RAM
  2. Disk Space: 50 GB
  3. CPU: Mid-range (4–8 vCPUs, depending on query load and concurrency)
Note: These specifications are intended for PoC purposes. For production use, additional scaling and optimization may be required based on actual workloads.

Deployment Steps

1. Extract the SQL archive

Before proceeding, extract the sql.zip file by running the following command:
unzip sql.zip

Navigate to the extracted folder:
cd scripts-sql

2. Configure the .env file

The .env file contains the necessary variables for the database setup. Edit this file as needed before running the script. (i.e. nano .env)


3. Run the run-sql.sh Script

Before executing the script, assing execution permissions: 
chmod +x setup_db.sh

Run the Script
./setup_db.sh

This process loads the variables from the .env file, verifies the database type and corresponding container, and executes the SQL scripts to create and populate the database.
Info
If you are unable to execute the script, make sure to install dos2unix and then run the script again. You can install it and convert the script using the following commands:
sudo apt-get install dos2unix
sudo yum install dos2unix
dos2unix setup_db.sh
./setup_db.sh

After completing these steps, the required database for managing OneConnect will be successfully deployed. You are now ready to proceed with the next steps of deployment.



    • Related Articles

    • Azure - OneConnect Deployment and Configuration

      One Connect Platform: Kubernetes Azure Deployment Manual for Private Network This manual outlines the steps required to deploy the One Connect system on a Kubernetes cluster within a Private Network (meaning the OneConnect Platform will not be ...

    • Azure - One Connect Deployment Prerequisites

      Before you Begin: The following deployment manuals assumes a basic understanding of Kubernetes concepts. For more information, refer to Kubernetes core concepts for Azure Kubernetes Service (AKS). Before you begin: If you don't have an Azure account, ...

    • OneConnect General Architecture

      The diagram below illustrates the high-level architecture of the OneConnect solution. It depicts SAP ECC or S/4HANA as the data producer, with multiple downstream systems—such as ClickHouse, Snowflake, and Databricks—acting as subscribers. Other ...

    • EKS EC2 Deployment Manual with Terraform

      This manual provides step-by-step instructions for deploying an Amazon EKS (Elastic Kubernetes Service) cluster using Terraform. It includes the configuration of essential components such as AWS credentials, infrastructure provisioning, EBS CSI ...

    • One Connect Cloud Deployment

      Prerequisites Download the required .zip folders attached at the end of the document: sql.zip one-connect.zip kafka-compose.zip Requirements for the Virtual Machine System: Linux Architecture: 64-bit processors (x86_64) support Instance ...