One Connect Cloud Deployment

One Connect Cloud Deployment

Prerequisites

Download the required .zip folders attached at the end of the document:
  1. sql.zip
  2. one-connect.zip 
  3. kafka-compose.zip

Requirements for the Virtual Machine

  1. System: Linux
  2. Architecture: 64-bit processors (x86_64) support
  3. Instance Specifications: vCPUs with 4 virtual cores, RAM with 16 GiB, Network bandwidth up to 12.5 Gbps
  4. Storage Specifications: Disk capacity with 280 GiB, Storage performance with 6000 IOPS (Input/Output Operations Per Second)
  5. Network Configuration:The following ports must be enabled in the security group to ensure the correct operation of associated services:
    1. Kafka Ports:
      1. 9093 – Broker
      2. 9102 – Broker
      3. 8086 – Schema Registry
      4. 8083 – Connect
      5. 8085 – Control Center
      6. 8089 – KsqlDB
    2. One Connect Ports:
      1. 5050 – Frontend
      2. 9000 – API Gateway
      3. 707070 – Metrics
      4. 7072 – Logs
      5. 50501 – Producer
    3. Database Ports:
      1. 3306 – MySQL

Database creation

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 docker, set the variable KUBERNETES_MODE to false

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:

Password: mzve$JQ@bg#zWmiDC3G$Jt

Default user:

Password: mzve$JQ@bg#zWmiDC3G$Jt
Deployment of Confluent Platform
Preparation
Download the kafka-compose folder: https://oneconnectdeploymentaks.s3.us-east-2.amazonaws.com/oneconnectdocker/kafka-compose-latest.zip
Which contains the necessary files for deploying Kafka and its components. Inside, you will find:
  • docker-compose.yml file
  • setup_kafka_dirs.sh script
  • .env file
  • control-center folder
If you want to check the configured credentials, you can review the password.properties file located in the control-center
 folder.
.env File configuration
Configure the .env file by entering the address of the server where Kafka will be deployed.
Once the files are configured, transfer the kafka-compose folder to the desired location on the server.
Run the script 
Inside the kafka-compose folder, grant execution permissions to the setup_kafka_dirs.sh script using the following command:
chmod +x setup_kafka_dirs.sh

Run the script to create the volume folders and deploy Kafka using Docker Compose with the following command:
./setup_kafka_dirs.sh
Access to Control Center
Access Control Center from your preferred browser by entering the IP address of the server where Kafka was deployed, followed by port 9022, using the following format:

<Server_IP>:9022

Enter the credentials configured in the password.properties file.
Once authenticated, you will be able to view all deployed Kafka components.
selectedImg
Configuration and Deployment of One Connect Platform
Requirements:
Deployed Confluent Platform
Configured Database
Deployment configuration
It includes three internal folders:
  • Frontend
  • Platform
  • Workspace
And the following files:
  • .env
  • run_compose.sh
.env File configuration
Before uploading the folder to the server, it is necessary to configure the .env file, which contains the environment variables required for the system’s operation. It is recommended to use a code editor to complete this task.
selectedImg
To enable email services, you must configure the following variables with the details of your SMTP server:
  1. EMAIL_PASSWORD
  2. EMAIL_SMTPAUTH
  3. EMAIL_SMTPFROM
  4. EMAIL_SMTPHOST
  5. EMAIL_SMTPPORT
  6. EMAIL_SMTPSSLPROTOCOLS
  7. EMAIL_SMTPSTARTTLSENABLE
  8. EMAIL_USER
Run the run_compose.sh Script
Upload the one-connect-compose  folder, with the configured files, to the destination server.
Once the folder is on the server, navigate to its directory.

Run the following command to grant execution permissions to the script:
chmod +x run_compose.sh

Start the deployment of the containers by running:
./run_compose.sh
Access to interface
Wait about a minute for all containers to start up completely. Then, open a browser and enter the IP address of the server where OneConnect was deployed, followed by port 5050, using the following format:
<Server_IP>:5050
Initial Credentials
Administrator:
Password: mzve$JQ@bg#zWmiDC3G$Jt
Default user:
User: poc@onibex.com
Password: mzve$JQ@bg#zWmiDC3G$Jt

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.sh
./setup unix






    

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

    • 3. One Connect - Connection
      3. CONNECTION The One Connect system provides the capability to extract information from SAP and its transfer it to Kafka. This facilitates the creation of a requisite database for analysis, which serves as the foundation for generating financial ...
      • 

    • 2. One Connect - Setup
      2. SETUP In addition to setting up entries and core modules, One Connect requires the configuration of specific customer tables. These tables play a crucial role in facilitating the application’s data retrieval process from SAP and its subsequent ...
      • 

    • 1. One Connect - Installation
      Step by Step SAP Integration Manual. The following information provide a condensed overview of the comprehensive SAP Integration Manual. In this manual, you'll find detailed step-by-step instructions for seamless SAP integration. Here's a glimpse of ...
      • 

    • Onibex Databricks JDBC Connector for Confluent Cloud
      JDBC Onibex Connector for Databricks The JDBC Onibex connector for Databricks sends real-time data from Kafka to write into live DeltaLake tables. Idempotent writes can be achieved using upserts. Automatic table creation and schema evolution are ...
      •