Adobe Campaign provides the Federated Data Access (FDA) option in order to process information stored in one or more external databases: you can access external data without changing the structure of Adobe Campaign data.
The FDA option allows you to extend your data model in a third-party database. It will automatically detect the structure of the targeted tables and use data from the SQL sources.
In order to use this capability, prerequisites are listed below:
Configuration: the list of compatible external database depend on your hosting model.
External database version: you need to have an external database that is compatible with the Adobe Campaign FDA module.
The list of database systems and compatible versions per hosting model is detailed in Campaign Compatibility matrix.
Permissions: users must also have the necessary permissions in Adobe Campaign and on the external database.