I am looking for the method to extract U2 into the format SQL server
can read and recognize MV-SMV format and convert to 3NF in SQL. The
project purpose is to build a Data Warehouse and be able to pull the
data daily, possibly only get the delta (change data capture) or even
to have data instantaneously (real time) available in SQL server. I am
trying to avoid triggers on U2 side. They compromise the performance
of base U2 account in our world. However, the base pull U2 into SQL
daily will be just fantastic.

Hi Anglea,

I know that it would mean introducing another layer, but you might be
able to use OpenInsight's U2 Connector and then the built in Data
Warehouse facility to do exactly what you are looking for.

http://www.revsoft.co.uk/openinsight_for_u2.aspx
http://www.revsoft.co.uk/downloads/w...arehousing.pdf

M.

On 9 June, 17:16, Angela Ruzhansky <angela.ruzhan... (AT) gmail (DOT) com> wrote:

On 2010-06-09 12:16:51 -0400, Angela Ruzhansky
<angela.ruzhansky (AT) gmail (DOT) com> said:

Two products that come to mind are :

Conduit from Brian Leach Consulting, and mv.Net from Bluefinity.

http://www.brianleach.co.uk/pages/conduit.htm

I believe that with Conduit you would have to use DB triggers, but I'm
not 100% sure. It is specifically designed for U2.

mv.Net would require that you build your own solution around their
connectivity product.

http://www.bluefinity.com

There are other ways to build a solution without mv.Net. It could be
simple to sophisticated. It all depends on the availability of skills
and resources.

--
Kevin Powick

Angela Ruzhansky wrote:

See:
<nospamNebula-RnD.com/blog/tech/2010/01/sql-server-and-mv-part-1.html>
Please remove the NoSpam part.

That's not a solution but I hope it will change your thinking to make
a solution more obvious to you.

There I describe a solution that I wrote which is now in production:
It dynamically "discovers" a RDBMS schema and generates code to move
data between that and a MV app. The end-user site was running as an
automated Windows Service but I think now they have it triggered as
part of another batch process. It's not generic enough yet to sell as
a turnkey solution, but as-is it can still save any site weeks of
development time. Let me know if you're interested.

That article also leads to another called "MV to Anything" which is
related, and I hope worth your time.

Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
Nebula R&D sells mv.NET and other Pick/MultiValue products
worldwide, and provides related development services
remove.pleaseNebula-RnD.com/blog
Visit PickWiki.com! Contribute!
http://Twitter.com/TonyGravagno

On Jun 10, 1:18*am, Tony Gravagno
<address.is.in.po... (AT) removethis (DOT) com.invalid> wrote:
why did i bother

sure i gave that code away

sure why?

sure i could have founded a company out of that code sure i gave it
away

sure you still ignore the solution i gave it here

and you ignore because youre idiots

this place is finished

do not bother to read here anyone who wants to learn about computing

its finished

you lot are all idiots

this thread is was terminated in 2001

what a lot of morons

fisher inc private enterprise software solutions you are idiots

i absolve this place

you idiots

re: subject morons i posted code here to solve that in 2001 you won't
admit it because it came from me (fisher) --- and that is why i blew
my top at the time - further from the agencies who do not know code

ignored

why did i bother

thread terminated

you idiots

news channel terminated

well fuck you

you won't mention my solution to that fuck you

you're all idiots

what a lot of morons

On Jun 10, 1:18*am, Tony Gravagno
<address.is.in.po... (AT) removethis (DOT) com.invalid> wrote:
gravagno you're an asshole

On 10 June, 01:18, Tony Gravagno
<address.is.in.po... (AT) removethis (DOT) com.invalid> wrote:
yer an idiot gravagno you will be finished soon

i know you wrote virusi into your solutions

you will not ever be corporately employed

you are a criminal you told me you told me you hack banking systems

you told me that everything you do is to infiltrate corporate systems
and steadily steal money never could be trusted you laughed you told
me all about it

said that whatever you did would be used and they wouldn't know about
it

big corporations you said you program for you said they never would
know it was a secret

remember tony? 18th may 2003 we met in a pub

you were telling me how to hack that bank

thanks for all the data tony

tony are you still working?