Database integration is not a straight forward task. Most of the time it's done using a script or a process that is invoked on schedule. Usually you want to do something when a data is changed. This can be done easily from the source code of the process modifying the data. However, this is not always possbile as it requires access to the source code, and skills in the technology used. This leaves us with very limited options.
In this series we discuss each method separately. We try to generalize and remain vendor neutral, however in some posts we will focus on postgresql specific functionality.
For each solution we will do a quick comparison table based on the following criteria
| Criteria | description |
| Requires Polling | |
| Scalable for many tables | |
| Vendor neutral | |
| Platform independent | |
| Performance |
No comments:
Post a Comment