RE: [U2] [UV] server-side ODBC question
In case there is any interest - many years ago (14 - past hat etc) we built a complete U2 based interactive voice system with integrated telephony interface. It ran on x86 (SCO at the time) and used Dialogic 'phone cards and quite a lot of C code. Just to show it can be done inside U2.. Out of interest - is anyone still using it? Regards JayJay --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] server-side ODBC question
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, December 11, 2007 5:09 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] server-side ODBC question I'd recommend ShoreTel and Inter-Tel (MiTel). Both seem to beat Avaya. We are currently in the process of deciding between them, or an Asterisk solution (which is looking more and more tempting and not based on cost alone). Karl Karl, thanks for the tip. The project has been pushed back until Q3 of next year, so we have more time for research now. We're already planning to look into Shoretel and I'm going to add Mitel to the list. I'd be interested to hear who you end up picking and how the implementation went. -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] server-side ODBC question
Have you checked Ontario Systems? www.ontariosystems.com They use Cache. I can't say how their new stuff works because we have one of their products that is about 15 years old. However, we are still supported, which says a lot for a company. Jerry Banker Sr Programmer Analyst Affiliated Acceptance Corp Sunrise Beach, MO 1-800-233-8483 www.affiliated.org -Original Message- From: John Hester [mailto:[EMAIL PROTECTED] Sent: Monday, December 10, 2007 7:24 PM To: u2-users@listserver.u2ug.org 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] server-side ODBC question {Unclassified}
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: Monday, December 10, 2007 6:20 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] server-side ODBC question {Unclassified} [snip] 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. Thanks, Mike. Is it possible to write data to UV from the client application when connecting this way? -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] server-side ODBC question {Unclassified}
John asked Is it possible to write data to UV [from a remote ODBC client]? I'm not aware of any technical reason why not, but we work really hard to not allow it. :-) So I can't really say Regards Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Hester Sent: Wednesday, 12 December 2007 10:50 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] server-side ODBC question {Unclassified} -Original Message- From: [EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: Monday, December 10, 2007 6:20 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] server-side ODBC question {Unclassified} [snip] 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. Thanks, Mike. Is it possible to write data to UV from the client application when connecting this way? -John --- u2-users mailing list u2-users@listserver.u2ug.org 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] server-side ODBC question
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, December 11, 2007 6:29 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] server-side ODBC question Have you checked Ontario Systems? www.ontariosystems.com They use Cache. I can't say how their new stuff works because we have one of their products that is about 15 years old. However, we are still supported, which says a lot for a company. Thanks, Jerry. Glancing at their site it looks like they do outbound dialing. We're in need of an inbound call center application on top of an IP-PBX. So far we've looked at Avaya, Cisco, and Vertical. -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] server-side ODBC question {Unclassified}
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: Tuesday, December 11, 2007 2:50 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] server-side ODBC question {Unclassified} John asked Is it possible to write data to UV [from a remote ODBC client]? I'm not aware of any technical reason why not, but we work really hard to not allow it. :-) So I can't really say Thanks, Mike. Yes, I would think for most applications you'd never want to. We just need to write caller ID and agent extension into a file somewhere within UV so the agent taking the call can pull up the right account before answering. -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] server-side ODBC question {Unclassified}
Type 1/19 files are GREAT for this type of thing! Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of John Hester Sent: Wednesday, 12 December 2007 10:32 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] server-side ODBC question {Unclassified} -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: Tuesday, December 11, 2007 2:50 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] server-side ODBC question {Unclassified} John asked Is it possible to write data to UV [from a remote ODBC client]? I'm not aware of any technical reason why not, but we work really hard to not allow it. :-) So I can't really say Thanks, Mike. Yes, I would think for most applications you'd never want to. We just need to write caller ID and agent extension into a file somewhere within UV so the agent taking the call can pull up the right account before answering. -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] server-side ODBC question
I'd recommend ShoreTel and Inter-Tel (MiTel). Both seem to beat Avaya. We are currently in the process of deciding between them, or an Asterisk solution (which is looking more and more tempting and not based on cost alone). Karl quote who=John Hester -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, December 11, 2007 6:29 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] server-side ODBC question Have you checked Ontario Systems? www.ontariosystems.com They use Cache. I can't say how their new stuff works because we have one of their products that is about 15 years old. However, we are still supported, which says a lot for a company. Thanks, Jerry. Glancing at their site it looks like they do outbound dialing. We're in need of an inbound call center application on top of an IP-PBX. So far we've looked at Avaya, Cisco, and Vertical. -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] server-side ODBC question
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? I should also mention - we're running UV 10.1.4 on RH AS 3.0. Thanks, John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] server-side ODBC question {Unclassified}
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: u2-users@listserver.u2ug.org 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 u2-users@listserver.u2ug.org 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/