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 R&D 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 R&D provides the current version of all demos for free but without support to Nebula R&D 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/