#8. Azure Data Factory - Load data from On Premise SQL table to Azure Blob Storage

Hi, Thanks for your video. I have question My application resides on onprem and database available on cloud. Let me know how to connect cloud database from my application.

Hi, I really appreciate your time. The explanation was precise and nice. As a gesture of thanks, I subscribed to your channel.
I have a question: How can I copy two tables from on-premise to a Gen2 container at the same time? Do I need to create two separate copy pipelines? I am new to ADF and enthusiastic about learning it

I want to get data from Azure data lake to on-prem SQL DB how to achieve it ?

Really a great sessions , Thanks for posting videos on ADF

Finally I am done by connecting to on prem SQL through self hosted IR, few chalenges were there
1) I have created login using sql authentication mode - Object explorer > Security > logins > New login
2) Then allowed access from object explorer > right click on login created > properties > set server roles then > user mapping then > grant from securables
3) status should be on Grant for connect to database engine 🙂

Hi Mam
Urgently required can we do this same thing using azure databricks.

Hi mam
How can i find my username and password while creating linked service for onpremises SQL server.please give replay mam

Could you please create a video on loading mainframe files to blob storage.

Hi, great video!! I am trying to copy data from blob to on premise postgresql. But the dataset not showing under Sink in copy data. Can you help? Or any related documents?

Hi,
Thanks for this very useful video. How is the performance, if there are 10 million rows in the table having 100 columns. The total data size may be of 10 GB.

Hi Mam,
Thanks you for such a great videos in simple and concise manner.
Que: Can We Split the SQL table rows to 100,100 chunk into different csv file while copying?? Please guide me mam.

Thank you for the video! How can I bring SQL data to Azure Table Storage?

Where we get these tables and how we put into SSMS. I am complete new beginner to Azure. Any help from your side.

I am not getting the option of file extension as .csv in the sink folder of my pipeline for which it is showing me error.

Nice Lecture Thank you

Hi akka adf saport emina evvagalara

thanks for the video

Hi, Thanks for the video. I would like to know how can we give custom file name in Blob storage?

In ssis we can change data type using data conversion
transformations while loading excel file into table.. I like ur video simple and clear explanation now could you please tell me is any transformations available in adf for the data type change while loading excel file into database...

Hi Madam, Is it possible to read data from Tabular model tables and load it into Azure DWH tables? I got this requirement in my current company as they have cooked data in tabular model So.