Inside Activate
Connectors
Recipes & Patterns
4 min
hr to user lifecycle connector goal synchronise an hr feed into activate to automatically create, move, and disable users \<workflow> \<clearimport /> \<import> \<provider>innovation activate library\innovation activate connectors importsql\</provider> \<connectionstring>server=sql01;integrated security=true;initial catalog=hrdb;\</connectionstring> \<sql>exec dbo getactiveemployees\</sql> \</import> \<processimport /> \<process> \<provider>innovation activate library\innovation activate connectors userchangehandler\</provider> \<user> \<link name="user account"> \<scope>=//roles/system roles/users\</scope> \<match when="employeenumber">(employeenumber=%=//current/employeenumber%)\</match> \</link> \<enabled>=/isactive\</enabled> \</user> \<events> \<create> \<submit> \<task>=//tasks/user/create user\</task> \<arguments> \<user> \<firstname>%=//current/firstname%\</firstname> \<lastname>%=//current/lastname%\</lastname> \<email>%=//current/email%\</email> \</user> \</arguments> \</submit> \</create> \<delete> \<submit> \<task>=//tasks/user/disable user\</task> \<arguments> \<user>=//user\</user> \</arguments> \</submit> \</delete> \</events> \</process> \</workflow> department hierarchy to role tree goal build a complete activate role structure from department hierarchy data \<workflow> \<clearimport /> \<import> \<provider>innovation activate library\innovation activate connectors importtext\</provider> \<filename>c \imports\departments csv\</filename> \<headers>true\</headers> \</import> \<processimport /> \<process> \<provider>innovation activate library\innovation activate connectors rolechangehandler\</provider> \<role> \<root>=//roles/departments\</root> \<key>departmentcode\</key> \<field>departmentcode\</field> \<parent>parentcode\</parent> \<name>=/department\</name> \<parameters> \<departmentcode name="departmentcode" type="string">=/departmentcode\</departmentcode> \</parameters> \<events> \<missing> \<createrole> \<description>created by import %=//system/now%\</description> \</createrole> \</missing> \</events> \</role> \</process> \</workflow> ticket synchronisation example goal synchronise external service desk tickets and update state in activate \<workflow> \<clearimport /> \<import> \<provider>innovation activate library\innovation activate connectors importsql\</provider> \<connectionstring>server=sql01;integrated security=true;initial catalog=tickets;\</connectionstring> \<sql>select from externaltickets\</sql> \</import> \<processimport /> \<process> \<provider>innovation activate library\innovation activate connectors servicedeskticketchangehandler\</provider> \<ticket> \<match field="ticketnumber">=/ticketnumber\</match> \</ticket> \<events> \<update> \<ticket> \<ticketnumber>=/ticketnumber\</ticketnumber> \<state>=/state\</state> \<status>=/status\</status> \<notes>=/notes\</notes> \</ticket> \</update> \</events> \</process> \</workflow> combining connectors use multiple connectors to manage different domains (e g , hr → users, departments → roles, tickets → service desk) keep imports lightweight by focusing each connector on a single purpose chain connectors via scheduled workflows for dependent updates testing patterns run connectors with small datasets until results are validated use processimport/maxchanges guardrails monitor connector data tables directly for unexpected deletions trigger a manual workflow run before enabling schedules