Establishment of the Database and Requirements

Establishment of the Database and Requirements

One Connect Manual in Azure

Establishment of the Database and Requirements

Prerequisites

  1. For the SQL database, the following are recommended:

    • MariaDB

    • MySQL

  2. Download the following sql.zip file - Database Deployment

Minimum Resource Requirements

Kubernetes Environment

  • CPU & Memory:
    • Mid-tier node recommended
    • RAM: Minimum 12 GB (16 GB preferred for higher stability)
  • Storage:
    • Persistent Volume (PVC): 50 GB
    • Ephemeral Disk Space: 100 GB

Database Requirements

  • Memory: At least 20 GB RAM
  • 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)
Info
For deployment in Kubernetes, set the variable KUBERNETES_MODE to true

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: HERE


    • Related Articles

    • One Connect Deployment - Azure 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 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 ...

    • OneConnect General Architecture

      The following representation shows a general architecture diagram for OneConnect, considering SAP ECC or S4HANA as the producer and destinations such as Clickhouse, Snowflake, and Databricks as subscribers. The OneConnect structure consists of 3 main ...

    • One Connect Deployment - AWS Prerequisites

      Technical Prerequisites for Proof of Concept (PoC) Kubernetes Deployment Options The OneConnect Platform can be deployed on Minikube or vanilla Kubernetes clusters. However, for better scalability and operational simplicity, we recommend using Amazon ...

    • 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 ...