On 28/07/2017 10:26, Dino Mifsud wrote:
Hi
I have a scenario where I need to sync users from Syncope to database. The
users in the database are not stored in one table so the mapping is not that
straight forward. Is there a way in Syncope to use custom SQL scripts (not
Groovy) to meet such requirements please?
If the users in the external database are not stored in a single table,
you cannot unfortunately use the DatabaseTable connector, which is
simpler and does not require any script.
The only option left is the Scripted SQL connector; template Groovy
scripts are provided in
https://github.com/apache/syncope/tree/2_0_X/fit/core-reference/src/test/resources/scriptedsql
...or you might want to write down your own connector but, believe me,
is way harder than customizing some Groovy scripts.
HTH
Regards.
--
Francesco Chicchiriccò
Tirasa - Open Source Excellence
http://www.tirasa.net/
Member at The Apache Software Foundation
Syncope, Cocoon, Olingo, CXF, OpenJPA, PonyMail
http://home.apache.org/~ilgrosso/
