This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Can you please send the step by step details how to load the data from sql server tables to cosmos DB using ADF pipelines.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
Hello @Bommisetty, Rakesh (Hudson IT Consultant)
I hope you have come across the below documentation! Please let me know if you need further help in any specific step or section which is blocking?
Copy and transform data in Azure Cosmos DB for NoSQL by using Azure Data Factory
*
This article outlines how to use Copy Activity in Azure Data Factory to copy data from and to Azure Cosmos DB for NoSQL, and use Data Flow to transform data in Azure Cosmos DB for NoSQL. To learn more, read the introductory articles for Azure Data Factory and Azure Synapse Analytics.*
Here are some additional resources that can help you with the details of each step:
Hi satish,
I am new to this concept so please explain me in detail for the below example.
i want to load the data from onprem(sql server) to cosmos DB like below query is onprem(sqlserver) db.
SELECT [RecordID]
,[Errorcolumn]
,v.Id
,table2.BatchID
,table2.columnID
FROM table v
Inner Join table2 on v.Id = tabl2.ID
Hello @Bommisetty, Rakesh (Hudson IT Consultant) Please stay tuned on this thread.
ok sure, please send the update how i can implement in ADF
Hey
PFB steps:
with Table as blank
mapping to the container in which you want to sync data
put your Select query in query section
Sink :
Since you just want to insert, select Insert as write behavior
for other detailed steps you can refer the MSFT doc shared above
yes but how to map to cosmosDB container items? and how the data will load to it please explain in detail
How it will map automatically in the cosmos DB items? please explain in detail
Hello @Bommisetty, Rakesh (Hudson IT Consultant) Please let us know the Type of CosmosDB you are using?
Hello @Bommisetty, Rakesh (Hudson IT Consultant) Just checking if we are still connected on this discussion?
Hello @Bommisetty, Rakesh (Hudson IT Consultant) Just checking in if you have had a chance to see my previous response?
Hello @Bommisetty, Rakesh (Hudson IT Consultant) Could you please let us know what type of Cosmos DB API are you using?
SQL Server : Source Data Preview shows 3 records in the source SQL Table Query
Copy Activity: mapping:
Output to CosmosDB: Shows 3 records written
Please let us know if this is helpful.
Thanks for your response and i figured it out how i want and the steps helped me what ever you sent.
Hello @Bommisetty, Rakesh (Hudson IT Consultant) I am glad that the issue is now resolved.
Please feel free to post any further new questions and tag our team to get help.
If the response is helpful, please click "Accept Answer" and Click 'Yes'. So that we can close this thread.