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 <[email protected]> Sent by: [email protected] Aug 17 2009 14:47 Mail Size: 6159 Please respond to U2 Users List <[email protected]> To [email protected] 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 [email protected] 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
