Power Automate Desktop || Module 6 : Database (Open and Close SQL Connection, Execute SQL Statement)

[@bhaveshzala9006]

Thanks for such a nice informative video, to the point...

[@mohamedatallah7845]

Very nice example, Keep going :)

[@LearningTechnologies]

Sure , with all your support. Thank you Mohamed Atallah

[@manojk6258]

How to connect oracle database?

[@Lennings82]

if i have a internet domain that host my webpage. and in may domin i have a database with all the users that can log in. can i connect to this database over the internet?

[@habimuc8959]

Hi sir, thanks for this clear description. I‘ve the problem, that the query results is exporting in one cell of excel, not the single database field in single cells of excel. Any idea? Thanks for your reply. HaBiMuc

[@amminenikiran3509]

Here I can see only we are copying data present in the table, Can we copy with columns headers as well ???

[@Boomtiger47]

So the only option is to write the query into an excel file? I was hoping to assign data from the query into their own variables within my desktop flow. That way I can have the flow paste this data into certain fields of my legacy system.

[@shahjehanmukoon7442]

can we have the column name as well when importing sql result to excel?

[@brijendraydv]

Thanks this is really helpful and it works the way i wanted however how can i schedule this as the saved flow is not appearing in cloud?

[@vijaykrishnan4151]

The column headers are not transferred to Excel , how to do that?

[@v75tan]

how for data table - I need to manipulate i.e. filtering, sorting, adding, manipulating some columns data in it, even creating new data table from the previous data table, adding new rows in the data table, etc.

[@samikpal3583]

Thanks for this. Is it possible to write the Query result in a csv file instead of excel. Excle has row limitation and I have large table that would surpass the limitation unless I can write the output to a csv file. Many thanks in advance.

[@diazjubairy1729]

Does this tutorial works also for connecting sql server in virtual machine to power automate ?

[@sarveshnundram866]

Hi Mr Ameer - What if we want query result to be written on different rows? for example ID 1 on cell B1 and ID 2 on cell Z1 ?

[@Lennings82]

hi. Is it possible to use one sql output in another sql? like SELECT * FROM %query%

[@luisfmts]

Very usefull

[@LearningTechnologies]

Thank you

[@sajjadul]

Ameer, how to write the column header in excel output?

[@swankyshivy]

do you have opposite? excel to sql server or ms access db?

[@sowmya9710]

Hello , thank you for the clear explanation. Can you kindly provide on how will be the CONNECTION STRING , using "sql server authentication" . Also have SSMS installed , do we need to install any more softwares for this process , using sql server authentication in this desktop flows? Kindly suggest.

[@sowmya9710]

Hello, can you please provide an example for the connection string as i mentioned.

[@sanjaynoudiyal9467]

Thank you so much sir for explaining everything as easily to make understand us. Sir i need your help once, I usually fatch the data manually from a software to excel. So I am unable to understand it how it can be automated. Sir please let me know best ways for this. Regardless - Sanjay.

[@LearningTechnologies]

Sure I will help you

[@sanjaynoudiyal9467]

@@LearningTechnologies sir how can I connect with you and when you have time? Please confirm once. Thank you so much.

[@LearningTechnologies]

You can Contact me on my email ID.

[@sanjaynoudiyal9467]

Sir please share your mail id. Thank you.

[@LearningTechnologies]

[e-mail]

[@pashupatimishra9335]

Awesome

[@LearningTechnologies]

Thank you

[@Truthhurt419]

Thanks for video. While exporting it's not including header. How can we handle this ?

[@chetanvasantrote7646]

Hi Ameer, You are doing a great job. I am learning Power automate through the videos you have created Thanks for the great videos. I had 1 question Can we update the Microsoft dataverse table from the Desktop Flow?

[@wagwewaltz5748]

Excellent presentation. Your data was extracted to excel without table headers. How can that be added

[@TheKalipolis]

Hello! Thank you so much for your videos. Do you have one where I can import an Excel file into a SQL database?

[@LearningTechnologies]

Let me check

[@sohilsanghavi774]

Hi Ameer, When I try to connect to SQL DB, it gives message as "The select permission was denied on the object '[table name[' , database [databasename], schema[dbo].". Any help would be appreciated thanks.

[@stevencleves8992]

Thank you for your video! I have a problem to connect a MySQL Workbench Database to Power Automate Desktop. Can someone help me out?

[@LearningTechnologies]

Sure. please share the details Steven

[@stevencleves8992]

@@LearningTechnologies How do I typ in in the connection string the port number? For Example: Database = Data01 Port =3332?

[@tedwow2625]

same problem here... :(

[@haameemshimar8828]

iam using the power automate for the first time.is the power automate free for oracle database connection??

[@rajenderreddy5035]

"Error in SQL statement The Microsoft Access database engine stopped the process because you and another user are attempting to change the same data at the same time". getting the above error while updating the excel column and file needs to be in open state. ANy idea how to overcome this issue

[@mattongbp]

How to insert into the DB from the excel file?

[@LampattheDoor]

Thanks for this. I can't seem to find how to get/download the power automate desktop app. Can you (or anyone) recommend a link?

[@LearningTechnologies]

Go through this kzbin.info/www/bejne/m5PIgaiFptF6eqM

[@kvniranjan12]

Can I connect to Oracle database?

[@LearningTechnologies]

Yes we can . We need to use oledb providers

[@kvniranjan12]

@@LearningTechnologies Tried it...but not able to connect...Will be helpful if we have a video sir

[@purushottamw]

How do we keep the Header in excel while getting data from SQL?

[@raphaelbonillo2192]

How can I send an email when a new record is created on SQL Server table?

[@LearningTechnologies]

Yes possible

[@raphaelbonillo2192]

@@LearningTechnologies It would be wonderful if you did that! Ha, ha! Your job is fantastic. Congratulations!

[@rajesh123sharma1]

Hi I am facing the runtime error

[@khodzhaeva.malika]

Good afternoon, please tell me how to connect to Oracle?

[@Johann75]

Nice, but works extremely slow for me and Close SQL Connection does not work. Also, cannot save the flow.

[@gustarinanurfadilah2436]

How to Install Microsoft SQL Server Management Studio ?

[@LearningTechnologies]

kzbin.info/www/bejne/p6vUmqiGdrRmm8k

[@gustarinanurfadilah2436]

@@LearningTechnologies thank you so much

[@LearningTechnologies]

Welcome

[@VidhiGohel-b4o]

How to connect Database with SQL server Authentication (Login id and password)

[@fernandomallorua1702]

Please, can you add subtitles for this video?

[@LearningTechnologies]

I will try Fernando