Groups | Search | Server Info | Login | Register

Groups > comp.databases.pick > #2242

Re: Need to map Universe to SQL

Show all headers | View raw

?"Ed Sheehan"  wrote in message news:iifnm7$hj$1@news.xmission.com...

>Are there tools/techniques/objects to map Universe data to SQL? I have a 
>Universe box and a client with SQL. This is my first exposure to dealing 
>with "flatness" online. I know how to convert data, but I thought there 
>might be some interface which could model/map it on the fly.

>Ed


Most MV systems allow the data to be viewed as logical SQL tables. I not 
done this with Universe, but have done this with d3 systems.

So, any odbc client (including some of the sql server tools) can thus view 
and consume those MV tables as standard sql tables.

In the case of d3, you have to execute a series of sql-mapping commands, and 
once done, then the list of tables will show up as valid tables to the 
standard ODBC connection.

I do not know how/if/what features Universe has, but the above is quite much 
how this works for d3 systems, and I suspect this one time mapping is the 
same requirement for most MV systems.

-- 
Albert D. Kallal
Edmonton, Alberta Canada
Pleasenospam_kallal@msn.com

Back to comp.databases.pick | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Need to map Universe to SQL "Ed Sheehan" <NOedsSPAM@xmission.com> - 2011-02-03 21:18 -0500
  Re: Need to map Universe to SQL "Albert D. Kallal" <PleaseNOOOsPAMmkallal@msn.com> - 2011-02-06 21:55 -0700
  Re: Need to map Universe to SQL "Ed Sheehan" <NOedsSPAM@xmission.com> - 2011-02-04 09:08 -0500
  Re: Need to map Universe to SQL Kevin Powick <nospam@spamless.com> - 2011-02-04 07:44 -0500

csiph-web