We cant perform the export operation in bulk; we can only do it per person.When we try to export multiple at once, it dowloads as an Excel file.But when it's dowloaded this way, we cant upload it to individual profiles. Do you know any way we can export this data in bulk?
+5
Hello ,
It is not possible to get user profiles in bulk in the standard method. Because it checks the data contained in each profile and prepares XML one by one. You can develop a procedure that will write them to the DB side in bulk in a loop, but this process will probably take much longer than downloading them one by one.
+9Hi Sena,
what about a direct link from MS SQL Server via MS Linked Server settings into the ORACLE database?
This is not something you give every user but you can use / copy your ORACLE data into a DWH database and there create DataMarts or any excel exports you want.
Because your data are in the Microsoft “world” it is very easy to share them with excel, PowerBI, you name it.
Mainly our customers use that technology to create a BI-solution but why not use that way to export any data you want?
Give me a private message or contact me via LinkedIn.
BR
Michael
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.