Re: [sqr-users] SQR and mySQL database

[Ray Ontko <rayo@ontko.com>]

Hi Dave,

> We are using SQR for PeopleSoft 8.3.  We want to copy some tables from Oracle 
>to mySQL and run SQR against the mySQL database to print online check advices 
>for all employees -- not just PeopleSoft Users.
>  
> Has anyone done this?  Is it possible to run SQR against mySQL?

The SQR that you have with PeopleSoft almost certainly uses 
the Oracle Call Interface to communicate with Oracle.  This is
compiled into the version of SQR that you have.  I don't think
you'll be able to access mySQL using that SQR.  

There may also be a licensing issue: I'm not sure the PeopleSoft 
license allows you to use SQR outside the PeopleSoft application.
I haven't seen the PeopleSoft license agreement, so I don't know
whether your use would be within the terms of the agreement or not.
(And, I'm not a lawyer.)

You can obtain from Brio (or one of its resellers) a license for
SQR/ODBC if you want to access mySQL via ODBC assuming you have 
the appropriate ODBC drivers for mySQL.

Another possibility is SQR/DDO and access mySQL via JDBC.

Ray
----------------------------------------------------------------------
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/

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users