Microsoft SQL Server
Last updated
Last updated
This document describes the Dataworkz connector configuration required to access Microsoft SQL Server database.
You need to allow Dataworkz IP address for access to SQL Server Database. This process depends upon the mode of Oracle deployment. Dataworkz supports the following :
AWS
Azure
GCS
Standalone
For RDS follow the steps listed below.
Login to AWS console
Goto RDS -> Databases
Select the SQL Server 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 "SQL Server 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"
Go to the Google Cloud Console.
Navigate to the Cloud SQL Instances page.
Click on the instance name to open its Overview page.
From the left-side SQL navigation menu, select Connections.
Click on the Networking tab.
Check the Public IP checkbox.
Click Add network.
(Optional) In the Name field, enter a name for the network.
In the Network field, enter the IP address or address range you want to allow.
Use CIDR notation (e.g., 192.168.1.0/24).
Click Done.
Click Save to apply the changes.
Login to Dataworkz Application
Goto Configuration -> Databases -> MS SQL Server
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 environment
Select TLS/SSL if needed
Click Test Connection
If successful click Save to add the connector
