Re: XML Procesing with SQR

[Ray Ontko <rayo@ONTKO.COM>]

Bruce,

Information on DDO-specific features of the SQR language
are included in the SQR documentation set starting with
version 5.1, I think.

Take a look at the commands ALTER-CONNECTION, BEGIN-EXECUTE
(which has its own flavor of BEGIN-SELECT), CONNECTION,
DECLARE-CONNECTION, and LOAD-LOOKUP.  Also, take a look
at command line option -ZRF.

DDO is Brio's "Direct Data Objects" technology.  It provides
access to a wide variety of data sources, not just relational.
You can use it to access JDBC, SAP/BAPI, XML, CSV, Essbase
OLAP cubes, DCOM, and CORBA.  What's more, it's extensible.
You can write your own drivers to access data in custom
data sources and applications.

When you purchase SQR, you can purchase SQR with the DDO
data source drivers (instead of SQR/Oracle, for example).

Brio ReportBuilder also provides support for DDO, but you
need PersonalSQR/DDO.  Also it can only build JDBC and SAP/BAPI
reports using the report creation wizards and templates.  The
other data source types don't (currently) provide enough catalog
information to be able to work with the report creation wizards.

You can get a copy of SQR/DDO from Brio or any authorized Brio
Reseller.  Ray Ontko & Co is a reseller.  Give me a call 765-935-4283,
or call your Brio sales person.

You should be able to use the UFUNC mechanism of SQR under Windows to
access any Microsoft DLL.  If you want to use OLE directly from
SQR, you'll probably have to take this path.

Ray

[Charset iso-8859-1 unsupported, filtering to ASCII...]
> Thanks Ray,
>
> That what I thought, writing would be easy, but reading would be difficult,
> and yes we will have to read the XML file.
>
> Where do I find documentation and SQR/DDO?
>
> Do you know if SQR support OLE on the windows platform. The reason I am
> asking is because if it does, then I could write an SQR program that could
> manipulate Microsoft's XML parser object and use it for validation?
>
> Thanks
>
> Bruce
>
>  -----Original Message-----
> From:   Ray Ontko [mailto:rayo@ONTKO.COM]
> Sent:   Thursday, April 04, 2002 4:43 PM
> To:     SQR-USERS@list.iex.net
> Subject:        Re: XML Procesing with SQR
>
> Tom, Bruce,
>
> Writing XML is fairly easy to do with SQR using WRITE or PRINT.
> If you're writing your own code (instead of using Brio ReportBuilder
> generated code), you have more control over the structure of the output.
>
> Reading XML is the challenging part.   This can be done with
> SQR/DDO (Direct Data Objects), or you can write your own XML
> parser in SQR.  Brio ReportBuilder doesn't support DDO access
> to XML, so this would need to be written as a regular SQR/DDO
> program.
>
> Writing an XML parser from scratch is fairly complex, even if it's
> a non-validating parser, but it can certainly be done in SQR.  It's
> the kind of program I'd like to write.
>
> If you need read XML with SQR, I'd strongly recommend that you
> look at SQR/DDO.
>
> Ray
>
> [Charset iso-8859-1 unsupported, filtering to ASCII...]
> > Hello,
> >
> > We too are about to produce XML output with v6.2.  I have seen the code
> for
> > XML generated by report builder. Not suprisingly, it's ugly. I intend to
> > begin the XML project in a week or two.
> >
> > -tom
> >
> > -----Original Message-----
> > From: Merritt, Bruce [mailto:Merritt@USCOLO.EDU]
> > Sent: Tuesday, April 02, 2002 2:41 PM
> > To: SQR-USERS@list.iex.net
> > Subject: XML Procesing with SQR
> >
> >
> > Hi All,
> >
> > We are currently using SQR version 6.1.3, and in the near future will have
> > to receive and send data between our system and a third party using XML.
> Has
> > anyone done any XML processing with SQR?
> >
> > Thanks
> >
> > Bruce Merritt
> > University of Southern Colorado
> >
>
> ----------------------------------------------------------------------
> Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
> Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/
>

----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/