Azure_SQL_SERVER
version: 1.0.0
Category: Database
Tier: 3
Type: Source, Target
Authentication: Service Account Credentials
Supported Save Mode as Target: Append & Overwrite
Connection Properties:
Name | Mandatory | Description |
Connection Name | Yes | Name of the connection |
Description | No | Description of connection |
Host | Yes | Host id |
Port | Yes | Port number |
Schema | No | Schema Name |
Database | Yes | Name of database |
Username | Yes | Username |
Password | Yes | Password |
All the required details are available with your DB Administrator.
Creating Pipeline as Source Connector:
Step 1: Select Source Connector as Azure SqlServer.
Step 2: Select Connection from the dropdown.
Step 3: Configure the connection object.
Step 4: Verify the connection details in the section and click on Next button.
Step 5: Select the Target connection and connection object and click on the Next button.
Step 6: Configure the field mapping page and click on the Next button.
Step 7: Select the scheduling and proceed ahead by clicking on the Next button.
Step 8: Confirm the details that you have selected for this pipeline and click on Submit and the pipeline will be created.
Creating Pipeline as Target Connector:
Step 1: Select the Source connector as per the requirement.
Step 2: Select the required Connection and Connection object and click on the Next button.
Step 3: Select Target Connector as Azure SqlServer.
Step 4: Select Connection from the dropdown.
Step 5: Configure the connection object.
Step 6: Select the type of Save mode you want.
Step 7: Verify the connection details in the section and click on the Next button.
Step 8: Configure the field mapping page and click on the Next button.
Step 9: Select the scheduling and proceed ahead by clicking on the Next button.
Step 10: Confirm the details that you have selected for this pipeline and click on Submit and the pipeline will be created.