Write Data to SQL Table from AD or PowerApp

[lmrogers]

Afternoon,

 

I'm looking at ways to either write data back to an SQL table from either a powershell script to sync a AD attribute to an SQL Table or creating a Power App that can read data from an SQL Table and then allow us to add a value in?

 

Has anyone ever done anything like this at all?

 

Thanks

[Ditto]

Not personally, but when I was a development manager our major product made excellent use of SQLite, but not via powershell but I sure it's possible. Have a look at SQLite and PowerShell – Rambling Cookie Monster, it might be a pointer in the right direction.

[limbo]

This is definitely possible - in the past I have used an SQL table to combine data from the MIS and AD to identify where accounts need to be created (and then create them), to allow staff to change student passwords, to set permissions on folders etc.

 

I used Visual Basic as the basis, this can access the various data sources and then run DOS commands / PowerShell commands / Batch files etc.