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
Login to Dataworkz Application
Goto Configuration -> Databases -> MariaDB
Click the + icon to add a new configuration
Provide name for the connector
Enter Host name / IP address of the database server
Enter the Port at which server is running
Enter the User name
Enter the Password
Select the deployment enviornment
Select TLS/SSL if needed
Click Test Connection
If successful click Save to add the connector
Last updated