|
Hi Audra,
If you configure your data definition to read data from multiple databases, all the data becomes available in the mappings window. For each variable that appears in the Visible Items of the mappings window, you can select the Database Column mapping type and then one of the available database columns. Each database-field name in the drop-down box mentions between parenthesis which database it is from.
There is no CardExchange limit as to how many databases you can link in a single data definition. However, you have to take into account that you should be able to relate records in one database to records in another database. This is done by means of the primary key. All linked databases should have a primary key field that contains the same value if the record is for the same person. Imagine that I have a HRM database and that the primary key is called EMPID, while there is also an access control database with a primary key called Id. If the record with data for John Smith in the HRM database has EMPID=678, then the recod with data for John Smith in the access control database should have Id=678. Otherwise it would be impossible to connect the to records with each other.
In practice, when linking to more than two databases, things tend to get very complicated and it is wiser to look for a software solution that maintains the relevant data in a single database. Such a solution could be a card management system, but also a synchronization routine that fills a database dedicated to ID-card printing.
_________________
Rutger Koperdraad
Senior Software Engineer
"A reasonable man adapts himself to the world. The unreasonable man persists in trying to adapt the world to himself. All progress, therefore, depends on the unreasonable man." (Bernard Shaw)
|
