SQL Provisioning via SCIM

%3CLINGO-SUB%20id%3D%22lingo-sub-2220441%22%20slang%3D%22en-US%22%3ESQL%20Provisioning%20via%20SCIM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2220441%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20replace%20Oracle%20OIM.%26nbsp%3B%20For%20the%20windows%20users%20side%20of%20things%20I'm%20using%20the%20Workday%20to%20Azure%20AD%20Provisioning%20Service.%26nbsp%3B%20However%2C%20I%20also%20have%20a%20SQL%20DB%20that%20is%20holding%20users%20for%20our%20external%20portal%20and%20the%20staff%20users%20who%20support%20them.%26nbsp%3B%20I'd%20like%20to%20provision%20my%20staff%20users%20through%20the%20Azure%20provisioning%20services%20into%20that%20on%26nbsp%3B%20prem%20SQL%20DB.%26nbsp%3B%20Has%20anyone%20done%20anything%20like%20that%3F%26nbsp%3B%3C%2FP%3E%3CP%3EI%20believe%20that%20I%20could%20SCIM%20to%20make%20the%20connection%2C%20but%20don't%20know%20if%20SQL%202016's%20REST%20API's%20support%20that%20standard.%26nbsp%3B%20I'm%20new%20to%20the%20REST%20%2F%20SCIM%20world%20and%20hoping%20someone%20has%20already%20invented%20this%20wheel%20and%20could%20point%20me%20in%20the%20right%20direction.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETech%20Info%3A%3C%2FP%3E%3CP%3EAzure%20AD%20connected%20to%20CoLo%20facility%20via%20VPN%20tunnel%20with%20established%20network%20connectivity.%3C%2FP%3E%3CP%3ESQL2016%20in%20the%20Colo%3C%2FP%3E%3CP%3EAzure%20AD%20Connect%20already%20in%20place%20and%20syncing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20thoughts%20or%20advice.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E~M%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2220441%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20AD%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EIdentity%20Management%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESCIM%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Senior Member

I am trying to replace Oracle OIM.  For the windows users side of things I'm using the Workday to Azure AD Provisioning Service.  However, I also have a SQL DB that is holding users for our external portal and the staff users who support them.  I'd like to provision my staff users through the Azure provisioning services into that on  prem SQL DB.  Has anyone done anything like that? 

I believe that I could SCIM to make the connection, but don't know if SQL 2016's REST API's support that standard.  I'm new to the REST / SCIM world and hoping someone has already invented this wheel and could point me in the right direction.

 

Tech Info:

Azure AD connected to CoLo facility via VPN tunnel with established network connectivity.

SQL2016 in the Colo

Azure AD Connect already in place and syncing.

 

Thanks for any thoughts or advice.

 

~M

0 Replies