[U2] job posting Application Developer
UniVerse Applications Developer This position exists to provide the highest quality of software development and user support. It includes new application development and maintenance of existing software, as well as implementing new technologies. We are a multi-site UniVerse shop running a highly customized version of Information Solution's TMC trucking package. We have web and SQL back-ends that provides our users with the interfaces and tools they need while leveraging our legacy software's strong and flexible base, and are currently researching the best way to deliver a graphical front-end. Your strong business background, user support orientation and willingness/ability to learn is as valuable as your specific technical background. This is a full-time position. It includes paid vacation, and health/dental insurance and 401K are available. Location: Houston TX or Denver CO. Other possibilities may exist. Relocation assistance is provided. DUTIES AND RESPONSIBILITIES: .Design, Code, Test and Debug source code based on user requirements and specifications. .Provide technical consulting to users to address system issues and recommend solutions. .Troubleshooting, bug fixes and enhancements to existing software. .Assist users with creation of functional specifications for new projects. .Shared responsibility for 24/7 support. .Other job-related duties as assigned. .Some evening/weekend work may be required (rarely). .Some travel is required. JOB REQUIREMENTS: .5+ years of professional experience developing in a Multi-Value environment. .Clear understanding of business accounting. .Working knowledge of MS Windows. .Ability to communicate effectively, both orally and in written form, to a wide variety of individuals within the organization. .Willingness to take on responsibilities and challenges, plus a desire to learn. .Enjoy making user's jobs easier. .Constant attention to customer service. .Excellent teamwork skills. .Excellent time-management and organizational skills. .Self-motivated and goal-oriented. .Interest in adopting new technologies as needed to support the business. .Experience with VBScript, JavaScript, HTML, SOAP, XML, MS Access, SQL is a plus, but not required. Email resumes and/or questions to: mailto:jcederv...@comcast.net jcederv...@comcast.net ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] SOAP over HTTPS
Yes, there's a SOAPCreateSecureRequest that works. Or at least the person who wrote the code below claims it works. I can't help you with specifics, as someone else wrote it. This was written for UniVerse. (I started on these SOAP calls for some QualComm webservices last week, and haven't had much luck with my code yet!) URL = https://truck-pc.net/WebServices/v1.1.7/DriverTechService.asmx?/WSDL; SOAPAction = https://truck-pc.net/WebServices/v1.1.7/GetReport; * CREATE SECURITY CONTEXT RCODE = createSecurityContext(ctx, ) IF RCODE=0 THEN CRT 'createSecurityContext OK' END ELSE STOP 'ERROR - createSecurityContext - ':RCODE END * Add authentication rule RETURN = addAuthenticationRule(ctx, 2, VerificationStrength, generous) RETURN = addAuthenticationRule(ctx, 2, PeerName, truck-pc.net) * CREATE SOAP REQUEST HANDLE RCODE=SOAPCreateSecureRequest(URL,SOAPAction,SoapReq,ctx) IF RCODE=0 THEN CRT 'SOAPCreateSecureRequest OK' END ELSE STOP 'ERROR - SOAPCreateSecureRequest - ':RCODE END - Janet Mission Petroleum Carriers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Hiscock Sent: Tuesday, September 16, 2008 2:14 PM To: u2-users@listserver.u2ug.org Subject: [U2] SOAP over HTTPS Has anyone implemented the UniData SOAP functions over an HTTPS URL? The CALLHTTP stuff, on which the SOAP stuff is built, has an option for creating a secure request, but the soapcreaterequest function doesn't seem to have the equivalent. Is there such a beast, or do I need to revert to the lower level callhttp protocols? FWIW, I'm on UniData 6.1, and writing a webservice CONSUMER ... TIA Larry Hiscock Western Computer Services --- 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] Question about the U2 News Flash...[AD]
Hi Bob, FusionWare Direct ADO.Net Provider supports Microsoft Visual Studio 2008. We have a session at Spectrum reviewing Visual Studio 2008. Please contact me for more information. Janet Bond 1.866.266.2326 x159 [/AD] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Friday, February 29, 2008 6:42 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Question about the U2 News Flash... Thanks for those who came back The only thing is that the .net databse add ins need visual studio 2005 and we have 2008 Any ideas IBM listening ? Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: 29 February 2008 10:04 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Question about the U2 News Flash... Bob et al If anyone is interested I've done a writeup of the new ADO.NET provider in the next issue of Spectrum (that's www.intl-spectrum.com for details). It seems to work pretty well, especially if you restrict it to calling remote procedures. Use SQLExecDirect() in a BASIC subroutine and assign the result to @HSTMT. You could do the same with OleDB, but it seems to work cleaner with this provider.. that might just be my impression. I'd stick to UniObjects or UO.NET for any transactional updates though. Brian I didn't get the news flash Could someone forward it please sounds like just what I need Thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: 28 February 2008 17:40 To: u2-users@listserver.u2ug.org Subject: [U2] Question about the U2 News Flash... I just got the February News Flash, and am confused about some offerings - perhaps someone can help: 1) U2.NET Beta available and 2) developerWorks article on U2 and IBM Data Server Provider for .NET So... These two items are both to get .NET code working, but each uses a different process to do it? Is the U2.NET going to 'obsolete' the logic and ideas presented in the IBM DSP article? Seems like IBM is pushing full steam ahead on .NET -- the new SB+/XA included... The question is how do I/we know which 'avenue' to follow? What is the general take? U2.NET worth holding out for compared to using the ServiceProvider? I've only started playing with this functionality to know what options are there - is U2.NET going to make things easier and worth waiting on? David W. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ Confidentiality Notice: This e-mail and any attachments are intended solely for the addressee and may contain confidential or privileged information. If you are not the named addressee, or the person responsible for delivering the message to the named addressee, please notify the sender as soon as possible and delete the material from your computer. This message will be protected by copyright. If it has come to you in error, you must not take any action based on its contents nor must you copy or show the message to any person other than the intended recipient. _ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- 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/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ Confidentiality Notice: This e-mail and any attachments are intended solely for the addressee and may contain confidential or privileged information. If you are not the named addressee, or the person responsible for delivering the message to the named addressee, please notify the sender as soon as possible and delete the material from your computer. This message will be protected by copyright. If it has come to you in error, you must not take any action based on its contents nor must you copy or show the message to any person other than the intended recipient. _ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email
RE: [U2] - Websphere MQ [AD]
Hello Marc, If you would like I can setup a conference call with one of our developers. We have implemented our FusionWare Integration Server with UniVerse to move data bi-directional. At this point we have connected with SQL Server, Oracle and Websphere MQ for our UniVerse Customer. Any other data type or application is possible with this technology. We have add-ins to this product that let you execute READ, WRITE etc directly to the Relational database from within your DataBasic line of business logic. Let me know if you would like more information. Thanks Janet 1.866.266.2326 x159 [AD] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Caminiti, Marc Sent: Tuesday, February 26, 2008 11:22 AM To: u2-users@listserver.u2ug.org Subject: [U2] - Websphere MQ Not sure if this is the right place to ask, but I was wondering if anyone had any feelings/thoughts on Websphere MQ and integration with uniVerse. We are currently running uniVerse 10.0.9 on Red Hat Linux If you wish, you can respond off line too. Thanks in advance Marc Marc Caminiti IS Manager Nashbar Direct, Inc 6103 State Route 446 Canfield, OH 44406 330.533.1989, ext 336 330.702.9733, fax Obey gravity, It's the law! --- 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] RE: Switching from D3 to U2
Hello Mark, Drop me an email at [EMAIL PROTECTED] and I will provide you with this document. I cannot publish this on the list without marketing approval, but, I can send it to you directly. Thanks Janet From: [EMAIL PROTECTED] [EMAIL PROTECTED] On Behalf Of MAJ Programming [EMAIL PROTECTED] Sent: Thursday, January 31, 2008 4:26 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: Switching from D3 to U2 I too am interested in this comparison. The majority of my clients are D3 yet I have 1 or 2 UV and UD clients, hence the straddling. I know that U2 products have many more technical features but I would like to see where it gets admin heavy versus D3. Thanks Mark Johnson - Original Message - From: Janet Bond [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, January 30, 2008 12:26 PM Subject: [U2] RE: Switching from D3 to U2 Hello George, We created a report comparing D3 and the U2 products along with other available MultiValue databases for one of our customers. Please email me directly and I can provide this content to you. Thanks Janet Bond FusionWare Corporation IBM Premier Business Partner Microsoft Gold Partner www.fusionware.net -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Land Sent: Wednesday, January 30, 2008 5:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Switching from D3 to U2 I am in the process of putting together a document to support the case for switching an application from D3 to U2 but my knowledge of D3 is a little old and hazy. Has anyone any product or technical justifications for switching over that they would be willing to share? Thanks George Land APT Solutions Limited IBM U2 UK Distributor www.u2uk.com ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately on +44 (01952) 214000 or at [EMAIL PROTECTED] . Please delete and destroy any copies in any format of this email you may have received in error. The recipient should note that the views contained or expressed within this correspondence do not necessarily reflect those of APT Solutions Limited , it subsidiaries, affiliates or associates. This email and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message or any attachments will not adversely affect their systems or data. Registered Office:- Stratum House, Stafford Park 10, Telford, Shropshire, TF3 3AB Registration Number:- 2228445 Place of Registration: England Wales ** --- 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/ --- 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/
[U2] RE: Switching from D3 to U2
I guess an email would have been helpful. Sorry. [EMAIL PROTECTED] -Original Message- From: Janet Bond Sent: Wednesday, January 30, 2008 9:27 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: Switching from D3 to U2 Hello George, We created a report comparing D3 and the U2 products along with other available MultiValue databases for one of our customers. Please email me directly and I can provide this content to you. Thanks Janet Bond FusionWare Corporation IBM Premier Business Partner Microsoft Gold Partner www.fusionware.net -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Land Sent: Wednesday, January 30, 2008 5:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Switching from D3 to U2 I am in the process of putting together a document to support the case for switching an application from D3 to U2 but my knowledge of D3 is a little old and hazy. Has anyone any product or technical justifications for switching over that they would be willing to share? Thanks George Land APT Solutions Limited IBM U2 UK Distributor www.u2uk.com ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately on +44 (01952) 214000 or at [EMAIL PROTECTED] . Please delete and destroy any copies in any format of this email you may have received in error. The recipient should note that the views contained or expressed within this correspondence do not necessarily reflect those of APT Solutions Limited , it subsidiaries, affiliates or associates. This email and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message or any attachments will not adversely affect their systems or data. Registered Office:- Stratum House, Stafford Park 10, Telford, Shropshire, TF3 3AB Registration Number:- 2228445 Place of Registration: England Wales ** --- 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/
[U2] RE: Switching from D3 to U2
Hello George, We created a report comparing D3 and the U2 products along with other available MultiValue databases for one of our customers. Please email me directly and I can provide this content to you. Thanks Janet Bond FusionWare Corporation IBM Premier Business Partner Microsoft Gold Partner www.fusionware.net -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Land Sent: Wednesday, January 30, 2008 5:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Switching from D3 to U2 I am in the process of putting together a document to support the case for switching an application from D3 to U2 but my knowledge of D3 is a little old and hazy. Has anyone any product or technical justifications for switching over that they would be willing to share? Thanks George Land APT Solutions Limited IBM U2 UK Distributor www.u2uk.com ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately on +44 (01952) 214000 or at [EMAIL PROTECTED] . Please delete and destroy any copies in any format of this email you may have received in error. The recipient should note that the views contained or expressed within this correspondence do not necessarily reflect those of APT Solutions Limited , it subsidiaries, affiliates or associates. This email and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message or any attachments will not adversely affect their systems or data. Registered Office:- Stratum House, Stafford Park 10, Telford, Shropshire, TF3 3AB Registration Number:- 2228445 Place of Registration: England Wales ** --- 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] Domino and Unidata [AD}
Hello Charles, The FusionWare connectivity products have always worked with Lotus databases. I can setup a conference call for you with one of our developers if you are interested. Let me know. Janet Bond 1.866.266.2326 x159 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, November 08, 2007 6:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] Domino and Unidata Has anyone had experience accessing Unidata databases from Lotus Domino databases? Are the Uniobjects COM libraries callable from Domino Agents, or is there a better way? I need to populate Notes record's fields with data from Unidata. Documentation, etc would be greatly appreciated. Charles Shaffer Senior Analyst NTN-Bower Corporation --- 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] Universe Benchmark Email --BIG user count
Hello Ross, here is the reference we use in supporting proposals. Hope this helps Janet This improved stability and a capability was highlighted in a article in DataBase Trends (ftp://ftp.software.ibm.com/software/data/u2/pubs/ibmdb2_3-06.pdf ) where: Since then, IBM has invited PDSC to bid on developing other service-related applications. As a part of that process, PDSC has run benchmark tests for its technology. In one case, running on an IBM server, a PDSC application managed over 15,200 concurrent callers in a system with over one billion call records. The result of the bid is that IBM's call center is now moving to this UniVerse application. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Tuesday, November 06, 2007 1:03 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Benchmark Email --BIG user count There was a presentation on this in the U2U - I will email it on to you Ross. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: 06 November 2007 03:10 To: u2-users@listserver.u2ug.org Subject: [U2] Universe Benchmark Email --BIG user count I know IBM did a benchmark in the last 12-18 months for a call centre application (Lenovo) and someone (Wally?) posted a brief note to the group about 15K+ users ... I'm trying to locate for a presentation tomorrow, but can not find Is this in an online archive, or could someone sheet me an original so I can include relevant details thanks! Ross Ferris Stamina Software Visage Better by Design! --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD}
Hi Baker, In response to: make an almost convincing argument to do it on the dedicated target If the target is another shared system, then it is often not a good candidate for this type of thing. I guess what I've often seen is a dedicated processor on a workstation that was used to transfer data. If this system uses multithreading so you don't get a store-and-forward end-to-end delay then it becomes an excellent candidate for doing the transformation. In response to: I honestly raised an eyebrow at your thought that non-MV DB could transform MV data better/faster. I wouldn't say another DB. [AD]I've written extensive Java, C++ and C# (even assembler in my day) code to process MultiValue data, and if you can avoid the overhead of an immutable string problem it is possible to get really great performance. There are some interesting gotchas, but I've had to figure them out a long time ago, and I have a robust, mature library of code that I use for this.[/AD] Robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Wednesday, October 24, 2007 3:04 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD} Thank you Robert and Janet. Overly kind of you Robert to take the time to distill some insights into this reply. You give more consideration to the overhead of data Transformation and make an almost convincing argument to do it on the dedicated target, assumedly something relational/non-MV. The anecdote you give is an interesting one about the benchmark attempt, which sounded half-baked by the MV programmers. I'd still be interested to see a real comparative benchmark with thorough transformation done on the MV side before jettison. [Ad] I've written and extensive ETL myself that was used to normalize/extract MV data from 27 UniData systems [due to their untimely merger-induced demise]. I even used WRITESEQ's instead of WRITEBLK and it was still extremely fast. [/Ad] Most of us have a long history of transformation if we've been doing EDI - flattening our dimensioned data into the ANSI standards. I honestly raised an eyebrow at your thought that non-MV DB could transform MV data better/faster. But you've done a good bit of it and apparently written some things to accomplish it, and I revere your experience at this. hmmm ... maybe the transformation issue (and others you've outlined to a lesser extent) is why it's such a long leap for MV-based BI tools to mash disparate data stores. Sincere regards, -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Janet Bond Sent: Wednesday, October 24, 2007 1:35 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD} As promised here is Robert Houben's input to your question Baker!!! :) For anyone who doesn't know me, I was the lead designer and developer of the PK Harmony product which we demoed at PC Labs at the Spectrum show in 1986 (over 20 years ago!) I've been involved in data communications since the early 1980's and I'm still intimately involved in it, so I think that I have some expertise in the matter! ;) I put the ad marker in so the moderators won't flip. I don't believe that anyone markets PK Harmony anymore (that was another company) so I shouldn't need it for that, but just in case... Also, I may accidentally reference some products that I worked on that my present company markets, so we'll have to comply! ;) What I say here can be applied to any product currently on the market. There are several factors that affect throughput and performance when transferring data between systems (any systems). I'll detail these and then go through them, with some special emphasis for how they are impacted by MultiValue processing. I use SQL Server as the example target. In some cases your target is different, but most of what I say is either still relevant or at the very least, worth thinking about: - I/O bandwidth and contention - CPU speed and contention - Disk bandwidth and contention - Synchronization - End to end latency - Transformation I/O Bandwidth and Contention: = The first thing to look at is I/O bandwidth and contention. There are products that you can get that will allow you to set up two endpoints and push data through, and measure the throughput. If you have a 10MBit LAN, you will never exceed 10 MBits. If you have a busy network, and your two endpoints need to go through multiple routers, you will undoubtedly have less than 10 MBits (or 100MBits) to work with. There is a hard limit, determined by your network environment, to how much data you can push through. Although this is not usually the most limiting factor, I've been amazed when people who had smoking throughput pushing data between two applications on the same machine, are surprised when they lose
RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms (AD)
Hello Baker, We have a customer who is processing tens of thousands of transactions a day. These transactions are centralized on SQL Server so that the Oracle ESB, UniVerse and Web Systems can share the data. The key LOB Application is on Universe, so it drives the live process. Every weekend they transfer millions of records in a large batch to ensure that everything is synchronized. The data flows both ways to SQL and Oracle. This is a Worldwide 24x7 company that is experiencing massive monthly growth, the transactions generate a serious amount of revenue. The environment needs to be fast, stable and scalable. The technology (Legacy to SQL Bridge) can access remote databases from Universe. The tables are viewed as if they are Universe files, records as items and fields as attributes. This lets Universe read, write and select data from the remote databases as if they were Universe files. On our demonstration environment here are the numbers. Using the Legacy to SQL Bridge to transfer data from SQL Server into PICK took about 1.2 seconds for 10,000 rows. Thatbs over 8,000 rows per second. Going the other ways, we were able to get, in the end, about 250 rows per second, as I recall. A better SQL Server configuration would probably have helped. These are actually very modest numbers, when you consider the configuration that was running: b Everything was running on a Lenovo Laptop: o Intel Centrino Duo o 2 GB RAM o 100 GB Disk (very full, fragmentation moderate) b Windows XP Professional b SQL Server 2005 b Microsoft Virtual PC 2004, running: o Red Hat Enterprise Linux 3: o' Universe 12 might have been 11? o' FusionWare Integration Server with the Legacy to SQL Bridge Everything was vying for CPU and I/O on one system, and we had the overhead of Microsoftbs Virtual environment (not known to be best of breed at this point). So, in an ideal tuned environment, the numbers could be much better. Then again, in a real-world environment where both your MultiValue and your SQL systems are shared, overloaded, hardworking systems, these numbers may still be about right. Hope that is useful. Janet /AD -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Thursday, October 25, 2007 12:54 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms Baker, Given the scenario you have just outlined, and my imaginings of the way that each of the 3 systems SHOULD work, you have no likelihood of deadlock collisions (this could be guaranteed with possibly relatively minor tweaks to all sides of the equation). If you want a solution, I just need a few more FACTS (guestimates AOK for numbers) - what is the database behind the WCS system - does the WCS have automated/robotic picking, manual/RF or a combination - average number of line items on a transaction originating from the Universe system - average line items for an order from the web portal - assume you want LIVE inventory on the portal (may be reasons why this is BAD, but that is another story) - peak transactions/hr from OLTP web portal Baker, I know you mean well, but I'm just questioning the need for Fastest in this scenario, unless I see some seriously LARGE numbers for some of the above :-) Ross Ferris Stamina Software Visage Better by Design! [ad] BTW, we also do applications, covering areas like web ordering, warehousing, distribution etc just for the record, and have had to tackle issues like this before [/ad] -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Thursday, 25 October 2007 12:20 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non- MV dbms Ross, Yes, there is a real-world application to the question, at least one where I may try to 'sell' the solution after the theory is worked out. 3 Different systems play with the same live Inventory of products: a UniVerse based OLTP, a MS SQL db based web-order portal, and a Warehouse Control System which fills the orders and receives stock. At night we batch the daily stock receipts from WCS up to UniVerse, update the Avail to Sell qty for the OLTP and allocate Order Reserve Qty to backorders. Then UV sends the updated ATS to the web database (which is always 24 hours behind). Ross has asked the most astute question in all this, that of data collisions, where the same product is updated on 2 or 3 sides at once. This is perhaps the question that looms largest and keeps people (like us) in batch mode rather than real-time. Thanks everyone for the very worthy contributions to this science. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Wednesday, October 24, 2007 1:58 AM To: u2-users
RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD}
their MultiValue data, and pushed it raw to a file on disk at the other end. Then they tried to compare that to what we were doing. The problem with that approach was that they had MultiValues and SubValue marks, they had dates, times, masked decimals and other unusual constructs that were meaningless to any non-MultiValue target that they could have chosen. Needless to say, their home-grown benchmark app outperformed our product. It also happened to be a meaningless comparison. [/AD] Someone has to process the MultiValues, SubValues and data types. Doing it in BASIC, which on all MultiValue systems is a stack-based language has performance issues associated with it. If you are familiar with the Immutable string issue in Java and .NET and the reason why you use StringBuilder or StringBuffer classes to process changing strings in these languages, MultiValue BASIC actually has the same issue under the covers. It also garbage collects, so the comparison is amazingly accurate. Doing this on the MultiValue side causes performance problems. Evolution of MultiValue Data Transfer: == So, in the evolution of data transfer products that I've been involved in over the years, a number of milestones have been reached, and these are some of them: Serial I/O Replaced with TCP/IP: The original PK Harmony (and even original ODBC) products allowed you to use Serial I/O to communicate with the MultiValue systems. In many cases, that was the only available way at the time. There were problems with buffer sizes, and lossy boundaries in Serial I/O, that required you to have an error correcting packeting structure at both ends. This meant that you were doing this type of stuff in MultiValue/BASIC. Yuck!!! The move to TCP/IP for communications allowed us to stop worrying about these things and just stream the data out with minimal packeting structure. ANSI SQL: = Relational products require a relational engine. That engine must reside on the database. The transformation effort of taking a complex ANSI compliant SQL statement and translating it to run *correctly* on a MultiValue system often overshadows all other performance characteristics. Some products in the past have taken shortcuts. These shortcuts result in SQL Statements that return inconsistent results, depending on the fields you reference (MultiValue/SubValue counts change). If you don't take the shortcuts, you get hit with performance. Sometimes you just can't win... :( Shared Resources vs. Dedicated: === [AD]We finally made a decision to produce a product set that did not require ANSI SQL, that allowed us to push the raw data and a metadata record (from our mapping tool) to the dedicated resource, so that the dedicated resource could do the heavy lifting. This was our Direct product set. We feel that this hits the sweet spot.[/AD] The Sweet Spot: === Over my more-than 20 years of MultiValue data communications, I've come to see a certain set of characteristics as a sweet spot. Here, for what it's worth, are those characteristics of a data transfer solution: - Favor dedicated resources to shared - Do transformation on the dedicated resource - Streaming I/O using transport layer - As little packeting structure as possible - Avoid imposing ANSI SQL on MultiValue - recognize the differences and get over them - Think about synchronization issues - they may be unavoidable, but where they aren't they can cost you big time - Use multi-threading to mitigate end-to-end delay Robert Houben CTO Logo: FusionWare Corporation - Enterprise Service Bus (ESB), Service-Oriented Architecture (SOA) 604-633-9891 #158 mailto:[EMAIL PROTECTED] http://www.fusionware.net /AD -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, October 23, 2007 12:15 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms Janet, snip/ I can setup a conference call with one of Developers. We have been in the transferring MultiValue data to other data sources since the early 80's (PK Harmony to start with, anyone remember). We may have some good input for you. /snip I'm not in a position to buy anything, really just trying to think through the questions posted. It would be lovely to have your developer join the thread and describe how PKH/FW does it's magic. Not expecting him to share code, of course, just a few thoughts about your approach is all. Sorry to draw you into the cross fire, that's why I said what I did about ads; maybe I should've put it at the top though. sincere regards, -Baker --- 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
RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]
Hello Baker, Please email me. I can setup a conference call with one of Developers. We have been in the transferring MultiValue data to other data sources since the early 80's (PK Harmony to start with, anyone remember). We may have some good input for you. Thanks, Janet Bond FusionWare Corporation Sales Operation Manager 1.866.266.2326 x159 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, October 23, 2007 8:58 AM To: u2-users@listserver.u2ug.org Subject: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms Hey, What is the fastest and lowest cpu overhead method of transferring data between U2/MV databases, and other data sources? Assumed: a) no restrictions on underlying OS - whichever best facilitates your proposed method. b) no restrictions on Database of choice - I know this is a U2 list and we all have commitments to it, but if someone else (QM, Cache, D3...) is doing something that we ought to be doing in U2, name the db and feat they are accomplishing. C) Production system - the system must also support your OLTP users, not dedicated to data serving The primary concern is throughput, screaming fast throughput. Dogs that won't hunt: 1) if you want to take a potshot at methods that are in your estimation - tired dogs - take aim. 2) beneficent and ruthless honesty - so that this doesn't descend into a religious war please be honest yet charitable. 3) No Ads - don't respond with [just] a product name, tell what it does, the underlying method / technology We are after the technically superior destination, emotions aside, barring past development investments. I'm trying to take a clean white board approach to this question and appreciate your help in answering it. A few to consider [just as starters]: i) old jacks - WRITE/READBLK from MV triggered by whatever signal/method ii) Ajax - Async jscript Xml iii) ODBC / JDBC Thanks so much, -Baker --- 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] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]
I added it in the Subject should it be somewhere else? Please accept my apologies if I have offended anyone. Janet -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Moderator Sent: Tuesday, October 23, 2007 11:15 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD] Janet, When posting as a vendor or service provider, please use [AD] brackets [/AD] in your response as a courtesy to others. - Charles Barouch, Moderator Janet Bond wrote: I can setup a conference call with one of Developers. We have been in the transferring MultiValue data to other data sources since the early 80's (PK Harmony to start with, anyone remember). We may have some good input for you. --- 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] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]
[AD] Okay, let's play nice Chuck did say he missed the last letters of the subject. I will have Robert/Antoon Houben provide a comment for you all as they have a wealth of information and history with MultiValue systems. /AD Thank you, Janet -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George R Smith Sent: Tuesday, October 23, 2007 3:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD] Gee Janet all you had to do was put This is not an ad, it's a fact of business in your posting and you would have been alright. grs -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Janet Bond Sent: Tuesday, October 23, 2007 1:37 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD] I added it in the Subject should it be somewhere else? Please accept my apologies if I have offended anyone. Janet -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Moderator Sent: Tuesday, October 23, 2007 11:15 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD] Janet, When posting as a vendor or service provider, please use [AD] brackets [/AD] in your response as a courtesy to others. - Charles Barouch, Moderator Janet Bond wrote: I can setup a conference call with one of Developers. We have been in the transferring MultiValue data to other data sources since the early 80's (PK Harmony to start with, anyone remember). We may have some good input for you. --- 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/ --- 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] Universe and Microsoft Data Transformation Services (SQL Server)
Hello Marcos, Please contact me I can connect you with our developers to review this process. Thanks Janet Bond FusionWare Corporation Sales Operation Manager 1.866.266.2326 x159 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Saturday, October 20, 2007 1:29 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe and Microsoft Data Transformation Services (SQL Server) Hi, I am trying use the Microsoft Data Transformation Services (SQL Server) to get some records from a Oracle table and put into a Universe file, but when I try to connect to Universe it shows to me two errors, after verify the log file I can identify them : UCI SQLSetConnectOption(NLS) returned -1 SQLSTATE : S1009 Native Error : 0 [IBM][SQL Client]An illegal option value was specified Facility: DBCAPERR Severity: ERROR Error ID: 43 Extern error: 0 Message: Invalid connection or statement option value. UCI SQLSetConnectOption(LOC) returned -1 SQLSTATE : S1009 Native Error : 0 [IBM][SQL Client]An illegal option value was specified Facility: DBCAPERR Severity: ERROR Error ID: 43 Extern error: 0 Message: Invalid connection or statement option value. Somebody know how do I do do solve this problem? Somebody have used Data Transformation Services with Universe? Thanks in advance, Best Regards, Marcos Fogaga. --- 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] Easysoft ODBC driver [ad/solution/sigh]
Hello, We have many products that will move data push or pull data to SQL Server, depending on the skill sets you want to use and your product roadmaps, this will determine the best product for your environment. While it's possible to pull from SQL Server, you may well wish to control the push from a Universe/BASIC program. In that case, FusionWare has a bridge product that allows you to use an API (BASIC Subroutines) to do the equivalent of BASIC's OPEN, READ, WRITE, DELETE as well as the equivalent of TCL SELECT and COPY, to/from SQL Server, Oracle, DB2, MySQL and other databases. If pull from SQL is not what you are looking for, as we mentioned above, then we have other solutions that could help you, including FusionWare Direct ADO.Net provider. [/AD] Please contact me if you would like further information. Thank you, Janet Bond FusionWare Corporation 1.866.266.2326 x159 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: Wednesday, September 12, 2007 7:01 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Easysoft ODBC driver [ad/solution/sigh] Brenda Price wrote: We will only be using to from UniVerse to access a MicroSoft SQL for our credit card numbers this is due to PCI compliance and we wanted 1 database for all of our different systems. From the UniVerse side of things, we will have to access the SQL with a batch process 2 times a day, with an average of 2-3000 records. You really don't need to push data from UV to SQL Server, you can pull it at timed intervals (seconds to hours) and encrypt it for the transfer on the way. This can be done with UO.NET and other tools. You also don't need to hardcode SQL queries into your MV BASIC code. The [ad]: Nebula RD sells mv.NET which is a solution that you have probably not considered for this task, though it can be used to push AND pull data for any connectivity application. Feel free to contact me for information about connecting your UV/UD system to anything, including relational databases. The solution: I have a simple demo ready for anyone who wants to see it which populates SQL Server from any MV DBMS on any OS. This isn't productized, there's no need to productize something as simple as this. It's pulling data from MV without putting SQL into the MV environment or touching data or dictionaries. The data is then put into whatever database you want using whatever functions are available to the RDBMS. I'm using Insert queries to do the initial load and a Stored Procedure for the updates - just to show it can be done. The code can be used to push from MV (over Win/*nix/Linux) or to pull from any middle tier server or workstation. I haven't done any optimization on it yet but so far I'm getting about 385 Inserts per second and 485 Updates per second. That includes the time to connect, sselect, transport, perform queries, and disconnect, and I'm running this regularly with several thousand data items. I'm only doing one update at a time - someone with a clue might suggest updating 100 records or more at a time to improve throughput. Using UO.NET into UV the performance could be even better, I haven't tried yet. As MV people we know how to code and manage our environments but we can leave the RDBMS stuff to the RDBMS DBAs. There's no need to hardcode SQL queries into your MV application, buy a specific driver for some RDBMS, or modify your MV data to look relational. mv.NET is only $260 for a single runtime license. If you are doing your own development it's $635 for the developer license. That includes 2 runtime licenses, so the net cost is only $135 for the developer license - hardly taking anyone to the cleaners... Compare that to the #899 for something like the Easysoft ODBC-Oracle Driver which doesn't have a fraction of the features. Nebula RD provides the current version of all demos for free but without support to Nebula RD clients. Nebula developers can work with clients to enhance the demos or develop new solutions - this is where we derive our income, not really on sales of tools. More info about mv.NET starts here: remove..this..pleaseNebula-RnD.com/products/ And now, the sigh. Sigh. Thanks for your time. Tony Gravagno TG@ removethisNebula-RnD.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] coldfusion login errors with universe [AD]
Hello, This most likely will not be the response you were hoping for but I thought I would let you know that Fusion Direct Java Data Adapter works seamlessly with ColdFusion. Please contact me if you would like further information. Thanks Janet Bond 1.866.266.2326 x159 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Moderator Sent: Monday, September 10, 2007 12:36 PM To: rsaassoc; u2-users@listserver.u2ug.org Subject: [U2] coldfusion login errors with universe REPOSTED FOR NON-MEMBER ADDRESS: rsaassoc [EMAIL PROTECTED] Bounce Notice: If you read this list through Indexfocus, Nabble, or any other replicator - and you would like to be able to participate - sign up directly with us. Here's all you need to know: To subscribe or resubscribe please visit http://listserver.u2ug.org/. Anyone have any idea. uv 10.2 windows xp coldfusion 7. ODBC works with excel and others. Connection verification failed for data source: u2 java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][IBM][UVODBC][2701920]Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLConnect(); State: IM980; uniVerse code: 0; Msg: [IBM][SQL Client]Remote password is required.. The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][IBM][UVODBC][2701920]Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLConnect(); State: IM980; uniVerse code: 0; Msg: [IBM][SQL Client]Remote password is required.. --- 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] ODBC drivers on RedHat Linux [ad]
Hi Jerry, FusionWare has a bridge product that will run right on Linux. You can call UV/BASIC subroutines to do the equivalent of READ, WRITE, SELECT, COPY(to and from SQL) and SQL Passthru to a SQL Server table as though it were a (single-valued) PICK file. If this would be of interest to you, please let me know and I can provide further information. Best Regards, Janet Bond FusionWare Corporation Sales Operation Manager 1.866.266.2326 x159 [ad] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Thursday, August 23, 2007 5:53 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC drivers on RedHat Linux We are trying to set up UniVerse 10.2 to talk directly to a SQL Server system. After following all of the directions in the UV manuals and the DataDirect docs we can talk to the SQL Server from Linux using the demo program that comes with DataDirect but are unable to connect using UV. As a matter of fact when we relink the library as it says in the UV BCI doc 1-8 we can no longer access the UV accounts and have to relink back to the uvdlls. Jerry -Original Message- From: Andy Pflueger [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 22, 2007 8:12 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ODBC drivers on RedHat Linux Sorry to reply with a question, but... What specific database are you looking to connect to/from through ODBC under Linux? On 8/21/07, Brenda Price [EMAIL PROTECTED] wrote: Does anyone know of an ODBC driver that plays nice with Linux. We currently have an evaluation copy of DataDirect 5.3 and are struggling to get it to work with RedHat Linux Release 3 x86.64 2.4 21-32.EL. --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC drivers on RedHat Linux [ad]
Hi Jerry, Yes, that is exactly what we do , with our product Universe Basic is the client. Janet -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Thursday, August 23, 2007 2:05 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC drivers on RedHat Linux [ad] We want UniVerse to be the client, is that what your product will do? We don't seem to have any problem getting the data from UniVerse, just getting the data from SQL Server using UniVerse. Jerry -Original Message- From: Janet Bond [mailto:[EMAIL PROTECTED] Sent: Thursday, August 23, 2007 11:38 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC drivers on RedHat Linux [ad] Hi Jerry, FusionWare has a bridge product that will run right on Linux. You can call UV/BASIC subroutines to do the equivalent of READ, WRITE, SELECT, COPY(to and from SQL) and SQL Passthru to a SQL Server table as though it were a (single-valued) PICK file. If this would be of interest to you, please let me know and I can provide further information. Best Regards, Janet Bond FusionWare Corporation Sales Operation Manager 1.866.266.2326 x159 [ad] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Thursday, August 23, 2007 5:53 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC drivers on RedHat Linux We are trying to set up UniVerse 10.2 to talk directly to a SQL Server system. After following all of the directions in the UV manuals and the DataDirect docs we can talk to the SQL Server from Linux using the demo program that comes with DataDirect but are unable to connect using UV. As a matter of fact when we relink the library as it says in the UV BCI doc 1-8 we can no longer access the UV accounts and have to relink back to the uvdlls. Jerry -Original Message- From: Andy Pflueger [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 22, 2007 8:12 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ODBC drivers on RedHat Linux Sorry to reply with a question, but... What specific database are you looking to connect to/from through ODBC under Linux? On 8/21/07, Brenda Price [EMAIL PROTECTED] wrote: Does anyone know of an ODBC driver that plays nice with Linux. We currently have an evaluation copy of DataDirect 5.3 and are struggling to get it to work with RedHat Linux Release 3 x86.64 2.4 21-32.EL. --- 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/ --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Sonic ESB Unidata Interoperability [ad]
Hello Andy, There is indeed a difference between SOA and Web Services. Web Services is one way of implementing SOA. It happens that it is the standards-based approach. Sonic, WebSphere and most other products attempt to push you towards their proprietary messaging infrastructure. Although Sonic MQ, WebSphere MQ and all the other MQ's out there all share the MQ initials, they are non-interoperable, and not particularly portable. Using their proprietary infrastructure results in lock-in to their tools. FusionWare has a number of technologies and services that enable you to build out a powerful set of functionality for your MultiValue system. The FusionWare Integration Server is an ESB framework that supports both proprietary MQ such as WebSphere MQ, but also allows you to build out a Web Services, standards based Services Oriented Architecture. FusionWare also provides the Java Data Adapter which allows you to access the FusionWare Direct Data Access Server (DAS) which supports both the JDA and allows you to access your multivalue data from such platforms as Sun's Java Studio Creator, Oracle JDeveloper, Microsoft .NET 1.1 or 2.0 including ASP.NET, Windows Forms, SQL Server Reporting Services (both SQL Server 2000 and SQL Server 2005) and SQL Server Integration Services (SQL Server 2005). Microsoft technologies are accessed through our ADO.NET and Reporting Services providers. FusionWare Server provides easy connectivity to a large number of data sources and silos including (but not limited to): * Almost every MultiValue System * SQL Server * Oracle * DB2 * DB2/400 * RPG programs on iSeries FusionWare Server's approach makes it easy to build out a true SOA, where the service is abstracted from the underlying silos. FusionWare was designed from the beginning to be a great fit for mid-market companies and smaller divisions of large enterprises, that don't have the infrastructure or skills to design, deploy and build out a massive network project. FusionWare Server has been certified on all of IBM's hardware platforms and has received the Ready For Linux on eServer Mark certification. We believe that we are well suited to provide you with a state-of-the-art solution that leverages W3C and OASIS standards to give you the fastest, but longest lasting return on investment with the best TCO. We have provided a few articles to Spectrum over the last year in regards to SOA, ESB's, middleware and Security. I would gladly forward this to you if you would like. We'd love a chance to talk to you about your requirements and let you know about our products and services. Thank you Janet Bond 1.866.266.2326 x159[ad] From: [EMAIL PROTECTED] on behalf of Wally Terhune Sent: Fri 2/16/2007 2:05 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Sonic ESB Unidata Interoperability Web Service Developer is available in UniData 7.1.8 - TODAY. The doc set was re-spun at the time 7.1.8 was released (late December) and includes the web services developer manual for UniData. Wally Terhune U2 Support Architect IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969 Fax: 303.773.5915 [EMAIL PROTECTED] John Jenkins [EMAIL PROTECTED] t.com To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject RE: [U2] [UD] Sonic ESB Unidata 02/16/2007 02:44 Interoperability PM Please respond to [EMAIL PROTECTED] er.u2ug.org Take a look at Web Services in UniVerse 10.2. New facilities (usually) leapfrog between UniData and UniVerse, so UniData should get Web Services pretty soon. If you want a preview it shouldn't be a problem for you to get an evaluation copy of 10.2. Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Pflueger Sent: 15 February 2007 11:49 To: U2 User Group Mailing List Subject: [U2] [UD] Sonic ESB Unidata Interoperability Hello, We are currently looking into implementing a SOA (service-oriented architecture) and in the research phase to determine the best approach for this implementation. Does anybody out there have any particular recommendations for implementing a service bus layer with Unidata? Recently, I've discovered a product Sonic ESB by Sonic Software (http://www.sonicsoftware.com/products/sonic_esb/index.ssp). Has anybody had any experience or know anything about this software and how it might interact with the U2 platform? Thanks in advance for any advice, Andy Pflueger Programmer/Analyst Ivy Hill
RE: [U2] [UV] ODBC connections [ad]
Hi Paul, If you would like to call me I can get you connected with one of the developers to discuss your options. Janet FusionWare Corporation Sales Operation Manager 1.800.266.2326 x1159 [ad] From: [EMAIL PROTECTED] on behalf of I-Rafferty, Paul Sent: Tue 10/31/2006 1:21 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] ODBC connections Thanks for the updates. Unfortunately Easysoft do not sell odbc drivers for Universe. We have decided to use one of the Oracle databases on Windows as a gateway to the Universe database. It seems to be the easiest way at this stage. Thanks again. Paul. -Original Message- From: Adrian Merrall [mailto:[EMAIL PROTECTED] Sent: Tuesday, 31 October 2006 10:16 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] ODBC connections Also on your Universe on HPUX via odbc you will need an HPUX driver either 32 or 64 bit. You can get this from http://www.easysoft.com http://www.easysoft.com/ I think from reading the OP Paul needs a Linux ODBC client that can speak to Universe on HPUX. If IBM only provide a windows based odbc client for Universe then he might have a problem here. A solution may be to use the JDBC driver provided by IBM as Janet suggested but use a odbc-jdbc bridge so the Oracle client can use ODBC. A quick google shows one from easysoft and one from Sun as part of the java stack. Plan B is to talk directly to the Universe jdbc driver of course but if you are going to be writing java code then consensus on the list is usually to use uniobjects directly. HTH Adrian --- 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/ [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Multivalued datatypes considered harmful | The Register
This is our CTO at FusionWare Robert Houben's thoughts on the article. Robert is the Grandfather of ODBC, he created the first published ODBC driver outside of Microsoft and has been creating integration products for the Multivalue database since the early 80's, anyone remember PK Harmony. Enjoy! So here is the real problem. The author of the article explains why the multivalues make life so much easier for developers, then tries to explain why they are bad anyways. Here is the snippet where he does this: Fair enough. So let's look at an intensely practical reason why multi-valued fields are so bad. We query databases using SQL. The design of SQL is based entirely on the assumption that each column contains atomic values. If we run a normal SQL query against our single table solution: SELECT FName FROM CUSTOMER WHERE Hobby = Rollerball It will return zero rows; despite the fact that one of our customers plays rollerball, because there is no row with a field just containing rollerball. - end of quote - So this is the problem with his logic. The SQL SELECT statement was designed to work within the constraints of a single-valued first-normal-form environment. To predicate an argument against multivalues on the basis of a query language that assumes their non-existence is disingenuous. I'm surprised that a thinking person would do this. As *we* know, users can build very powerful, complex queries using the PICK LIST/SELECT syntax that accounts for multivalues, and the above observation is just plain bogus. There are other things wrong with the article, but the most compelling issue is that with the emergence of XML as a mechanism for processing complex data sets, multivalues have been reintroduced and are here to stay. If you look at it, both XPath and XQuery understand multivalues and allow you to build complex predicates that operate at the multi, sub, and sub-sub level. There are at this point MANY data environments where this takes place, including the DataSet object in ADO.NET and proprietary data objects from other vendors, which use XML as the underlying structure and allow nesting to take place. What Microsoft is doing with Access is simply to recognize the reality that many developers are already using XML to work around. The author's claim that we query data with SQL is no longer true. I would argue that XPath and XQuery are emerging as powerful, standards-based alternate query languages. Ignore them at your peril! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata 6 into SQL 2005 [ad]
Hello Graham, We have many customers moving MultiValue data to SQL Server or relational databases. We have two products, FusionWare Relational ODBC Driver Edition or FusionWare Direct mv2SQL. These two products have less developer time required If you have VB developer skills accessible to you could consider FusionWare OLEDB driver or FusionWare Direct ADO.Net Provider as an approach to this project. Just a note, the more code you include with your project you create an increased internal support factor as well. IF you are moving the data in one direction MultValue to Relational then I suggest you use the mv2SQL product it is much faster and uses newer technology (OLEDB) and has User Interface for setting up transfers. Lastly this product can be scheduled in SSIS or DTS. As you may be aware when using an ODBC technology the data is flatten during the transfer process, this has a performance penalty. Good Luck Janet Bond [/ad] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Angelo Collazo Sent: Wednesday, June 21, 2006 8:40 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata 6 into SQL 2005 Graham, If you are running your U2 database under Windows, You can download the CLIENT(s) and use the native U2 ODBC drivers. See this link: http://www14.software.ibm.com/webapp/download/search.jsp?go=yrs=u2trial sS_ TACT=105AGX11S_CMP=DNLD If your are running under UNIX you to purchase one. Two I know of. 1- http://www.easysoft.com/ 2- http://www.datadirect.com/index.ssp 3- Open source (http://www.mysql.com/) and search for ODBC. Two versions UNIX(AIX/HP/Others) and Linux unixODBC) May the force be with you. Cheers, Angelo Collazo System Administrator Silver Line Building Products Corporation One Silver Line Drive North Brunswick NJ, 08902 [EMAIL PROTECTED] Ph: 732.435.1000 X4495 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 9:22 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata 6 into SQL 2005 Does anyone have any advice for which odbc drivers are best for importing Unidata data into a SQL 2005 database? Thanks Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Tuesday, June 20, 2006 2:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] .net - universe 10.1.14 Redback and .Net work perfectly together. I've used it in a variety of applications using both C# and VB.Net. Full power of .Net is available as Redback simply makes U2 available. You can build a Data Access Layer where U2 looks like any other database to .Net. If you are from the .Net/SQL world, you can access your Universe data via ADO same as other databases. If you are not an ADO guru, Redback provides its' own more U2 friendly commands to also access the Universe data and programs. You have total freedom in deciding how much or how little of your business logic to be in U2 or .Net. Unlike like some of the other offerings, Redback is not a 'do something on the web for the U2 programmer' type of application. It is a true enabler to allow you to use U2 with the web and do whatever you can do in your web technology of choice. Mike. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Tuesday, June 20, 2006 3:30 AM To: U2-Users (E-mail) Subject: [U2] .net - universe 10.1.14 Apologies I asked this before then went on tour for 3 weeks and my wonderfull staff cleared by emails So I am looking to tie Universe 10.1.14 to a .net development I am looking at biztalk and redback and one other piece of software to facilitate this Any experiences/opinions will be gratefully received (and read this time) Bob Witney IT Senior EXPLORE! Nelson House 55 Victoria Road Farnborough Hampshire GU14 7PA, UK Tel: 01252 379489 Mob: 07973 451156 www.explore.co.uk __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- 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/ --- 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/ --- u2-users mailing
RE: [U2][UV] Universe and SQL Server
Hello, We have product called mv2SQL, it was designed to move data from the MultiValue database to SQL Server, Oracle, DB2 or mySQL. We have many customers moving high volumes of large items with multi-values and sub-values. There is a user interface with this product to create the Select for the data to be transferred, once complete you can process immediately or save the process and schedule to run in DTS. Please visit our Web site or call me for further information if you have questions. Best Regards, Janet Bond www.fusionware.net 1.866.266.2366 x159 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, February 02, 2006 7:30 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2][UV] Universe and SQL Server The BEST WAY?? Is always my way of course chuckle. ... you might also consider the HTTP/XML type options. One of the lads here is experimenting with a Web Service, using the UniVerse SOAP API and SQL2005, we're also currently using SQLXML quite successfully to update SQL2000... Stuart __ Hello all, We are currently looking into ways to share our data between universe and SQL Server, and I am trying to get some suggestions on the best way to do this. We are currently generating text files in UV and ftp'ing those files to a designated location. We have a task scheduler that picks up the files when they arrive and inserts them into SQL server. I know there are ways to communicate directly between SQL server and Universe and I am looking for the best way to do this. It doesn't matter if Universe reaches out to SQL Server or vice versa. Thanks. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- 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] Data Warehousing packages
Hello Bruce, At FusionWare Corporation we have a number of different options for reporting and creating Data Warehouses. Please visit our Web site or give me a call. All the Best, Janet Bond www.fusionware.net 1.866.266.2326 x159 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Knutson Sent: Tuesday, April 25, 2006 9:44 AM To: [EMAIL PROTECTED]; u2-users, Subject: RE: [U2] Data Warehousing packages Try checking out www.mits.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 10:44 AM To: u2-users, Subject: [U2] Data Warehousing packages We are currently running UniData 5.2 on Unix. (I know, I know, I've been pushing for an upgrade.) Anyway, my boss wants us to get into data warehousing for data storage and reporting purposes. And, of course, with a nice front end for the users to get AdHoc reports, graphs, etc without involving the IT staff. There have been salesmen who have been discussing their non U2 solutions with her. I jumped in and said we could probably get a U2 friendly solution. That's where this email comes in. Who has a package that might meet our needs? Suggestions, leads? Thanks, Bruce Bruce M Neylon Health Care Management Group --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Importing Data from Universe into Excel
Hello Dave, We have been integrating Mulitvalue data to Windows, Java and the XML for many years. FusionWare has evolved with all the different standards that have been developed along the way. You have asked for a solution that the customer without having to have a program written for each import to Excel, from this I have two suggestions. First FusionWare Relational ODBC Driver Edtion, this product was the first third party product outside of Microsoft to hit the market. It is proven and very easy to use. This option only requires FusionWare software, some of your time and Microsoft Office. The customer can issue queires directly from Excel without program intervention. The second industry standard that is newer is the .Net world, the FursionWare Direct ADO.Net and or the Reporting Services providers could be options. Please give us a call if you would like further information or visit www.fusionware.net. I am in the office on Monday at 8:00am PST. Good Luck Janet Bond 1.866.266.2326 x159 From: [EMAIL PROTECTED] on behalf of Dave Taylor Sent: Sat 4/22/2006 12:31 PM To: u2-users@listserver.u2ug.org Subject: [U2] Importing Data from Universe into Excel One of my customers is interested in extracting data from Universe into Excel by himself without having to have a program written for each import to Excel. If he learns the names of the files and their dictionaries, and which attributes are multi-valued, or even sub-valued, (and of course Excel), what strategies are available to him - eg. SQL commands, a macro in Excel, Web Services (next rel. of Universe), some reporting product designed to import data from Universe, etc.? The customer is considering a server upgrade using XP Pro, and I'm trying to talk him into W2003, so any strategies that would require IIS or something else that W2003 includes that is not offered by XP Pro will strengthen my argument. I am scheduled to discuss this with the customer again Monday morning about 10:00 AM Pacific Time, so any thoughts you can provide will be greatly appreciated. Many thanks, Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (C) 310-561-5200 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.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] Excel from Unidata
Hi Dave, One idea for you would be to use our FusionWare ADO.Net Provider, using ASP.NET, write an application that calls FusionWare ADO.NET to execute a basic program that returns the data. Then Create an instance of the Excel Object and pump the data from the ADO.NET Dataset into the spreadsheet. Save it. Ship it. Janet Bond FusionWare Corporation 1.866.266.2326 x159 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Tabor Sent: Friday, March 17, 2006 8:39 AM To: u2-users@listserver.u2ug.org Subject: [U2] Excel from Unidata Hi, I'd like to be able to create an excel file from a Unidata program to be used for download on a website, without any user intervention. Can anyone offer any tips/tricks to make this a simple process? Thanks, Dave PS: Unidata 6.0 / AIX 5.1 --- 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] Unidata SQL Joins
Hello Andy, Please give us a call at FusionWare. FusionWare purchased all the Data Access products from GA Express and is a new company with the original people from Liberty Integration. Now that's quite a trail to follow. I guess what I am saying is we have the technology and people to help you move your mv data from a relational or direct perspective. Our number is 1.866.266.2326 x159 Look forward to talking to you Janet Bond -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Results Sent: Monday, February 06, 2006 6:26 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Unidata SQL Joins Andy, I just contacted DataMystic, the folks at Crystal Software, and they have updated the page you referenced. It still listed GA Express and Ardent. Now it lists Fusionware and IBM. Thanks for pointing me to it so I could suggest the changes to them. Andy Pflueger wrote: Is there a more efficent driver for extracting data from Unidata via SQL/ODBC? Perhaps this link would be of some help: http://www.crystalsoftware.com.au/datapipe/odbc_vendors.html -- - Charles Barouch [EMAIL PROTECTED] (718) 762-3884 x 1 P. O. Box 540957, Linden Hill, NY 11354-0957 www.KeyAlly.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] Universe and SQL Server
Hi Nick, We have a few solutions to your project at FusionWare. The most elegant solution is our mv2SQL product. It is very fast, reliable and we have many customers using this product. Your processes can be scheduled with DTS or run live. If you would like further information on this or other solutions please call me at 1.866.266.23.26 x159 Regards Janet Bond FusionWare Corporation Development 409 Granville Street, Suite 1155 Vancouver, BC V6C 1T2 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: Thursday, February 02, 2006 1:41 PM To: u2-users@listserver.u2ug.org Subject: [U2][UV] Universe and SQL Server Hello all, We are currently looking into ways to share our data between universe and SQL Server, and I am trying to get some suggestions on the best way to do this. We are currently generating text files in UV and ftp'ing those files to a designated location. We have a task scheduler that picks up the files when they arrive and inserts them into SQL server. I know there are ways to communicate directly between SQL server and Universe and I am looking for the best way to do this. It doesn't matter if Universe reaches out to SQL Server or vice versa. Thanks. Nick Cipollina Pick Programmer ACS Heritage, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804)644-8707 x 314 --- 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/
