Yesterday I was demonstrating IOM 1.8.3 and came across the Advanced tab. This being a new feature, my team and I were interested in how we might use this read-only connection to a Raiser's Edge SQL database. To test we specified an SQL database we maintain for another product (SmartCall) and it connected.
What types of use might this option to specify a separate database have? Is this function RE database specific? Why read-only?
The advanced tab allows you to specify alternate Raiser's Edge database credentials to use for duplicate searching if the default credentials do not work or if your DBA wishes you to use another login. This option is rarely used, but occasionally necessary. We specify "read-only" because it is used for duplicate searching only as all updates are through the RE object model.