Hi Chris
I would investigate Tony's product first - that may well save you a bunch of
work. I'm generating OpenXML from a number of different places - so if your
requirement is for UniVerse only I'd look to Nebula and see if it covers
your needs.
If you do find afterwards that you still want to
Brian,
I really appreciate the reply. I'm going to spend some time over the weekend on
this.
I'll probably give Tony's product a try first and then go from there.
Thanks!
-Chris
From: br...@brianleach.co.uk
To: u2-users@listserver.u2ug.org
Date: Wed, 14 Apr 2010 09:48:48 +0100
Subject:
In message 012d01cad820$f3492290$d9db67...@com, Symeon Breen
syme...@gmail.com writes
Absolutely Brian, i agree wholeheartedly - However try having that
conversation with a computer science guro... but then again they don't
live in the real world.
As soon as they mention the word proof
In message
0f0fc5f04b472746b01fa2c4897cf972014314ee6...@excl01.mouser.lan, Baker
Hughes baker.hug...@mouser.com writes
For anyone - what Multi-Value aware / friendly middleware products are there?
(That don't require data normalization before sending to the
middleware.)
Why don't you want
Wol:
What do you consider properly normalized and what example would you give
for designing a new mv FILE as a set of nested tables?
Thanks,
Bill
Anthony W. Youngman said the following on 4/14/2010 8:31 AM:
In message
I installed the new UniVerse (10.3.3) and have installed the Basic Developers
Toolkit from the UniVerse CD and
I'm able to compile and run programs that have already been cataloged. For the
life of me I cannot figure out how
to simply create a new UniVerse BASIC program and catalog it from
It's worth mentioning that NebulaXLite does exactly what Brian
describes, but without the developer needing to touch the XML. I
manage all of that so that the developer just works with BASIC
arrays containing data and style info. The process of creating a
spreadsheet is similar to creating a
Good Day,
I need to update SQL database/tables from Universe, and I was wondering if
anyone has done this in production mode in real-time mode.
I will be updating the files in the legacy platform, and then I need to
perform real-time updates on SQL database.
Best regards,
Ara
Hi Chris:
That version is no longer the current one. You need to download the version
from http://www.rocketsoftware.com/u2/downloads/basicdevelopertoolkit.asp.
I'm using BDT occasionally and it seems to work on Universe 10.3 on Windows.
I have not tried running programs from Eclipse, but they
Via a bar-code gun and an ODBC connection, we are importing UniVerse
data to the SQL in both UPS WorldShip and FedEx ShipManager.
I have my first program, using ORM (Object Relational Mapping -
Hibernate) in Adobe's ColdFusion 9 to read/write data back-and-forth
between UniVerse (on HP-Ux) and
We have a customer who does this in large volumes, both to SQL Server and
Oracle from a Universe system.
They are using a product of ours called the Legacy2SQL Bridge. There are APIs
for doing the equivalent of read/write from BASIC and there are bulk copy
to/from routines as well.
We also have a product called mv2SQL, if you only want to go *to* the SQL
database. Many of our customers use it as an instant data mart/data warehouse
solution.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
If you need UV to initiate the update (UV is the client, SQL is the
server), you're going to need 3rd party middleware to talk to SQL
Server. We do this in near real-time (a batch job runs every 3 minutes
with updates) from UV to SQL 2005 via OpenLink's ODBC middleware.
You'll want to review the
While John's answer is illuminating... One hitch with these 3rd-party
middleware companies is that their products are not inexpensive... And
installation and customization can be a big deal.
When I spoke with Rocket tech support about this a few months ago, the
conclusion was that it would be
Chris,
In the U2 Resource pane (top left by default) open the account and then
database files, go to the source code file e.g. BP, right click and the top
option is New Basic Program. Choosing this lets you enter a name and a template
to use.
HTH,
Andy
- Original Message
From:
Free is definitely less expensive, but your time is probably worth something.
I guess I need to blog about the bridge... :)
The bridge lets you create a dynamic array of data, and pushes it into SQL
Server or Oracle. You have to make the data types match, of course, but
otherwise it works like
Yes, Bill is correct on the expense issue with ODBC middleware. That's
why we opted for batch updates from UV rather than having user sessions
updating SQL realtime. It was a lot cheaper to have a single connection
license. In our particular application, it's the UV database updates
that need
Perhaps I am not understanding some part of the issue, but we regularly
update on-line SQL, Oracle or DB2 from UVBasic, using Universe 10.2 running
on windows, without any middleware. It was just a question of reading the
manuals regarding the steps:
- Set up a System DSN
- Update uvodbc.config
-
If your UV is on windows then this can be done as the DSN/drivers will be on
the UV server. Whereas on Linux/Unix you need a ODBC driver manager and drivers
installed to use the BCI functionality if going to a non-UV database.
-Original Message-
From:
19 matches
Mail list logo
