1.) In the simpliest, least expensive way, we'd like to create a link to an external Oracle database. From what I understand the db lookup node can only query SQL databaes. Has anyone had any experience linking to Oracle db's? I understand a we'd have to have a Gateway Host?
2.) Also, has anyone had any experience with databases that could potential return more than one record? In our case, a caller would enter their Social Security Number (SSN) or Tax Identification Number (TIN), which could possibly return two records. We haven't been able to run test queries yet to determine if it would return only the first record found, fail completely, or attempt to return both. Can anyone offer any words of wisdom on this?
Thanks for your help!