Use Active Directory Data in XMPie Campaign

[Igor]

I had several customers interesting  to fetch extra data Active Directory Data in uStore or in XMPie Campaign.

I posted many articles that since XMPie can connect as from uPlan / uProduce and uStore to SQL Sever DB , we can use a power of SQL Server DB to fetch data .

SQL Server using Linked Server can fetch data from Active Directory and hence we can do a very cool things .

Like try to fetch missing data in LDAP Authentication for particular user or be able to create recipient list based on AD .

Now there are many articles on how to fetch data from AD using SQL Server .

I used this one   for example  http://blog.skufel.net/2012/01/how-to-use-sql-server-to-query-active-directory

(please read it first)

Please make sure that you understand security context that your query is going to run or it will fail 

in my case I used a specific user  

Now I followed articles and just checked that I can run the query against my AD

now we can crate in our DB view with names appropriate to  your schema  that can be referenced as from uPlan / uProduce  or uStore (using built in recipient List plu-in or using DB bound feature of customizations )

Now we can query this view and even pass variable in uPlan if needed 

Now you can use it as a recipient list even in uStore , for more advanced options you will need a more advanced recipient list plug-in like GDBRL for XMPie Professional Services  document attached . For more information you can contact XMPie Professional Services .

Igor. 

[kw]

This works like a gem! Thank you Igor!

[Jim de Zwart]

Hello!

I have yet to set up a test store for this, but if anyone has knowledge
on using Azure Multi Factor Authentication (MFA) with the AD / LDAP user
authentication module with XMPie uStore, I'd love to know!


Thank you!