MariaDB

MariaDB is a powerful, open-source relational database management system (RDBMS) designed for high performance, reliability, and scalability.

MariaDB enables organizations to build and run data-driven applications efficiently across on-premises, cloud, and hybrid environments. It supports standard SQL, ACID-compliant transactions, and a wide range of storage engines, allowing developers to optimize workloads based on performance, availability, or analytical needs.

Authentication

Before you begin, make sure you have the following information:

1. Connection Name - Choose a meaningful name for your connection. This name helps you identify the connection within your application or integration settings. It could be something descriptive like "MyAppMariaDBIntegration".

2. Host Address -  The IP address or DNS name of the database server.

3. Port Number - The port on which your MariaDB server listens for connections. Default value: 3306.

4. User - The authenticated user who has the permissions to read tables in your database.

5. Password - The password for the database user.

6. Database Name - Specify the database you want to load data from.

7. Connect directly - UnifyApps connects straight to MariaDB over the network and no intermediate server is involved.

8. Connect through SSH - Enable this option to connect to Unifyapps using an SSH tunnel, instead of directly connecting to your Oracle database host. This provides an additional level of security to your database by not exposing your Oracle setup to the public. 

9. SSH Host - Enter the hostname or IP address of the SSH server that acts as the gateway to your database. Example: ssh.example.com or 203.0.113.1

10. SSH Port - Specify the port number on which the SSH server is listening. Default is usually 22, but it may be different for security reasons.

11. SSH User - Provide the username for authenticating with the SSH server. This is typically the user account on the remote server with necessary permissions.

12. RSA Private Key - Provide the RSA private key corresponding to the public key stored on the SSH server. 

13. Client Certificate - Obtain a valid client certificate issued by a trusted Certificate Authority (CA).This certificate authenticates your client to the database server.

14. SSL Certificate Key - This is the private key corresponding to your client certificate.

15. Server Certificate - Obtain the database server's SSL certificate. This certificate verifies the server's identity to your client. Often provided by your database administrator or hosting service.

Actions