MariaDB

This document describes the Dataworkz connector configuration required to access MariaDB.

Prerequisite

You need to allow Dataworkz IP address for access to MariaDB Database. This process depends upon the mode of Oracle deployment. Dataworkz supports the following :

• AWS

• Azure

• GCS

• Standalone

AWS

For RDS follow the steps listed below.

• Login to AWS console

• Goto RDS -> Databases

• Select the MariaDB instance

• Goto Security -> VPC security groups and select the appropriate security groups

• Click the appropriate security group from the list

• Click "Edit Inbound Rules"

• Click "Add Rules"

• Select "MariaDB RDS" from the Type dropdown

• Enter the database port

• Enter "IP" of the Dataworkz platform NAT Gateway. This is the IP of Dataworkz platform NAT Gateway and can be viewed by following the steps provided below.

  • Login to Dataworkz Application

  • Goto Configuration by clicking the gear icon at top right of the screen

  • From left menu select Security -> Deployment Details

  • Copy the cluster IP and enter the same in the "IP" field in the above screen

• Click "Save rules"

Create Connector for MariaDB in Dataworkz

1. Login to Dataworkz Application

2. Goto Configuration -> Databases -> MariaDB

3. Click the + icon to add a new configuration

4. 
5. Provide name for the connector

6. Enter Host name / IP address of the database server

7. Enter the Port at which server is running

8. Enter the User name

9. Enter the Password

10. Select the deployment enviornment

11. Select TLS/SSL if needed

12. Click Test Connection

    1. If successful click Save to add the connector