External Database PRO

Users Anywhere Pro can read Joomla users from another configured database connection.

Configure the Connection

Under Advanced in the Users Anywhere system plugin settings, add a named external database and enter its database type, host, username, password, database name, and table prefix.

You can also enter the public domain associated with that Joomla site. Users Anywhere uses it to turn local href and src values from the external data into URLs for that domain.

Select the Database

The database="name" attribute works with the single {user} tag and the Pro multiple-user {users} tag:

{user id="42" database="directory"}[name]{/user}

{users usergroup="Customer" database="directory"}
[name]
{/users}

The attribute value must match the connection name in the plugin settings. If the named connection is unavailable or does not return a matching user, Users Anywhere renders its normal empty fallback and does not expose connection details.

The Joomla tables in the external database must use the configured table prefix and a schema compatible with the data being requested.