 |  |
ISP List wrote:
Re: ODBC Client that can handle OptiGold''s tables
From: Shawn Hogan
Date: Thursday, December 18, 2003
Time: 12:43:28 pm
> Well, the "suck data" out part seems to be the tough part though. What are
> your "big" OptiGold shops using to do this?
I'm guessing XML... but we don't poll anyone on what they are or are not
doing so...
> Based on my (limited) research today:
>
> 1. ODBC is definitely not a viable option in its currently supported form
>
> 2. The JDBC driver is the next best option, but has a limited set of SQL
> emulation commands. It can't do inner/outer joins (bad), and appears to
> somehow use the Web Companion to do its magic. Also, I'm not clear if even
> with JDBC that I will have access to all the data I want, or if I will
> still be limited by what is contained in the Layouts that you have defined
> (is there a Layout that contains all of the fields in each table?).
>
> 2a. Even if I can get at all the fields, I'm not sure how I will be able
> to perform relationship compares without access to the FM Portals and
> Scripts you have defined that I can't see/get to.
The data model in the support section of our website has all the
relationships for all the tables, in case you are wanting to recreate them
externally...
> 3. The Web Companion is definitely limited by the layouts when using CDML,
> but might not be when using XML (?)
It's also layout specific.
- Shawn
----------------------------------
Shawn D. Hogan
President, Digital Point Solutions
http://www.digitalpoint.com
(858) 452-3696
---------------------------------------------------
To subscribe, unsubscribe or to search list archive
please visit http://www.optigold.com/lists/isp.html
---------------------------------------------------
Return to Digital Point Solutions' Home Page