Azure_SQL_SERVER
version: Version: 1.0.0
Category: Database
Tier: 32
Type: Source, Target
Authentication: Service Account Credentials
Supported Save Mode as Target: Append & OverwriteConnection Properties:
...
| Expand |
|---|
...
|
...
|
...
|
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.
...
|