Tough to achieve in different real time scenarios but still a masterpiece activity explained for new users..tks
@sraoarjun3 ай бұрын
Awesome
@adityakvs35295 ай бұрын
In sink why you upsert and insert
@Ramana67839 ай бұрын
Hi..I'm not getting invoice table is not executed for me in pipeline...where I went wrong...can you please help me to fix it
@Ramana67839 ай бұрын
Actually why we nee to create the same table in target DB (demobits DB)
@Ramana67839 ай бұрын
Please attach the codes for the vedio that you have been used
@swagatpadhi7078 Жыл бұрын
Nua rasan card pain kn kn darkar ? Elegibility ?
@nagarajupinnu3621 Жыл бұрын
why can't we update watermarkDate in a table directly with query instead of Stored procedure which is extra object
@azurebitsandbytes5804 Жыл бұрын
The script activity was not present at the time of making this video. You can use this definitely.
@sirigiriharikrishna1772 Жыл бұрын
How Capture data change works in case of timestamp
@dhrumilgajjar3515 Жыл бұрын
Great explanation and useful video
@shaileshsondawale2811 Жыл бұрын
Wonderful Delivery...!!!! :)
@gsuri-m2k Жыл бұрын
how munch does the basic parameter alerts costs in Azure ?
@shaileshsondawale8765 Жыл бұрын
Awesome...!!! Simplicity in Teaching...!!! Great..!!!
@rohitsethi5696 Жыл бұрын
no this is not useful.The table should be manually enter. This is 200% end developer can end wrong table or misspell or space in table name end or before. The best way to store all the table name in the Table then for each loop process
@shankar1556 Жыл бұрын
Does orders and invoice tables has same schema? How mapping works if table name and column names are different
@shaileshsondawale8765 Жыл бұрын
Awesome Content.. Great work done Sir....
@Tsoy78 Жыл бұрын
I can't see stored procedure to select when in the Sink settings !!
@shinojpkoduvally5205 Жыл бұрын
I assume this works only when Source in in Table format. How do we use REST API as source which return a JSON object and pass that to Stored Procedure in Sink? Appreciated if you have Video for such scenario.
@lilian992110 ай бұрын
Hi, did you get the chance to test by using REST API as a source? If so, how did it go?
@kirankumarjena1781 Жыл бұрын
Do you know how to customise the alerts. Suppose in the alert mail you are getting the subscription ID as well. As it is confidential so I don't want to expose that in my metric alter rule
@Andydady-fp2zm Жыл бұрын
Thanks I learned lot in this tutorial. good one
@harrydadson7467 Жыл бұрын
Please can someone please assist me on how I'm not able to do a Copy Activity to Stored Procedure on MySQL table in sink setting. Please help. Thanks
@暁明徐2 жыл бұрын
greate demo!
@alexcarter-jones32512 жыл бұрын
Great video! Have you ever set up an incremental load between an Oracle source table and an SQL sink table before? I am currently trying to do this but can only get my delta load to work when copying from SQL to SQL as you did in this video, any guidance would be greatly appreciated :)
@rathikavenkatesh25102 жыл бұрын
Hi
@rathikavenkatesh25102 жыл бұрын
Want to call a sp after copy data actually. Is it possible?
@sriramch31282 жыл бұрын
Please let me know how did u get that @source when u created stored procedure
@harrydadson7467 Жыл бұрын
I believe this is not an option anymore in the new ADF, video was made couple of years ago
@sriramch31282 жыл бұрын
I need that data set of net flix can u provide
@shivprasads.jadhav64502 жыл бұрын
Perfect
@RameshPatel-fg9qk2 жыл бұрын
Thanks, Nice Video Please Share Multiple csv file move in to Archiver Folder on Daily Bases
@CraigBoland2 жыл бұрын
Recipient or Distribution Group appears to be not currently supported. We tried sending alerts to our team's distribution group. None were received though we verified the distribution group does indeed work for us. When switching back to individual email addresses, we began receiving the alerts again.
@juzerpatanwala51332 жыл бұрын
where can we find this dataset of customer orders
@juzerpatanwala51332 жыл бұрын
Please create a playlist for Azure DevOps
@chandrasekharnallam25782 жыл бұрын
nice explanation with easily understanding the concept. thank you
@loki92673 жыл бұрын
Thanks for detailed explanation
@vijaychandar1003 жыл бұрын
Great info thanks
@ambicagudda41433 жыл бұрын
Thank you for the good video. One question here, what if we want to get modified records as well along with the new records.
@azurebitsandbytes58043 жыл бұрын
Then we have to consider modified date from the source and at the same time you would need use sp as sink with merge logic. I have posted a video with sink as the SP. Plz refer
@ambicagudda41433 жыл бұрын
@@azurebitsandbytes5804 If possible please add one video on the mentioned requirement. Thank you
@Ramana67839 ай бұрын
Hi..please post the link for the above requirement
@AMagicViewer3 жыл бұрын
To the point.. nice one 😊👍
@AMagicViewer3 жыл бұрын
Good one👍
@grabmylook45003 жыл бұрын
Thanks for this amazing video, I hope someday you do a bulk copy from an Azure SQL database to another Azure SQL database 😎
@jyothikulkarni29613 жыл бұрын
can we add more than 1 email id to be sent
@azurebitsandbytes58043 жыл бұрын
Yes, you can add multiple email ids
@krishnakumar-vi3tf3 жыл бұрын
It was nice,but one question how can i handle multiple tables passing dynamically to pipe line,right now you are entering table names at pipe line level manually but my requirement is i have to pass table list for both lookups dynamically
@krishnakumar-vi3tf3 жыл бұрын
i got to know there is another video where we can pass tables dynamically with master pipe line..excellent..its an urgent requirement for me..thanks a lot
@muraliyadav76013 жыл бұрын
Thanks Sangram for the video, I have a requirement which I need to send the password as a header in the web activity body, the password is available in the key vault as a secret, how can we do that
@muraliyadav76013 жыл бұрын
I am able to get it by using web activity 😀,
@vagdevigovardhanam1203 жыл бұрын
Good video, thanks for that But one question how about the invoice mapping in copy activity(in child pipeline). Master pipeline failing(ForEach activity) due to not being able to load invoice data. Can you please tell me how this can be fixed Thanks
@azurebitsandbytes58043 жыл бұрын
Clear off the schema of the sql dataset. It will work
@SangLeWeb2 жыл бұрын
@@azurebitsandbytes5804 can you elaborate on this? mine only work on the first table but always get "Column name 'xxxx' cannot be found in either source data or column" but if I map the data then it works but then the 1st table would failed with similar message.
@azurebitsandbytes58042 жыл бұрын
@@SangLeWeb Look Up First Row Only Property needs to be unchecked to allow reading all the records from the config table
@SangLeWeb2 жыл бұрын
@@azurebitsandbytes5804 That's not I was referring to, mine is already unchecked and I can see it loops through 2 records but as I said, it works only the 1st loop, the 2nd threw an error about the ID not avail since my 2nd table does not call ID but it says userID. So it seems like the source still using the previous schema instead of new one which I already put a "Select *..". Just try to run the child by changing the table name wouldn't work neither unless I create a mapping then I can run with different table name. The only diff between your sample and mine is my sourct table name is diff from my sink so I created 3 variable (SourceName, TargetName, WatermarkValue) but I don't think this should be an issue.
@SangLeWeb2 жыл бұрын
I figured it out, it was my SP that I ran causing the issue. BTW, thanks for taking the time to put up the videos, very insightful.
@wheretastesdivedeep3 жыл бұрын
How to handle if the table don't have data?
@azurebitsandbytes58043 жыл бұрын
Which table?
@shivprasads.jadhav64503 жыл бұрын
Detailed video. Keep it up and ongoing with such a informative videos.
@azurebitsandbytes58043 жыл бұрын
Thanks shiv
@ambershergill19823 жыл бұрын
when your 3000 threshold reach would you receive two emails or just one email you setup at action group ? Please update
@shivprasads.jadhav64503 жыл бұрын
Informative video
@divyaravichandran76333 жыл бұрын
Awesome and clear explanation!!
@ajithreddy68053 жыл бұрын
Great Video!!!! Can we add more variables?? like Pipeline Name, File Name and Error message. Like Azure logics app variables
@ashwinds62933 жыл бұрын
Am getting an error in pulling the data through ADF for Oracle as a Source . Could you please help me in this
@Lihka0803 жыл бұрын
@ Azure Bits and Bytes Hi Sir very useful and excellent, could you please add update logic, so if there is any change in source table records it should update the records in sink table then need to take latest from source to sink table. Thanks in advance