John "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." I'm fairly sure that's the recommended way of doing it, it's certainly the way we've done it. That way, you only 'expose' the particular file(s) and data element(s) you want to for ODBC consumption. That way you can also expose as simple-appearing I-Types, fairly complex inter-table joins and/or apply and security / filtering rules against your UV data.
We have a local user on the UV server that the remote server impersonates. This user has read access to the SQL-ised account only. The user ID & password are hard-coded in the remote server's ODBC setup - the IBM U2 ODBC Data Source setup (on the Clients CD) now encrypts this password, which is nice. We have a lot of DTS (SQL Server 2005 SSIS) packages which access our UV databases this way. Mostly it works fine, if at times a little slowly when the tables being extracted are large and the I-Types really complex. Regards Mike -----Original Message----- From: [EMAIL PROTECTED] On Behalf Of John Hester Sent: Tuesday, 11 December 2007 2:24 p.m. To: [email protected] Subject: [U2] [UV] server-side ODBC question 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/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
