We're evaluating phone systems and need to access our UV customer data for call routing. One of the systems (Vertical Televantage) can only communicate with other databases via ODBC. In this scenario, UV would need to be the ODBC server and Televantage the client. Caller ID would be passed to UV, and it would return back whatever customer data we might want to use to route to the appropriate call center agent.
Back around '03 I explored something similar with our SQL Server based CRM application and ended up making UV the ODBC client instead. Seems like I couldn't find a way to go the other direction except via a desktop VB app - not in the background as a service. I did successfully connected to UV as an ODBC server from Excel some years back, but again, that was via the desktop. I also remember setting up a separate SQL-ized UV account and Q-pointers back to my Pick flavor account's data to make that work. That was on a different platform and version of UV, though. Has anyone done something similar using ODBC and UV as the ODBC server? Does what I remember about the process still hold true, or am I completely off base? Thanks, John John Hester System & Network Administrator Momentum Group (949) 833-8886 x623 http://www.themomgroup.com ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
