The best approach is to create a custom Joomla authentication plugin. On login attempt you'd check those credentials against your other site to make sure they're valid and they exist. If they're valid and they do exist then compare their profile data and last update date to see which profile is most up to date then synchronize the data as needed depending on which is most up to date. If the user doesn't exist on one of the sites you'd then just create them at this time or let CB do it.
Nicks approach also works by using CB Auto Actions on the after registration and after profile update triggers with a Query action. The query action can act on External databases so it's possible to use substitutions to substitute profile data into your query to the external site. The problem with this method is you need to maintain 3 tables at minimum (_comprofiler, _users, and _user_usergroup_map).
Kyle (Krileon)
Community Builder Team Member
Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums
CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.