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/
