Attaching external data to a user account

[Austin]

I am new to atlassian products, we are rolling out Confluence for an internal knowledgebase and will be giving our clients access. I have an external service desk, Autotask, that we plan to store service IDs for our customers. These service IDs get pulled down by an app I wrote and stored in a database on a local server, along with KPIs from our services for reporting  purposes. I want to attach these service IDs to our client user accounts in Confluence for the purpose of showing them only the relevant  information/services to their network (we are an MSP). Is there any way to store global variables on a per user basis, synced externally? I am using the SQL macro from bob swift to pull data tables down from an external DB for reporting on service information, but the way I understand it that is only good for presenting data in a page and not storing user information sitewide. What is the "atlassian way" to accomplish this, or am i trying to put a square peg in a round hole?

[Austin · Accepted solution]

I ended up storing all our IDs in our CRM, used SQL to pull down who owned what services, linked that info to the confluence page name in our database, and with a joinwas able to select data for individual users. 

[Aron Gombas _Midori_]

The User Profile app can extend the built-in property set of user accounts in Confluence by adding new properties.

I am not familiar with this, and it does not mention database integration, but:

1. It has a REST API you could use the manage your "service ID" property.
2. Or, it integrates with LDAP, so you could eventually wrote the "service ID" to an LDAP system instead of a database.

Or you should also check out the Linchpin User Profile app which can sync data from an XML file! This is much easier to periodically produce an XML from the database than managing an LDAP.