Thanks Tony,
but I think I will just wait until I've convinced management to approve
the upgrade to 7.2
I know that release can talk to SSIS.
We are talking hundreds of files here for that conversion and maybe
thousands of Oracle tables, and I don't think I'm going to create
classes for every
snip Tony Said
Here's another common issue in this forum: People express a
desire for a solution but what they really want is a free
solution that they can use, understand, and maintain on their
own. I'm sorry but when you're faced with complex issues, be
prepared for solutions that you may not
You may not want to do this due to volume of data your trying to pull, but...
Have you tried setting up your UD5.2 server as a linked server in SQL, then
creating views to your linked server. Then use SSIS to pull from the views,
that way it doesn't know it isn't a SQL data source?
Mecki:
I would contact Rocket tech support to get their insight on trade-offs
and their recommendation on how to best handle this matter. The two
fellows that I reached there I had not seen on this list before.
I predict that the UD upGrade will exhibit the same symtoms. I see no
good reason
Thanks Jeff,
I might give that a try.
Even though the creating views bit doesn't sound too appealing.
I actually have been thinking to start off by leaving it as is and pull the
data from SS 2000 instead of UD 5.2 directly since the table structure is
exactly the same and the updating of the
I wasn't familiar with the term cube and I did some research. I found
this.
The ideal structure for such storage is a star schema, realized as a
multidimensional cube. In such a structure, tables are related not in the
relational manner of an RDBMS, but by a central key table that defines
http://www.mits.com/index.htm
for U2
http://www.microsoft.com/sqlserver/2005/en/us/Analysis-Services.aspx
for MS SQL
http://www-01.ibm.com/software/data/cognos/
for everything else
Jeffrey Lettau
ERP Systems Manager
polkaudio
-Original Message-
From:
Bill,
I have seen UD 7.2 talk to SSIS without any problems at U2U in Liverpool last
year. So I know it does work.
When I asked if it would also work with 5.2 everybody told me to upgrade.
UniData 5.2 is a dinosaur and no longer supported to boot!
I guess it is the old Informix OLEDB Provider
This is the what OLAP is all about.
http://en.wikipedia.org/wiki/Olap
And as another has mentioned...MITS is one example that was programmed for use
with U2
another term, aside from cube that you will grow to love with OLAP is drill
down
George
-Original Message-
From:
Thanks for the info.
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
The native encryption in UV 10.2 is very nice. But does anyone know the secret
to 'turn off' the encryption errors on our development system? We have the
development machine setup identical to the live so it serves as a hot backup.
We don't have an encryption key loaded though since all
Not to tread over the same path for a thousandth time (oh this poor
path), but has anyone actually been able to get SQL Server 2005 or 2008 to
actually do a linked server directly to UniVerse and still get that link to
work when setting up SQL Agent jobs on the Microsoft SQL Server to
I suspect it may be a security/permissions issue. Have you checked the event
logs?
How have you got security set up for the connection? When you run the job
manually the job will
Be probably using your credentials, when you run as agent job it may be running
as a service account?
Just a
Symeon:
Hmmm, in what universe does zipping a multi-gigabyte file take a
few minutes, let alone zip it up and ftp it? On one of our fast
Windows 2K3 machines we run WinRAR against a nightly 7Gb backup file
in pretty-fast mode and we get a 1.2Gb compressed file in about 29
minutes.
In message
0f0fc5f04b472746b01fa2c4897cf972011e10a44...@excl01.mouser.lan, Baker
Hughes baker.hug...@mouser.com writes
The native encryption in UV 10.2 is very nice. But does anyone know
the secret to 'turn off' the encryption errors on our development
system? We have the development machine
15 matches
Mail list logo