Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS [ad]

[Mecki Foerthmann]

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 attribute in every UniData file and SQL statements to
extract the data, translate and load it into Oracle tables.
With SSIS it's nearly all just drag and drop - no code writing required
- a proper ETL tool!
Unfortunately it doesn't seem to be able to connect to UD 5.2 because
the OLEDB versions from Informix and Microsoft don't want to talk to
each other.
I had hoped somebody here could tell me what string literals are
supposed to be and why I can't get them.

In the meantime they can carry on working with their spreadsheets :-)
And maybe I can convince them to send me to school again, so I can
understand all the buzz-words you throw around.

Mecki

Tony Gravagno wrote:
>> From: Mecki Foerthmann
>>
>> Thanks Tony and Peter,
>>
>> but I don't think yet another piece of software is 
>> what I need. Your product might be useful for some of 
>> your clients, but I don't think it will help solve my 
>> problem.
>> 
>
> That's funny.  I don't have an application and there is no real
> way to categorize our clients, except that they're mostly MV
> developers who had a problem to solve.  Many of our clients have
> come from this forum.
>
> I think you're missing the point of the blog.  It wasn't to sell
> a product (that one isn't ready yet anyway) but to explain how
> I'm able to create a wide range of solutions based on the way I
> approach problems.  If you continue to think of each problem you
> present here as a nail, the only solutions you're going to
> consider are the ones that look like a hammer.  Think differently
> and you won't need to buy other people's solutions, you can
> probably come up with your own.  (That said, the tools I've
> chosen help me to do what I do, and because I'm happy with those
> tools I've chosen to sell them too.)
>
>
>   
>> I don't want to update any MV files, just 
>> load some data into a relational database every night, 
>> preferably as cubes. Setting the MV files up as SQL 
>> tables is not a problem in UD either. I've already 
>> done that and have a reasonably easy to use tool for 
>> that in Avante.
>> 
>
> The point of my blogs is that you don't need to do that, and
> FWIW, this forum is frequented by people who have had problems
> doing that.  So I discourage the approach.
>
>
>   
>> I've even written Basic code to 
>> flatten a file with large multivalues because DTS 
>> UniSQL in UD 5.2 can't handle them properly.
>> 
>
> And you don't need to flatten files either.  :)
>
>
>   
>> This is all trivial stuff. All I want is a cheap ETL 
>> tool that works with UD 5.2, so I can build a 
>> datawarehouse in Oracle and write reports using Cognos.
>> 
>
> mv.NET Solution Objects (one of the libraries in the package and
> not currently used in the solution described in the blog) allows
> you to create strongly typed classes for any application.  You
> can use these with other applications that can make use of
> business rules via an Object Relational Model (ORM).  So the
> external environment doesn't see Accounts or Files or Dicts, it
> seems a Customer class and properties that you've chosen to share
> with specific environments, like Name and City.
>
> My approach would be to create an SDK for Avante (ManFact,
> Dataflo, CUBS, Datatel, SHIMS, or any MV application), then
> create an interface for your external database of choice, then
> create a bridge between them.
>
> Again (refer to my blog) note that the approach here isn't to
> connect X to Y but to get interfaces for X and Y and then connect
> them in the middle.  Then you can use your X and Y interfaces
> with any other project.  If you connect X directly to Y now,
> you'll be here next month asking about W and Z.
>
>
>   
>> I have to use 
>> Oracle and Cognos, I don't have any say in that 
>> matter.
>> 
>
> That's fine, so ETL your data to Oracle as I've described, then
> use Cognos against that if you wish.  What's the problem?
>
>
>   
>> Currently I use SQL Server 2000 and DTS. It 
>> works, but it uses ODBC and is not an ETL tool and 
>> produces only SS 2000 tables! I could of course use 
>> DTS and ODBC to bring the data first from UD to SS 
>> 2000 and then use SSIS to build my datawarehouse in 
>> Oracle, but do I really want to do this?
>> 
>
> No, you're smashing everything with a hammer.  Pull your data
> from Unidata into Oracle and then work directly from there.  Why
> involve SQL Server at all?
>
> OK, here's a completely different approach.  Use MV BASIC to
> generate Oracle-specific SQL queries into an OS file.  Loop on
> your data, wherever the files are, and populate a query template
> for each row of relational data.  Then move those files manually
> or automatically to the oth

Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS [ad]

[Symeon Breen]

  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 understand, and be
prepared to pay for solutions or consulting time from people who
understand how to solve the problems you express.  You (all U2 IT
people) are getting paid for your expertise by a company that is
obviously spending lots of money on the IT infrastructure.  By
insisting you need everything for free and on your own terms
you're just perpetuating the belief of your management that you
don't need a budget while everyone else in the company apparently
does - and they get it.  MV development is cheap and easy.  But
when you need to interface with the outside world, you're not
doing MV development any more and you need to face the same
budgetary and educational concerns as anyone else who works with
the same technologies.

I just think MV people in general need to stop thinking that
somehow they're going to magically understand everything when
everyone else needs to go to school, and that BASIC will solve
every problem.  These beliefs are self-defeating for this entire
market.



Loving it   



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS [ad]

[Lettau, Jeff]

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?  

Performance isn't bad if your limiting your I-desc and keep the data to single 
files in UD.  Also use indexes in your UD views to limit your data.  You can't 
pass variables for data selection this way.  You can limit data by day using 
@date-99 type i-descriptors or just write a quick program to pull your data to 
a temp file, then pull the file for updating things incrementally for Cognos.  

Jeffrey Lettau
ERP Systems Manager
polkaudio 


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
Sent: Thursday, January 14, 2010 3:31 AM
To: U2 Users List
Subject: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS [ad]

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 attribute in every UniData file and SQL statements to
extract the data, translate and load it into Oracle tables.
With SSIS it's nearly all just drag and drop - no code writing required
- a proper ETL tool!
Unfortunately it doesn't seem to be able to connect to UD 5.2 because
the OLEDB versions from Informix and Microsoft don't want to talk to
each other.
I had hoped somebody here could tell me what string literals are
supposed to be and why I can't get them.

In the meantime they can carry on working with their spreadsheets :-)
And maybe I can convince them to send me to school again, so I can
understand all the buzz-words you throw around.

Mecki

Tony Gravagno wrote:
>> From: Mecki Foerthmann
>>
>> Thanks Tony and Peter,
>>
>> but I don't think yet another piece of software is
>> what I need. Your product might be useful for some of
>> your clients, but I don't think it will help solve my
>> problem.
>>
>
> That's funny.  I don't have an application and there is no real
> way to categorize our clients, except that they're mostly MV
> developers who had a problem to solve.  Many of our clients have
> come from this forum.
>
> I think you're missing the point of the blog.  It wasn't to sell
> a product (that one isn't ready yet anyway) but to explain how
> I'm able to create a wide range of solutions based on the way I
> approach problems.  If you continue to think of each problem you
> present here as a nail, the only solutions you're going to
> consider are the ones that look like a hammer.  Think differently
> and you won't need to buy other people's solutions, you can
> probably come up with your own.  (That said, the tools I've
> chosen help me to do what I do, and because I'm happy with those
> tools I've chosen to sell them too.)
>
>
>
>> I don't want to update any MV files, just
>> load some data into a relational database every night,
>> preferably as cubes. Setting the MV files up as SQL
>> tables is not a problem in UD either. I've already
>> done that and have a reasonably easy to use tool for
>> that in Avante.
>>
>
> The point of my blogs is that you don't need to do that, and
> FWIW, this forum is frequented by people who have had problems
> doing that.  So I discourage the approach.
>
>
>
>> I've even written Basic code to
>> flatten a file with large multivalues because DTS
>> UniSQL in UD 5.2 can't handle them properly.
>>
>
> And you don't need to flatten files either.  :)
>
>
>
>> This is all trivial stuff. All I want is a cheap ETL
>> tool that works with UD 5.2, so I can build a
>> datawarehouse in Oracle and write reports using Cognos.
>>
>
> mv.NET Solution Objects (one of the libraries in the package and
> not currently used in the solution described in the blog) allows
> you to create strongly typed classes for any application.  You
> can use these with other applications that can make use of
> business rules via an Object Relational Model (ORM).  So the
> external environment doesn't see Accounts or Files or Dicts, it
> seems a Customer class and properties that you've chosen to share
> with specific environments, like Name and City.
>
> My approach would be to create an SDK for Avante (ManFact,
> Dataflo, CUBS, Datatel, SHIMS, or any MV application), then
> create an interface for your external database of choice, then
> create a bridge between them.
>
> Again (refer to my blog) note that the approach here isn't to
> connect X to Y but to get interfaces for X and Y and then connect
> them in the middle.  Then you can use your X and Y interfaces
> with any other project.  If you connect X directly to Y now,
> you'll be here next month asking about W and Z.
>
>
>
>> I have to use
>> Oracle 

Re: [U2] Connecting to UD from SQL Server

[Brutzman, Bill]

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 to risk waiting for an disappointing surprise.

--Bill

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS [ad]

[Gerd Forthmann]

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 SS 2000 tables with DTS every night is 
so far working OK.

Once I get the upgrade to 7.2 done, I will have the SSIS projects for the 
datawarehouse all in place, only need to change the data source and everything 
should be working just fine.

Mecki

 Original-Nachricht 
> Datum: Thu, 14 Jan 2010 08:43:06 -0500
> Von: "Lettau, Jeff" 
> An: U2 Users List 
> Betreff: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS [ad]

> 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?  
> 
> Performance isn't bad if your limiting your I-desc and keep the data to
> single files in UD.  Also use indexes in your UD views to limit your data. 
> You can't pass variables for data selection this way.  You can limit data by
> day using @date-99 type i-descriptors or just write a quick program to
> pull your data to a temp file, then pull the file for updating things
> incrementally for Cognos.  
> 
> Jeffrey Lettau

-- 
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Cubes

[Charles_Shaffer]

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 the 
dimensions along which data will be gathered from logically-related 
tables. For this to work, data must be denormalized. "

That sounds a lot like an MV database.  Wouldn't MV databases be the 
natural platform for data mining?  Maybe I am oversimplifying.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Cubes

[Lettau, Jeff]

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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
charles_shaf...@ntn-bower.com
Sent: Thursday, January 14, 2010 10:44 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Cubes

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 the
dimensions along which data will be gathered from logically-related
tables. For this to work, data must be denormalized. "

That sounds a lot like an MV database.  Wouldn't MV databases be the
natural platform for data mining?  Maybe I am oversimplifying.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Disclaimer: This email may contain confidential and/or privileged information. 
It is intended only for the person or persons to whom it is addressed. Any 
unauthorized review, use, or distribution is prohibited. If you are not the 
intended recipient, please contact the sender by reply email or telephone and 
destroy all copies of the original message.

Please consider the environment before printing this email.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Connecting to UD from SQL Server

[Gerd Forthmann]

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 and/or unirpc that doesn't fit 
with the new Microsoft OLE DB requirements of SS 2008 - typical Microsoft 
backwards compatibility. 
We already had to install SS 2008 on Windows 2003 because UniDK 3.4 and the old 
Informix ODBC driver wouldn't even install on Win 2008.

Mecki


 Original-Nachricht 
> Datum: Thu, 14 Jan 2010 10:13:55 -0500
> Von: "Brutzman, Bill" 
> An: "U2 Users List" 
> Betreff: Re: [U2] Connecting to UD from SQL Server

> 
> 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 to risk waiting for an disappointing surprise.
> 
> --Bill
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users

-- 
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Cubes

[George Gallen]

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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com
> Sent: Thursday, January 14, 2010 10:44 AM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Cubes
>
> 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
> the
> dimensions along which data will be gathered from logically-related
> tables. For this to work, data must be denormalized. "
>
> That sounds a lot like an MV database.  Wouldn't MV databases be the
> natural platform for data mining?  Maybe I am oversimplifying.
>
> Charles Shaffer
> Senior Analyst
> NTN-Bower Corporation
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Cubes

[Charles_Shaffer]

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

[U2] Encryption errors - don't care

[Baker Hughes]

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 sensitive data has been 
cleansed from the dev db.  Is there a way around this:

Unable to get encryption info (19690) in &ENCINFO&.  and others like it.

Cloudy & 50 in Texas regards,
-Baker





This communication, its contents and any file attachments transmitted with it 
are intended solely for the addressee(s) and may contain confidential 
proprietary information.
Access by any other party without the express written permission of the sender 
is STRICTLY PROHIBITED.
If you have received this communication in error you may not copy, distribute 
or use the contents, attachments or information in any way.  Please destroy it 
and contact the sender.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Speaking of MsSQL 2008 ...

[John J. Wahl]

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 run at 
night?  I had one working on a test server for a while, but it would only run 
in the Management Studio when I manually ran the SQL, it would never work at 
night using Jobs in the SQL Server Agent, so I gave up.  I've never gotten SQL 
Server to directly connect in my office, so they still have their half dozen 
work-arounds here, all using things like Microsoft Access and Linked Tables, 
then finally linking those Access Databases to SQL Server.  I've tried to make 
changes to some of their very duct-tape like solutions, but I too failed to get 
their UniVerse system to be read by SQL Server using any connection type for 
that matter, including Mecki's SSIS concept.

I have one machine here that is running SQL Server 2005 Developer 
edition, which seems to have far more Providers and has had more luck 
connecting to UniVerse in my tests, but once I try to do anything via a nightly 
job, the same queries that may have worked for me manually would fail to 
execute.

Of the 3 servers I have two running Windows Server 2003, and one is 
2008 Std 32-bit.  The 2008 box is also the UniVerse machine, which runs 10.2.x. 
 I'm fairly certain if the Linked Server idea would work, it's an issue w/ 
either using the wrong provider or having a bad string for the Connection, but 
everything I have personally read has failed (at least for UniVerse).

Anyone run into this type of headache in the past?



John J. Wahl
Employee Owner  (and U2 convert, yes I was an Microsoft only guy once *cry*)
Programmer / Analyst 
Tel:   (330) 528-0091 Ext. 118
Fax:   (330) 655-8458
Email: jw...@joseph.com
Web:  http://www.Joseph.com/ 

 Original-Nachricht 
> Datum: Thu, 14 Jan 2010 08:43:06 -0500
> Von: "Lettau, Jeff" 
> An: U2 Users List 
> Betreff: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS 
> [ad]

> 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?
> 
> Performance isn't bad if your limiting your I-desc and keep the data 
> to single files in UD.  Also use indexes in your UD views to limit your data.
> You can't pass variables for data selection this way.  You can limit 
> data by day using @date-99 type i-descriptors or just write a quick 
> program to pull your data to a temp file, then pull the file for 
> updating things incrementally for Cognos.
> 
> Jeffrey Lettau

--
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Speaking of MsSQL 2008 ...

[phil walker]

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 thought

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of John J. Wahl
> Sent: Friday, 15 January 2010 6:16 a.m.
> To: U2 Users List
> Subject: [U2] Speaking of MsSQL 2008 ...
> 
> 
>   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 run at night?  I had one working on a test server for a
> while, but it would only run in the Management Studio when I manually
> ran the SQL, it would never work at night using Jobs in the SQL Server
> Agent, so I gave up.  I've never gotten SQL Server to directly connect
> in my office, so they still have their half dozen work-arounds here,
> all using things like Microsoft Access and Linked Tables, then finally
> linking those Access Databases to SQL Server.  I've tried to make
> changes to some of their very duct-tape like solutions, but I too
> failed to get their UniVerse system to be read by SQL Server using any
> connection type for that matter, including Mecki's SSIS concept.
> 
>   I have one machine here that is running SQL Server 2005 Developer
> edition, which seems to have far more Providers and has had more luck
> connecting to UniVerse in my tests, but once I try to do anything via a
> nightly job, the same queries that may have worked for me manually
> would fail to execute.
> 
>   Of the 3 servers I have two running Windows Server 2003, and one
> is 2008 Std 32-bit.  The 2008 box is also the UniVerse machine, which
> runs 10.2.x.  I'm fairly certain if the Linked Server idea would work,
> it's an issue w/ either using the wrong provider or having a bad string
> for the Connection, but everything I have personally read has failed
> (at least for UniVerse).
> 
> Anyone run into this type of headache in the past?
> 
> 
> 
> John J. Wahl
> Employee Owner  (and U2 convert, yes I was an Microsoft only guy once
> *cry*)
> Programmer / Analyst
> Tel:   (330) 528-0091 Ext. 118
> Fax:   (330) 655-8458
> Email: jw...@joseph.com
> Web:  http://www.Joseph.com/
> 
>  Original-Nachricht 
> > Datum: Thu, 14 Jan 2010 08:43:06 -0500
> > Von: "Lettau, Jeff" 
> > An: U2 Users List 
> > Betreff: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008
> SSIS
> > [ad]
> 
> > 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?
> >
> > Performance isn't bad if your limiting your I-desc and keep the data
> > to single files in UD.  Also use indexes in your UD views to limit
> your data.
> > You can't pass variables for data selection this way.  You can limit
> > data by day using @date-99 type i-descriptors or just write a quick
> > program to pull your data to a temp file, then pull the file for
> > updating things incrementally for Cognos.
> >
> > Jeffrey Lettau
> 
> --
> GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
> Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Still using wIntegrate to copy files?

[Bill Haskett]

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.


On another machine we upload two 1.2Gb backup files across the 
internet to a backup server and each file takes a little over 30 
minutes to transfer.


I'd like to think I've missed something and can improve my times 
dramatically!  :-)


Bill


Symeon Breen said the following on 1/13/2010 3:04 PM:

I know lots of people who use it

The OP's ad concentrates on copying a 41mb file - i regularly copy many
gigabyte files, i just zip em, ftp them and it is all done in a minute or 2,
why would i use wintegrate or an eclipse tool ???

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke
Sent: 13 January 2010 18:42
To: 'U2 Users List'
Subject: Re: [U2] Still using wIntegrate to copy files?

Are many people even still using wIntegrate? I saw this on Rocket's site:

Effective December 31, 2010 the following product versions will move into
End of Life (EOL) status:
.wIntegrate 6.1 and earlier

Isn't 6.1 the current version? Is there another one coming? It appears
Rocket's deal with IBM included ending support on a lot of the older
versions. Is Rocket planning on using one of its products Bluezone??? To
replace wIntegrate? Or maybe an Eclipse based product like they've been
doing with Admin and UniDebugger??? Don't tell me it's going to be Dynamic
Connect

Just curious
Colin Alfke
Calgary, Canada

-Original Message-
From: Doug

[ad]
We at U2logic are continually improving our Eclipse based XLr8Editor.  We
just added the 
multiple clip board option about a month ago.  Today you can copy huge data

sets
from Universe to Universe or Unidata to Unidata or even Universe to Unidata.
 
We can believe it ourselves.  We just copied 41mb file from a client using
Unidata to our Universe 
system in under 3 minutes over the Internet.  That file has over 100,000

records and it would be
a many hour process with wIntegrate.
 
For $49.00 a year you can have this functionality.  Go to

www.u2logic.com/tools.html
and purchase a license.  Following the Quick start instructions in
www.u2logic.com/download.html
and you will be ready to copy and paste huge data sets and have finest
editor for Universe or
Unidata databases.
[/ad]
 
Regards,

Doug
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
  

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Encryption errors - don't care

[Anthony W. Youngman]

In message 
<0f0fc5f04b472746b01fa2c4897cf972011e10a44...@excl01.mouser.lan>, Baker 
Hughes  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 setup identical to the live so 
it serves as a hot backup. We don't have an encryption key loaded 
though since all sensitive data has been cleansed from the dev db.  Is 
there a way around this:


Unable to get encryption info (19690) in &ENCINFO&.  and others like it.

Delete or wipe the error message in the error messages file? Do be 
careful if you try this - I haven't!


By the way, did you post this completely new topic by replying to an 
unrelated message and wiping the subject and message? Please don't! 
Please create a new thread by starting a clean new email for a clean new 
subject.


I know some (broken) mail clients group messages by subject, but there's 
a perfectly good, long-standing and *standard* header code "in-reply-to" 
which is meant explicitly for grouping related messages together. My 
email client uses this which means the above "reply" tactic mixes your 
message in with loads of unrelated messages.


Cheers,
Wol
--
Anthony W. Youngman 
'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man
lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
Visit the MaVerick web-site -  Open Source Pick
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users