Two points: First, we have a product that does this for you. You can see it here: http://www.fwic.net/Products/MultiValueProducts/FusionWaremvLynxConnectAPI.aspx
It uses Universe's built-in HTTP GET/POST capability to call a local web services layer that in turn uses the SQL Server JDBC driver (from Microsoft) to interact with SQL Server. We also talk to Oracle, DB2, DB2/400, MySQL and Progress OpenEdge and could probably work with most JDBC drivers. Our Connect API product uses connection pooling in the web services layer, so it really screams. Secondly, as noted, you can use the SQL Server JDBC driver, if you want to roll-your-own solution. No bridge required... SQL Server connects are relatively quick, so connecting every time you shell out is not that painful unless you do a ton of volume. Some of the other relational databases have very painful connect times. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Symeon Breen Sent: October-06-11 1:19 AM To: 'U2 Users List' Subject: Re: [U2] Question about accessing external SQL database The bridge is required because there is no ms sql odbc driver for linux. An alternative would be to use an install of UV on a windows machine to do the actual odbc interaction, it would just use the standard ms odbc driver. This in turn could communicate somehow to your main HP uv install the required data (i.e. csv file, uv.net, soap etc). Or as you say write a web service that runs on a windows machine and can acquire the data. Or write a .net console app for windows that gets the data and uses uniobjects.net to send it back to your UV install. The app can be instantiated via the windows scheduler every x minutes, or maybe using Cygwin or samba from the HP box. ... Rgds Symeon. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jason Lin Sent: 06 October 2011 01:02 To: U2 Users List Subject: [U2] Question about accessing external SQL database Hi, I am exploring a good way to access data on an external SQL database from our Universe (10.2.7) environment running on HP-UX (11.23). I personally prefer to use SOAP API in Universe BASIC to query the database provided the appropriate web service is available. However, the owner of the SQL database prefer not to create web services for this purpose because his dept will need to maintain an additional web server. (Alternatively, we could create our own web service on a Windows 2003 server which can connect to the SQL database server directly). Instead, he offers two options: direct database connection to SQL database (possibly via ODBC) or RPC. I'm not familiar RPC in Universe but after reading documentation on RPC.CONNECT and RPC.CALL functions, it looks like they were designed for Universe to Universe (or Universe to Unidata) type of remote procedure call. Is that correct? So the only other option is to use SQL/ODBC. After reading some archived message from this mailing list, it looks we would need to install a third party ODBC bridge/manager. Several messages recommended Easysoft ODBC-ODBC Bridge but Easysoft lists its price at $2000! Does anyone know if there any other ways of accessing external SQL database from Universe? Thank you. Jason _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ----- No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1410 / Virus Database: 1520/3939 - Release Date: 10/05/11 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
