Establishment of the Database and Requirements

Establishment of the Database and Requirements

One Connect Cloud Manual in Azure

Establishment of the Database and Requirements

Initial conditions

The Onibex OneConnect Cloud platform has a number of microservices that must persist for theworkspaces operation. Although workspaces can run standalone, there are certain functionalitiesof the platform that provide them with additional value to the customer.

Services are Java projects in Spring that performa JDBC connection implementing JPA and Hibernate for SQL queries.

It is suggested to use as an SQL database:

  • MariaDB
  • MySQL
InfoNote:Theoretically, the JPA standard and Hibernate implementation make it possible to use any type of supported database,as PostgreSQL or SQL Server. Although the platform has not been tested with these databases, they should work properly. Importanttake this into account when implementing implementation.

Prerequisites

  1. Download the following sql.zip file: https://oneconnectdeploymentaks.s3.us-east-2.amazonaws.com/database/sql.zip

Deployment Steps

1. Extract the SQL Archive

Before proceeding, extract the sql.zip file:
unzip sql.zip

Enter to the file:
cd sql.zip

2. .env File configuration

The .env file contains the necessary variables for database setup, edit this file as needed before running the script.

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 .env file, verifies the database type and corresponding container and executes 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

Initial Credentials

Administrator:
User: administrator@oneconnect.com
Password: mzve$JQ@bg#zWmiDC3G$Jt
Default user:
Password: mzve$JQ@bg#zWmiDC3G$Jt







    

    • Related Articles
      • 

    •  OneConnect Deployment and Configuration
      One Connect Kubernetes Deployment Manual This manual outlines the steps required to deploy the One Connect system on a Kubernetes cluster using an automated script. The process sets up the necessary services, deployments, and resources for the system ...
      • 

    • OneConnect V2 SAP Manual
      OneConnect V2 SAP Integration The following manual configuration considers the fact that you have installed the version 2 of OneConnect in SAP, please make sure that you are using this version Install the Transport Install the transport request sent ...
      • 

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

    • DBT ENTITIES DOCUMENTATION
      Prerequisites Docker and docker-compose with support for 3.8 ClickHouse database. Download the dbt project, the repository will be provided by Onibex Configuration of docker-compose services Each service in the docker-compose file has the following ...
      •