Azure_SQL_SERVER
version: 1.0.0
...
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.