Re: [U2] Connecting to a Universe Database
John, You can use any UV/BASIC subroutine you like to be invoked remotely via ODBC. Some ODBC clients have various limitations on this. You can also use the IBM-supplied UCI C-API library or UniObjects or UO for Java, etc. The main design considerations you need to be aware would include: - re-using existing code make sense, but ensure you do any initialisation sequences as well (load common - file user credentials, other settings, open file variables, etc) - your subroutine should have either input or output arguments and no input/output arguments are permitted - I find it best to 'globally' catalog a subroutine, so it can be called from any account (if this applicable for your site/functionality required - make sure it does not request any terminal input (or it will abnormally terminate) - make sure you output to a log file the results of all processing (makes debugging a lot easier) to a file for both testing and production purposes How you invoke it from your remote system/application will vary. Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Castilletti Sent: Tuesday, 18 August 2009 10:45 AM To: U2 Users List Subject: Re: [U2] Connecting to a Universe Database David, Do you have examples for the use of UV/BASIC subroutines invoked as stored procedures from SQL Server/ Thanks, John From: Hona, David david.h...@cba.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Monday, August 17, 2009 7:20:03 PM Subject: Re: [U2] Connecting to a Universe Database It is highly recommended that you upgrade your version of UniVerse before you consider what interface to use. An ODBC interface is mostly the easiest to implemented, but the slowest and hardest to debug. Especially on such an old version of UniVerse. Further, unless you're UV data is in a format readily or easily translatable/accessible from SQL Server - then you'll be forced to use intermediary tables to bridge the updates. Imagine the worst-case scenario where your live UV database is irreversibly corrupted by erroneous SQL Server UPDATE statement(s). A potential work-around would be the use of UV/BASIC subroutine(s) invoked as a stored procedure from SQL Server to translate the underlying complexities of your UV database/application. Hence, helping to manage this risk of corruption (to an extent) and also potentially negating the need for multiple and complex SQL queries and update statements (potentially aiding performance). You don't mention the nature of the processing model. So you'll also need to also carefully consider the potential database lock contention issues and the impact of updates (esp. bulk updates) or queries on the performance of your UV system...should have a system that is already heavily utilised or has performance or reliability issues. Regards, David ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Connecting to a Universe Database
New project requirement to Connect to and Update the Universe Database from an external system. We will also need to Connect to and Update an external system (possibly SQL Server 2005) from the Universe System. We are currently using Universe 9.6... . What are the best methods/technologies that I should consider and those that I should avoid. Thanks in Advance for any feedback on this subject. John Castilletti ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Connecting to a Universe Database
We're using Easysoft's ODBC driver (http://www.easysoft.com/) for Microsoft SQL servers so we can update databases that are external to our Universe database. Universe already has ODBC drivers so that it can be updated from other servers. Barry Rutherford Programmer / Analyst MobilexUSA 920 Ridgebrook Rd, Sparks, MD 21152 Direct: 443-662-4162 Toll Free: 800-786-8015 ext. 4162 Fax: 443-662-4225 http://www.mobilexusa.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Castilletti Sent: Monday, August 17, 2009 9:47 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Connecting to a Universe Database New project requirement to Connect to and Update the Universe Database from an external system. We will also need to Connect to and Update an external system (possibly SQL Server 2005) from the Universe System. We are currently using Universe 9.6... . What are the best methods/technologies that I should consider and those that I should avoid. Thanks in Advance for any feedback on this subject. John Castilletti ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Connecting to a Universe Database
I'd look at sockets. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Castilletti Sent: Monday, August 17, 2009 9:47 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Connecting to a Universe Database New project requirement to Connect to and Update the Universe Database from an external system. We will also need to Connect to and Update an external system (possibly SQL Server 2005) from the Universe System. We are currently using Universe 9.6... . What are the best methods/technologies that I should consider and those that I should avoid. Thanks in Advance for any feedback on this subject. John Castilletti ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Connecting to a Universe Database
If you at the right release why not use External Database Access. That way you can use the standard UniVerse reads and writes. Hans Morawa -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Castilletti Sent: Monday, 17 August 2009 9:47 PM To: U2-Users@listserver.u2ug.org Subject: [U2] Connecting to a Universe Database New project requirement to Connect to and Update the Universe Database from an external system. We will also need to Connect to and Update an external system (possibly SQL Server 2005) from the Universe System. We are currently using Universe 9.6... . What are the best methods/technologies that I should consider and those that I should avoid. Thanks in Advance for any feedback on this subject. John Castilletti ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- This email and any files transmitted with it are confidential to the intended recipient and may be privileged. If you have received this email inadvertently or you are not the intended recipient, you may not disseminate, distribute, copy or in any way rely on it. Further, you should notify the sender immediately and delete the email from your computer. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Connecting to a Universe Database
another option is to use JDBC - this involves getting a JDBC driver for the target system (widely and freely available) and writing some fairly simple java code which uses Uniobjects to connect to the Universe database and the JDBC driver to talk to the SQL database.. cheers, asvin John Castilletti jcastilletti_1...@yahoo.com Sent by: u2-users-boun...@listserver.u2ug.org Aug 17 2009 14:47 Mail Size: 6159 Please respond to U2 Users List u2-users@listserver.u2ug.org To U2-Users@listserver.u2ug.org cc Subject [U2] Connecting to a Universe Database Entity Investment Banking Europe - IBEU New project requirement to Connect to and Update the Universe Database from an external system. We will also need to Connect to and Update an external system (possibly SQL Server 2005) from the Universe System. We are currently using Universe 9.6... . What are the best methods/technologies that I should consider and those that I should avoid. Thanks in Advance for any feedback on this subject. John Castilletti ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users HSBC Bank plc may be solicited in the course of its placement efforts for a new issue, by investment clients of the firm for whom the Bank as a firm already provides other services. It may equally decide to allocate to its own proprietary book or with an associate of HSBC Group. This represents a potential conflict of interest. HSBC Bank plc has internal arrangements designed to ensure that the firm would give unbiased and full advice to the corporate finance client about the valuation and pricing of the offering as well as internal systems, controls and procedures to identify and manage conflicts of interest. HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ, United Kingdom Registered in England - Number 14259 Authorised and regulated by the Financial Services Authority. - SAVE PAPER - THINK BEFORE YOU PRINT! This transmission has been issued by a member of the HSBC Group HSBC for the information of the addressee only and should not be reproduced and/or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Connecting to a Universe Database
It is highly recommended that you upgrade your version of UniVerse before you consider what interface to use. An ODBC interface is mostly the easiest to implemented, but the slowest and hardest to debug. Especially on such an old version of UniVerse. Further, unless you're UV data is in a format readily or easily translatable/accessible from SQL Server - then you'll be forced to use intermediary tables to bridge the updates. Imagine the worst-case scenario where your live UV database is irreversibly corrupted by erroneous SQL Server UPDATE statement(s). A potential work-around would be the use of UV/BASIC subroutine(s) invoked as a stored procedure from SQL Server to translate the underlying complexities of your UV database/application. Hence, helping to manage this risk of corruption (to an extent) and also potentially negating the need for multiple and complex SQL queries and update statements (potentially aiding performance). You don't mention the nature of the processing model. So you'll also need to also carefully consider the potential database lock contention issues and the impact of updates (esp. bulk updates) or queries on the performance of your UV system...should have a system that is already heavily utilised or has performance or reliability issues. Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Castilletti Sent: Monday, 17 August 2009 11:47 PM To: U2-Users@listserver.u2ug.org Subject: [U2] Connecting to a Universe Database New project requirement to Connect to and Update the Universe Database from an external system. We will also need to Connect to and Update an external system (possibly SQL Server 2005) from the Universe System. We are currently using Universe 9.6... . What are the best methods/technologies that I should consider and those that I should avoid. Thanks in Advance for any feedback on this subject. John Castilletti ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Connecting to a Universe Database
David, Do you have examples for the use of UV/BASIC subroutines invoked as stored procedures from SQL Server/ Thanks, John From: Hona, David david.h...@cba.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Monday, August 17, 2009 7:20:03 PM Subject: Re: [U2] Connecting to a Universe Database It is highly recommended that you upgrade your version of UniVerse before you consider what interface to use. An ODBC interface is mostly the easiest to implemented, but the slowest and hardest to debug. Especially on such an old version of UniVerse. Further, unless you're UV data is in a format readily or easily translatable/accessible from SQL Server - then you'll be forced to use intermediary tables to bridge the updates. Imagine the worst-case scenario where your live UV database is irreversibly corrupted by erroneous SQL Server UPDATE statement(s). A potential work-around would be the use of UV/BASIC subroutine(s) invoked as a stored procedure from SQL Server to translate the underlying complexities of your UV database/application. Hence, helping to manage this risk of corruption (to an extent) and also potentially negating the need for multiple and complex SQL queries and update statements (potentially aiding performance). You don't mention the nature of the processing model. So you'll also need to also carefully consider the potential database lock contention issues and the impact of updates (esp. bulk updates) or queries on the performance of your UV system...should have a system that is already heavily utilised or has performance or reliability issues. Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Castilletti Sent: Monday, 17 August 2009 11:47 PM To: U2-Users@listserver.u2ug.org Subject: [U2] Connecting to a Universe Database New project requirement to Connect to and Update the Universe Database from an external system. We will also need to Connect to and Update an external system (possibly SQL Server 2005) from the Universe System. We are currently using Universe 9.6... . What are the best methods/technologies that I should consider and those that I should avoid. Thanks in Advance for any feedback on this subject. John Castilletti ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Connecting to a Universe Database
From: Hona, David It is highly recommended that you upgrade your version of UniVerse before you consider what interface to use. An ODBC interface is mostly the easiest to implemented, but the slowest and hardest to debug. Especially on such an old version of UniVerse. ... From: John Castilletti David, Do you have examples for the use of UV/BASIC subroutines invoked as stored procedures from SQL Server/ Such complications are actually unnecessary. In SQL Server, your stored proc can simply open a UO.NET connection directly into UV. Or you can invoke a web service call which then invokes a BASIC subroutine - this gives you some freedom to separate tiers. See a video I created that shows how easy it is to create a web service to any MV environment: remove.pleaseNebula-RnD.com/products/gallery.htm I use mv.NET there but you can as easily use UO.NET for that simple exercise. [AD] Having watched this discussion to see what suggestions came up, I would be remiss not to mention that mv.NET is an ideal solution for a few reasons, and that my company, Nebula RD, is a worldwide provider of mv.NET and related development services. - No need to upgrade your DBMS. - You can access your DBMS in a few ways, whether in a UniObjects-like manner by opening a connection and running a BASIC program, or writing to files/items directly. Or you can create a simple middle-tier that looks like any other relational model (with DataSets, DataTables, Columns, Rows, etc) and you don't need to do anything to your data or dicts to get these benefits. We can provide an interface for you, to your spec, and you won't need to deal with the details, or I can provide you with a free 30 day evaluation of mv.NET to see if it meets your needs as a developer. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users