RE: Windows server scripted sql + groovy
Hi, Ah yeah, forgot about the pull action interface. That is probably the right place for it. I’ll see what I can do with the office 365 thing. Basically, it is only a system call to a server with office 365 powershell installed. Even connid cmd could be a good start…☺ Regards, Mikael From: Francesco Chicchiriccò [mailto:ilgro...@apache.org] Sent: tiistai 4. huhtikuuta 2017 10.44 To: user@syncope.apache.org Subject: Re: Windows server scripted sql + groovy Hi Mikael, see my replies on-line. Regards. On 04/04/2017 09:35, Mikael Ekblom wrote: Hi, Ah, ok. The groovy-all.jar had to be moved into the syncope web-inf lib directory.So now we have two options: local file bundle and through the connid-server. Very well! Another question by the way. We have our HR-system as a cloud solution. It will be configured as an external resource of course. The thing now is that we are used to generate usernames according to an automated solution. We do not use firstname.lastname as the uid or samaccountname format. A recursive function so to speak based on the firstname lastname combination that we get from HR and other duplication checks etc. I cannot see that syncope will manage automated creation of username as for now from an external resource on the fly? Not even through transformations? I 'd say you need to code a PullActions class https://syncope.apache.org/docs/reference-guide.html#pullactions e.g. something that is invoked around your pull task execution, with option to mangle its input / output data. Please be aware that PullActions (as all other customizations) require to start with a Maven project: https://syncope.apache.org/docs/reference-guide.html#customization I think I will need to extend a connector for this task… and then the famous Office365 license thing that I think you had on the table too. Exactly, my personal TODO list keeps growing, though... :-/ From: Marco Di Sabatino Di Diodoro [mailto:marco.disabat...@tirasa.net] Sent: maanantai 3. huhtikuuta 2017 14.31 To: user@syncope.apache.org<mailto:user@syncope.apache.org> Subject: Re: Windows server scripted sql + groovy Hi Il 03/04/2017 12:44, Mikael Ekblom ha scritto: Hi, We or I have been playing around with syncope for a while. I have a question now regarding a scripted sql resource and groovy. What we are trying to achieve here, is to get the student accounts over from our home grown student administration system. The scripted sql connector bundle is available as per definition in the connid.properties file and is also available through the administrative panel. But, the log is complaining about the following: “java.lang.IlegalArgumentException: Language not supported: GROOVY” when the script language is defined. Check if in your connector server instance the groovy-all jar is present. If not, try to copy it from Syncope in the connector server. Regards M Some definition missing? I cannot pinpoint anything based on the documentation. I even tried to install groovy separately on the server itself, but it did not solve the problem. It would help a lot to get this done natively. Otherwise I need to implement another proxy repository for this task. Regards, Mikael -- 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/
Re: Windows server scripted sql + groovy
Hi Mikael, see my replies on-line. Regards. On 04/04/2017 09:35, Mikael Ekblom wrote: Hi, Ah, ok. The groovy-all.jar had to be moved into the syncope web-inf lib directory.So now we have two options: local file bundle and through the connid-server. Very well! Another question by the way. We have our HR-system as a cloud solution. It will be configured as an external resource of course. The thing now is that we are used to generate usernames according to an automated solution. We do not use firstname.lastname as the uid or samaccountname format. A recursive function so to speak based on the firstname lastname combination that we get from HR and other duplication checks etc. I cannot see that syncope will manage automated creation of username as for now from an external resource on the fly? Not even through transformations? I 'd say you need to code a PullActions class https://syncope.apache.org/docs/reference-guide.html#pullactions e.g. something that is invoked around your pull task execution, with option to mangle its input / output data. Please be aware that PullActions (as all other customizations) require to start with a Maven project: https://syncope.apache.org/docs/reference-guide.html#customization I think I will need to extend a connector for this task… and then the famous Office365 license thing that I think you had on the table too. Exactly, my personal TODO list keeps growing, though... :-/ *From:*Marco Di Sabatino Di Diodoro [mailto:marco.disabat...@tirasa.net] *Sent:* maanantai 3. huhtikuuta 2017 14.31 *To:* user@syncope.apache.org *Subject:* Re: Windows server scripted sql + groovy Hi Il 03/04/2017 12:44, Mikael Ekblom ha scritto: Hi, We or I have been playing around with syncope for a while. I have a question now regarding a scripted sql resource and groovy. What we are trying to achieve here, is to get the student accounts over from our home grown student administration system. The scripted sql connector bundle is available as per definition in the connid.properties file and is also available through the administrative panel. But, the log is complaining about the following: “java.lang.IlegalArgumentException: Language not supported: GROOVY” when the script language is defined. Check if in your connector server instance the groovy-all jar is present. If not, try to copy it from Syncope in the connector server. Regards M Some definition missing? I cannot pinpoint anything based on the documentation. I even tried to install groovy separately on the server itself, but it did not solve the problem. It would help a lot to get this done natively. Otherwise I need to implement another proxy repository for this task. Regards, Mikael -- 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/
RE: Windows server scripted sql + groovy
Hi, Ah, ok. The groovy-all.jar had to be moved into the syncope web-inf lib directory. So now we have two options: local file bundle and through the connid-server. Very well! Another question by the way. We have our HR-system as a cloud solution. It will be configured as an external resource of course. The thing now is that we are used to generate usernames according to an automated solution. We do not use firstname.lastname as the uid or samaccountname format. A recursive function so to speak based on the firstname lastname combination that we get from HR and other duplication checks etc. I cannot see that syncope will manage automated creation of username as for now from an external resource on the fly? Not even through transformations? I think I will need to extend a connector for this task... and then the famous Office365 license thing that I think you had on the table too. Regards, Mikael From: Marco Di Sabatino Di Diodoro [mailto:marco.disabat...@tirasa.net] Sent: maanantai 3. huhtikuuta 2017 14.31 To: user@syncope.apache.org Subject: Re: Windows server scripted sql + groovy Hi Il 03/04/2017 12:44, Mikael Ekblom ha scritto: Hi, We or I have been playing around with syncope for a while. I have a question now regarding a scripted sql resource and groovy. What we are trying to achieve here, is to get the student accounts over from our home grown student administration system. The scripted sql connector bundle is available as per definition in the connid.properties file and is also available through the administrative panel. But, the log is complaining about the following: "java.lang.IlegalArgumentException: Language not supported: GROOVY" when the script language is defined. Check if in your connector server instance the groovy-all jar is present. If not, try to copy it from Syncope in the connector server. Regards M Some definition missing? I cannot pinpoint anything based on the documentation. I even tried to install groovy separately on the server itself, but it did not solve the problem. It would help a lot to get this done natively. Otherwise I need to implement another proxy repository for this task. Regards, Mikael -- Dott. Marco Di Sabatino Di Diodoro Tel. +39 3939065570 Tirasa S.r.l. Viale D'Annunzio 267 - 65127 Pescara Tel +39 0859116307 / FAX +39 085973 http://www.tirasa.net Apache Syncope PMC Member http://people.apache.org/~mdisabatino/
Re: Windows server scripted sql + groovy
Hi Il 03/04/2017 12:44, Mikael Ekblom ha scritto: Hi, We or I have been playing around with syncope for a while. I have a question now regarding a scripted sql resource and groovy. What we are trying to achieve here, is to get the student accounts over from our home grown student administration system. The scripted sql connector bundle is available as per definition in the connid.properties file and is also available through the administrative panel. But, the log is complaining about the following: “java.lang.IlegalArgumentException: Language not supported: GROOVY” when the script language is defined. Check if in your connector server instance the groovy-all jar is present. If not, try to copy it from Syncope in the connector server. Regards M Some definition missing? I cannot pinpoint anything based on the documentation. I even tried to install groovy separately on the server itself, but it did not solve the problem. It would help a lot to get this done natively. Otherwise I need to implement another proxy repository for this task. Regards, Mikael -- Dott. Marco Di Sabatino Di Diodoro Tel. +39 3939065570 Tirasa S.r.l. Viale D'Annunzio 267 - 65127 Pescara Tel +39 0859116307 / FAX +39 085973 http://www.tirasa.net Apache Syncope PMC Member http://people.apache.org/~mdisabatino/